Amazon books

Wednesday, May 21, 2014

Create a Pluggable Database 12c - Two Steps

1-First create the directory of datafiles (if using FS of course)

mkdir -p /u01/oradata/SID

2-Now, create the database connected in CDB$ROOT

sqlplus / as sysdba


create pluggable database yourPDB admin user your_PDB_admin identified by mnager123roles = (DBA)FILE_NAME_CONVERT='/u01/app/oracle/oradata/cdb1/pdbseed','/u01/oradata/SID');


3-Check new services:


sqlplus / as sysdba
SQL> select name, con_id from v$active_services; 



Simple like that.
Best Regards,







Paulo Portugal



No comments:

Post a Comment