Database Reference
In-Depth Information
Rename pluggable DB:
$ sqlplus sys/foo@invpdb as sysdba
SQL> shutdown immediate;
SQL> startup restrict;
SQL> alter pluggable database mypdb rename global_name to myoldpdb;
cdb_pdb_history
view contains the previous incarnations as well as their creation date.
To drop a PDB:
$ sqlplus / as sysdba
SQL> alter pluggable database mypdb close immediate;
SQL> drop pluggable database mypdb including datafiles;
Pluggable database dropped.
To aid in your 12c administration,
CDA_*
views have been added onto the previously existing
USER_* ALL_*
and
DBA_*
views (as well as
gv$*
views for RAC).
Upgrading to 12c Multi-tenancy
First of all, it is important to know that we cannot convert a current 11g database into a 12c CDB. We must create the
12c CDB from scratch. Then we can upgrade 11g databases to 12c and then plug them into the new CDB.
These versions of Oracle can be upgraded to 12c pluggable databases:
10.*.*.5
11.1.0.7
11.2.0.2
They can be upgraded in parallel mode with
catctl.pl
, which will save significant time. RAC upgrades
encourage automated downloads from MOS. This is not recommended in case of intermittent connection and
because direct firewall egress should be banned for security reasons.
Remember that you can't go back from the upgrade. You would need to do a full transportable tablespace
movement or export/import with data pump. There is no easy “reconvert” option.
On the positive side, during creation of a CDB you don't have to prefix common users with c##, so
Oracle-supplied common users or user-supplied common users can be created then.
Alternatively, you can use this method to create common users without the need for the c## prefix as follows:
C:\Windows\System32>sqlplus sys/o@192.168.1.3/orcl as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Wed Mar 12 17:21:14 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.0.2 - 64bit Beta
With the Partitioning, OLAP, Data Mining and Real Application Testing options
