Jumping into 12.2 on Exadata Express is made easy with the packaging up of the client configuration files. Here’s what I had to do to get SQL Plus going into the database
1) Download the client credentials file from the Service Console
2) Unzip the file into a folder
3) And voila! Just set TNS_ADMIN to where you unzipped the files and you’re ready to go!. By default, the TNS name is “dbaccess”
C:\>set TNS_ADMIN=C:\oracle\tns\exadata_express
C:\>sqlplus mcdonac/*******@dbaccess
SQL*Plus: Release 12.1.0.2.0 Production on Wed Oct 5 12:16:07 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Last Successful login time: Wed Oct 05 2016 08:55:07 +08:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.0.3 - 64bit Production
SQL>
Simple 
And yes… it’s an Exadata !
SQL> create table t as select * from all_objects;
Table created.
SQL> set autotrace traceonly explain
SQL> select * from t;
Execution Plan
----------------------------------------------------------
Plan hash value: 1601196873
----------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
----------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 62226 | 8082K| 331 (1)| 00:00:01 |
| 1 | TABLE ACCESS STORAGE FULL| T | 62226 | 8082K| 331 (1)| 00:00:01 |
----------------------------------------------------------------------------------
Learning is not a spectator sport 
Leave a reply to OTN tour 2016 APAC | Learning is not a spectator sport Cancel reply