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
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