Is it possible to change the name of an instance on Windows NT platform without dropping and re-creating the instance?
Thanks.
Printable View
Is it possible to change the name of an instance on Windows NT platform without dropping and re-creating the instance?
Thanks.
Use utility oradim.exe. It allows you to rename the instance, it also renames appropriate service(s).
ORADIM -EDIT -SID myoldsid -NEWSID mynewsid ....
in thsi case jurij do you ahve to edit the values in the registry
hi,
oradim takes care of the registry entries, u need not do anything with the registry
cheers
soren
If your Oracle version is 8.0 then,
ORADIM80 -EDIT -SID-NEWSID
If your Oracle version is 8i then
ORADIM -EDIT -SID-NEWSID
Actually the utility ORADIM(80) can be used to create, modify or to delete the instances.
If you want any help, just give,
ORADIM -help
All the best,
Yajman