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 -sid in 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;
Dont we have to create a new password file ??
Sridhar R Patnam
$ ORACLE_SID=newname;export ORACLE_SID
to make it permanent edit .profile
to make it permanent set environment variable
Your gonna have to rebuild you controlfiles. Try reading:
It is easy but...
We have to recreate the controlfiles....for the newinstance.
Click Here to Expand Forum to Full Width