Oracle renaming databases

This is going to be a couple of steps.

take oracle10g as an example to illustrate the process of changing the SID name. If the database SID is called TestDB, now change to ORCL, there are the following 6 steps:

1. Stop All Oracle Services

1.1, Oracle's related services are prefixed with Oracle, there are several:

2, modify the initialization file, set the instance_name parameter value to the new SID name;

2.1. If you do not have an editable PFILE file, you can use the Create PFILE from SPFile command. Initializes the file parameters of the

the following content:

db_name= "TestDB"

INSTANCE_NAME=TESTDB1

Service_names=testdb

modified to:

db_name= "TestDB"

instance_name=oral

service_names=oral (note db_name do not modify, the database is also called TestDB, but its service is SID changed to ORCL.)

3, modify the Oracle_sid value of the registry;

3.1, in the registry hkey_local_machine/software/oracle/key_oradb10g_home1 the Oracle_sid key value is oral, note, the other do not change.

4, modify the Listener.ora in the Sid_name;

under directory%oracle_home%\network\admin find Listener.ora, put this file after an item of

sid_name=oral

5. Delete the original SID service with Oradim and add the service of the new Sid;

Oradim-delete-sid TestDB

Oradim-new-sid ORCL

6. Use ORAPWD to generate a new SID password. 

Create a new password file with the tool orapwd. Save the file to the%oracle_home%\database directory,

orapwd file=%oracle_home%\database\pwdoral.ora Password =admin

password is set to the SYS user's password.