Change Oracle 10g DB name in Linux

1. First of all backup the database.
2. Then login as SYSDBA to check out the DB ID and DB Name by using the following statement, using SQLPLUS or your favourite SQL Client.

select dbid, name from v$database

3. Shutdown the database and startup it in mount state (SQLPLUS).

shutdown immediate
startup mount

4. Use the DBNEWID command to change the DB ID, you need to login as user with privilege SYSDBA (Terminal).

nid target=username/password@servicename dbname=newdbname

5. Shutdown database again (SQLPLUS).

shutdown immediate

6. Change db_name initialization parameter in the initialization file, normally inside database folder/admin/pfile (Terminal).
7. Create a new password file using ORAPWD utility, the file usually in Oracle folder/dbs (Terminal).

orapwd file=orapwSID password=password entries=

8. Start database in mount state (SQLPLUS).

startup mount

9. Open database with RESETLOGS option (SQLPLUS).

alter database open resetlogs

10. Verify the database id and name using following statement (SQLPLUS).

select dbid, name from v$database

11. Don’t forget to change ORACLE_SID parameter in .bash_profile and database name in /etc/oratab
(Terminal).

Advertisement