Change database instance name

Welcome to the Oracle community forum and interact with 2 million technical staff to change the database instance name env: Windows + oracle8i ---------------------------------- 1. besuredatabaseclosed. ifnot, pleaseshudownfirst.2. use oradim to create a service, ORADIM-NEW-SIDnew

Welcome to the Oracle community forum and interact with 2 million technical staff> go to change database instance name env: Windows + oracle8i ------------------------------------ 1.Be sure database closed. if not, please shutdown first. 2. oradim can be used to create a service, ORADIM-NEW-SID new

Welcome to the Oracle community forum and interact with 2 million technical staff> enter

Change database instance name

Env: Windows + oracle8i
----------------------------------

1. Be sure database closed. if not, please shutdown first.

2. You can use oradim to create a service,
> ORADIM-NEW-SID newname-INTPWD pwdnewname. pwd-startmode auto-PFILE yourpfile, then you can see the new servcie.

3. Be sure the ORACLE_SID is set in the registry correctly. Goto
Start button --> RUN --> type regedt32 -->
Goto the following directory tree within the registry-
HKEY_LOCAL_MACHINE-> SOFTWARE-> ORACLE-
Highlight ORACLE-look on the left side look for ORACLE_SID =
To change you can highlight ORACLE_SID-right click on your mouse and
Select modify.
Enter the SID.
The above is only valid when using DEFAULT_HOME, when you have another
Home then you need to highlight that HOME under ORACLE key
Usually HOME1-HOMEx. No spaces can be entered after the = when setting ORACLE_SID
At the DOS Prompt, set oracle_sid = xyz shocould be used and not
Set oracle_sid = xyz

4. Be sure the new instance is started Goto
Start --> Settings --> Control Panel --> Services
And check if the database service is started.

5 .. in Command line prompt, SET ORACLE_SID = NEWNAME

6. Startup the database, then you can view v $ instance, you will see your new instance name here.