Does any one know how to rename a database instance? I felt that it is a lot of rework. Please suggest.
Printable View
Does any one know how to rename a database instance? I felt that it is a lot of rework. Please suggest.
steps to rename ur instance
# shutdown your instance
#delete your current service using "oradim -delete -sidin OS level
#create a new service using
oradim -new -sid-intpwd -startmode -pfile
#rename your pfile to new sid as "init.ora"
#start your new instance
#select instance_name from v$instance;
try this.
bye
saravann kumar
Dont we have to create a new password file ??
yes.
on unix
$ ORACLE_SID=newname;export ORACLE_SID
to make it permanent edit .profile
on NT
C:/>set ORACLE_SID=newname;
to make it permanent set environment variable
Your gonna have to rebuild you controlfiles. Try reading:
Metalink Note:15390.1
Cheers
Yes,
It is easy but...
We have to recreate the controlfiles....for the newinstance.
Thanks.
Thanigaivasan.