Upgrade with no effort

We all know what upgrades mean.  Installation…Configuration…Patching…Testing…Deployment…Change approvals…Meetings…Long hours…Perhaps pulling an “overnighter” but hopefully never having to enact the dreaded “Backout Plan”.

Or…. that stuff can “just happen” without you worrying about it at all! 

I logged on to my Exadata Cloud Express database on the weekend, and lo and behold, it is not Oracle Database 12c anymore.  It is 12c Release 2 !

A look back through my email Inbox, and I saw that I had indeed been notified of the upcoming upgrade some time ago, but I was too lazy to pay attention to it Smile


Now that’s the kind of upgrade I like !

Exadata Express – I’m in !

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 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 - 64bit Production


Simple Smile 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 |