Patch 17552800: DATABASE PATCH SET UPDATE 12.1.0.1.2

Applying this patch to a single instance multitenant database. As with almost every patch download latest Opatch and unzip into Oracle Home.

Unzip the patch file and run the prereq checks

Shutdown all instances and listeners associated with this instance.

Now lets run opatch.

All looks good. Time to start up…

PDB Close Database Bug

Just going through some HA testing on our multitenant RAC Database and we hit the error below when trying to close the pdb on the second node while being logged into the first node.

Looking at the alert log on the second node we see.

On Metalink we see this is a known…

CDB$VIEW

You may be familiar with the data dictionary views USER_, ALL_ and DBA_. Oracle 12C introduces the CDB_ views to cater for multitency. Looking a little deeper these CDB_ views are generated from a function called CDB$VIEW. Lets use CDB_USERS as an example.

We can see from the above CDB$VIEW(“SYS”.”DBA_USERS”). This looks like some…

CDB_DATA_FILES Not Showing All Files

Something strange I’ve just come across when trying to see my database files after migrating a non cdb into a pdb. Lets look at what is going on. Connect to the container database and check the database files.

Now connect to the pdb and show total files:

Metalink has a note about something…