Monday , May 20 2024

How To Change Database Name In Oracle

In this topic we will see how can we change our database name using Oracle NID tool.

Use the syntax bellow to change the Dtabase Name.

Make sure you shutdown and start up in mount mode your oracle database before.

2. Recreate the new password file.

3. Make sure that you drop any password files before or you will get some errors. Rename the init.ora file.

4. Edit the initDB.ora parameters file.

5. Now start the database in nomount mode and alter the db_name parameter in the control file.

6. Shutdown the database and start it backup.

7. Check the status and name of you database.


About Buğra PARLAYAN

Burgra Parlayan is an experienced Database and Weblogic Administrator. After completing his technical / relevant training he has got involved with a serious amount of projects. He successfully managed database upgrade, database migration, database performance tuning projects for various public institutions.Currently he has been employed by one of the leading financial institutions called Turkiye Hayat & Emeklilik as responsible administrator for Oracle Database and Oracle Middleware. He has been sharing his experience and knowledge by face to face training, personal blog and various social networking accounts to support the Oracle ecosystem continuously since 2010.

Leave a Reply

Your email address will not be published. Required fields are marked *