Compatiblity Quirks of PDB with CDB of pluggable database feature of Oracle 12c

I was playing with converting an existing Oracle database to pluggable database and to plug it in the container database. Earlier I had created that non-CDB or in other words the good old database in 12c without any options like APEX etc.

Before plugging this non-CDB database into the CDB, I checked the compatibility and it said 'No'.

To Check if database is Container Database in Oracle 12c

 [oracle@sourcetest ~]$ sqlplus '/ as sysdba'  
 SQL*Plus: Release 12.1.0.1.0 Production on Thu Jul 25 19:57:38 2013  
 Copyright (c) 1982, 2013, Oracle. All rights reserved.  
 Connected to:  
 Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production  
 With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options  
 SQL> select name,dbid,con_dbid,cdb,con_id from v$database;  
 NAME    DBID  CON_DBID CDB  CON_ID  
 --------- ---------- ---------- --- ----------  
 MYCDB   2166941381 2166941381 YES     0  
 The value of CDB yes tells us that its a container database, and its container ID is 0.   

Install Goldengate on Oracle 12c Exercise

Though still Oracle Golden Gate for 12c version of database hasn't been released, nonetheless I tried playing with it and surprisingly went quite far, though at the end it failed with some OCI errors and after a while the status of extract process became abended.

The interesting thing is that if you create soft link of 12c file libnnz12.so to be used as libnnz11.so with 11g compatible Goldengate software it works without any complain.

Also the Managers at both source and destinations kept running and so is REPLICAT process.

In this exercise, I used OEL 6.4 64-bit with Oracle database 12c R1, and was done on two VM of Virtualbox.

Silent Install Oracle 12c software and database Console mode

Following are the steps to install Oracle database 12c in Oracle Linux 6.4.

It assumes that OS has been installed, Oracle 12c software has been downloaded, per-requistes have been configured (best way is to use Oracle pre-install rpm).

Step 1:

Create /etc/oraInst.loc file and make following entries in it by root user:

inventory_loc=/u01/app/oraInventory
inst_group=oinstall

chown oracle:oinstall oraInst.loc
chmod 664 oraInst.loc

Oracle 12c Pre-install Installation

Oracle pre-install rpm is used to automate the setting and checking of per-requistes at the OS for the installation of Oracle RDBMS. All you have to is to install it and after that you can go ahead and install Oracle 12c. pre-install rpm can be downloaded from the YUM among some other sources:

Step 1: Configure YUM (For Oracle Linux 6)

 With root user:

cd /etc/yum.repos.d
wget http://public-yum.oracle.com/public-yum-ol6.repo

Optionally you can check for latest yum updates:

yum update

Step 2: Install the pre-install rpm from YUM

yum install oracle-rdbms-server-12cR1-preinstall

That's about it. This pre-install will check for all the dependent rpms, will create Oracle user with proper privileges and security settings.

YUM is yummy for sure, just like an Aussie bbq.