regaring instance

[shailendra]

The database in on NT
and I have shutdown the database before changing the instance name but it is taking the same name

[pando]

if it´s NT you have to use oradim to change instance name

[satish]

dear shailendra,
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.
regards
satish

[shailendra]

Thanks to all of you

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
Thanks

[IT_girl200]

My knowlegdeable friends ,


i have a similar problem like shailender

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

thank you
regards

[sln81]

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.