Database Software

Hi,

I'm simply doing OBE labs on a VM for now, until I get new hardware which will run 12.1.0.2 database. The issue I am having with an OBE lab which demonstrates unplugging and plugging in PDB's from one container to another has me confused. The lab states the following set up:

Prerequisites

Before starting this tutorial, you should:

• Install Oracle Database 12c.
• Create two CDBs with two PDBs in the first CDB.

1. The environment used in the development of this tutorial is as follows:
   • ORACLE_HOME: /u01/app/oracle/product/12.1.0
   • TNS Listener port: 1521
   • Container databases:
     • SID: cdb1
     • SID: cdb2
   • Pluggable databases (in cdb1):
     • pdb1
     • pdb2

The problem I am having is when I use DBCA or scripts to create CDB2, it doesn't create a new container database. I get an instance and a database called CDB2, however it's not a CDB. I get ORA-65090: operation only allowed in a container database.

In the DBCA, I make sure 'install pluggable database' is checked, and in the SPFILE I have ENABLE_PLUGGABLE_DATABASE=TRUE..... The new instance has the name I gave it, with no pluggable database installed, and for CDB2:

SQL> select name from v$database;

NAME

---------

CDB2

SQL> show con_id

CON_ID

------------------------------

0                                     (expected to see a 1)

SQL> show con_name

CON_NAME

------------------------------

cdb2                               (expected to see CDB$ROOT)

The link to the lab can be found here:

Plugging an Unplugged Pluggable Database

Is it possible to have two container databases in the same ORACLE_HOME? What am I missing to install a second container database?