In this article we will learn how to rename a oracle instance.

Step 1 :

Check instance information

My instance name is primary.

No i want to convert Primary to PROD.

Step 2 :

Shutdown the database

Step 3 :

Change Instance Name in bash_profile :

Step 4 :

Run the bash_profile

Step 5 :

Go to dbs location and rename the pfile from initprimary.ora to initprod.ora

Step 6 :

Connect to sqlplus and startup the database .

Step 7:

Check the instance name

I hope above steps will be useful for renaming the Oracle Instance .

Thank you ……….


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

Add Comment