Wednesday, September 27, 2017

How to use the dbms_explan.display_cursor function to find the execution plan of a query in the Cursor Cache

›
set linesize 200 set pagesize 0 select * from table (dbms_xplan.display_cursor( '0syc4upspr638',3,'TYPICAL')); exit Where ...
Wednesday, September 20, 2017

How to migrate a non-CDB database to a PDB on the same host

›
There are many ways to migrate your non-cdb Oracle databases to the new Multitenant Architecture. Here I will show you how to clone a non-c...
Wednesday, September 13, 2017

Oracle Multitentant licensing

›
For Oracle 12c, you don't need to purchase an additional license when running a Multitenant database shop with only 1 - one - PDB. This ...

A workaround for ORA-06553: PLS-213: package STANDARD not accessible when using datapatch in a CDB

›
Short background: I was having trouble applying "patch 26550023 - COMBO of OJVM Component 12.1.0.2.170718 DB PSU + DB PSU 12.1.0.2.17...
Tuesday, September 12, 2017

How to attach an ORACLE_HOME to an existing inventory

›
I wanted to check the patchlevel in one of my Oracle installations, and the following errow was returned: oracle@tsl0map-dbteam-sandbox-db0...
1 comment:

How to create a container database in Oracle 12c

›
Create an initialization file in your $ORACLE_HOME/dbs folder: enable_pluggable_database=true processes=300 control_files="/u02/ora...
Monday, September 11, 2017

Why is my PDB seemingly stuck in RESTRICTED mode?

›
Check out the view pdb_plug_in_violations - it will point you in the right direction. In my case, I had created a pluggable database som...