Is it possible to change the name of an instance on Windows NT platform without dropping and re-creating the instance?
Use utility oradim.exe. It allows you to rename the instance, it also renames appropriate service(s).
ORADIM -EDIT -SID myoldsid -NEWSID mynewsid ....
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
in thsi case jurij do you ahve to edit the values in the registry
oradim takes care of the registry entries, u need not do anything with the registry
If your Oracle version is 8.0 then,
ORADIM80 -EDIT -SID <oldsidname> -NEWSID <newsidname>
If your Oracle version is 8i then
ORADIM -EDIT -SID <oldsidname> -NEWSID <newsidname>
Actually the utility ORADIM(80) can be used to create, modify or to delete the instances.
If you want any help, just give,
All the best,
Click Here to Expand Forum to Full Width