Different types of creating Pluggable Database manually.

Share via:

Oracle,Pluggable Different ortypes of creating Pluggable Database manually

There are multiple ways to create a pluggable database, in this article we would go through the process of creating PDB manually as in certain cases where GUI model is not feasible as

creating a PDB using DBCA needs GUI to be invoked.

“CREATE PLUGGABLE DATABASE” is the command line which will help us to create a PDB inside a CDB.

I’m taking this oppurtunity to use ASM diskgroup as the PDB file system, the same is applicable to file system with minimal changes.

1) Directlty use CREATE_FILE_DEST clause with CREATE PLUGGABLE DATABASE STATEMENT

CREATE PLUGGABLE DATABASE pdb_cfd ADMIN USER pdb_cfd_admin IDENTIFIED BY pdb_pw_cfd CREATE_FILE_DEST=’+NEW_PDB_LOC’;

2) By enabling Oracle Managed File parameter at the CDB level

ALTER SYSTEM SET db_create_file_dest = ‘+NEW_PDB_LOC’;

CREATE PLUGGABLE DATABASE pdbmanual ADMIN USER pdb_manual_admin IDENTIFIED BY pdb_pwdadmin;

3) Use FILE_NAME_CONVERT clause with CREATE PLUGGABLE DATABASE STATEMENT

CREATE PLUGGABLE DATABASE pdb_fnc ADMIN USER pdb_fnc_admin IDENTIFIED BY pdb_fnc_passw FILE_NAME_CONVERT=(‘+OLD_PDB_LOC’,’+NEW_PDB_LOC’);

4) Use PDB_FILE_NAME_CONVERT clause with CREATE PLUGGABLE DATABASE STATEMEN

ALTER SESSION SET PDB_FILE_NAME_CONVERT=’+OLD_PDB_LOC’,’+NEW_PDB_LOC”;

CREATE PLUGGABLE DATABASE pdb_sfnc ADMIN USER pdb_sfnc_admin IDENTIFIED BY passsfnc;

‘+OLD_PDB_LOC’ is ASM diskgroup location of PDB$SEED.

‘+NEW_PDB_LOC’ is ASM diskgroup location of New pdb.

Here is a sample example of above PDB manual creations

Thank you for giving your valuable time to read the above information. Please click here to subscribe for further updates

KTExperts is always active on social media platforms.

Facebook  : https://www.facebook.com/ktexperts/
LinkedIn    : https://www.linkedin.com/company/ktexperts/
Twitter       : https://twitter.com/ktexpertsadmin
YouTube   :  https://www.youtube.com/c/ktexperts
Instagram  : https://www.instagram.com/knowledgesharingplatform

 

Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)
Loading...

Add Comment