pl follow following steps to change instance name:-
eg- suppose u want to change from orcl to ora
- pl go to command prompt
-type 'oradim -delete -sid orcl
-type 'set Oracle_SID=ora
-type 'oradim -new -sid ora -intpwd oracle -startmode auto -pfile pathOfInit.ora
there after u come out of cmd prompt
go to setting>control panel>services and see that the service oracleoracleora has started.
if u have put instance name in init.ora file then change there also and bounce the database. u will have to keep the database shut for the above procedure.
Satish I have tried what you have told
The instance name is changed but when I run the svrmgrl utiliy to open the database
it is giving error TNS Protocol Adapter Error
can you pls. tell me how to solve this problem
i have tried shutting down the database and then from the command prompt i SET ORACLE_SID = TEST...
I DON'T SEE THE EFFECT ..
this does not even bring the change in the registry .
also pls can you tell me if i make the change manually in the registry the oracle_sid value then will it work
Two things here.
>On NT when you are setting oracle_sid, don't give any spaces before and after '=' sign e.g oracle_sid=orcl is correct, not oracle_sid = orcl.
>when you are invoking svrmgr and you get that error, check whether NT service for that sid is started or not.