Oracle Exalytics Express is the first production release of the Oracle 12c release 2 database ( aka Oracle 12.2 ). It comes with some amazing features such as analytic views which we have alr4eady blogged and will be expanding on shortly.
As soon as your instance has been spun up you’ll want to connect SQL Developer to it, so here’s a few hints and tips to assist. Note that Exadata Express provides you with a pluggable database (PDB) so if this is your first time with a 12c database then I recommend reading up all about how container and pluggable databases work.
Firstly you’ll need to enable SQL*Net access and then click on the “Download Client Credential” in your console.
This will download a zip file to which you allocate a password and you’ll need to store that somewhere in your filesystem that SQL Developer can see it.
Now you’ll need at least version 4.1.5 of SQL Developer for this to work, so upgrade if you’re on an earlier one. I’m a keen user of the 4.2 early adopter.
Create a new connection and use the new “Cloud PDB” connector. The configuration file as the one that you downloaded when you were in the console. Press “Test” and hopefully you should see the “success” message that I have.
That should be you up and running.
.If you’re following John’s blog published on the 8th of October on Analytic Views then you may find the following useful. SQL Developer now comes with a bunch of pre-built reports that give you some great insights of the analytics and their metadata that have been created.
