pdb - ORACLEAGENT BLOG

Change PDB name with DBNEWID Utility in 19c

DBNEWID Utility:

NID utility has been introduced with Oracle 10g to change the database name and id. Without NID changing the DBNAME is only possible by recreating the control files. Changing the DBID was not possible before, as this is the database unique identifier. Giving a database a new DBNAME is common after migration of a database instance using Data Guard or duplicate where DBNAME and DB_UNIQUE_NAME differs and shall be synchronized afterwards. In some situation an ORA-01103 error occurs and changing the DBNAME to a new value may be needed.

OVERVIEW:

Verifying the pluggable database
For rename the pluggable database, We need to open the database in Restricted Mode
Set the container database name
Renaming the pluggable database
Open the pluggable database

Note : For an example , I am taking Source PDB “Mumbai” and renaming as “Noida”,

Step 1:

Verifying the available pluggable database in our local CDB

SQL> select con_id,name,open_mode from v$Pdbs;

Step 2:

Before we need to rename the pluggable database ,We should bring the PDB close and open it in “RESTRICTED MODE”

alter pluggable database mumbai close;

Step 3:

Opening the PDB in restricted mode,

alter pluggable database mumbai open restricted;

Step 4:

Set the PDB “MUMBAI”

alter session set container=mumbai;

Step 5:

Here we are renaming the pluggable database name “mumbai” as “noida”

alter pluggable database rename global_name to noida;

Step 6:

Here we can check the renamed pdb by issuing the below command

select con_id,name,open_mode from v$Pdbs;

But , the database is in restricted mode so we need to open the database,

Now the database name has been changed .

CREATE CONTAINER DATABASE USING DBCA METHOD

In Putty session while we execute ./dbca command we will get this screen.

STEP 1:

select create database option then click next button

STEP 2:

We need to supply Global database name and password

STEP 3:

click finish button to complete database creation

Once progress completed we will get below screen

STEP 5:

Now the database has been created. We can check by logging in.

Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter : https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8

CREATE CONTAINER DATABASE USING DBCA METHOD

In Putty session while we execute ./dbca command we will get this screen.

STEP 1:

select create database option then click next button

STEP 2:

We need to supply Global database name and password

STEP 3:

click finish button to complete database creation

Once progress completed we will get below screen

STEP 5:

Now the database has been created. We can check by logging in.

CREATING PLUGGABLE DATABASE (PDB) IN DBCA METHOD

In Putty session while we execute ./dbca command we will get this screen. In that screen we need to select manage Pluggable databases option to create new PDB database.

Select Create a Pluggable database option.

Click finish button to complete database creation.

Click on new Pluggable database

Enter Pluggable database name and passwords

We need to chose storage locations. click on next button

Check on the summary of inputs in Pluggable databases

Once all details confirmed click on finish button to progress on installation.

Once progress completed PDB100 plugged in.

We can check pluggable databases in putty session whether its installed properly.

Now we can see that pluggable databases installed successfully.