Renaming Instance

[dba_akram]

Does any one know how to rename a database instance? I felt that it is a lot of rework. Please suggest.

[ksarav]

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;

try this.

bye
saravann kumar

[patnams]

Dont we have to create a new password file ??

[ZOTY]

yes.

[Sonia]

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

[TimHall]

Your gonna have to rebuild you controlfiles. Try reading:

Metalink Note:15390.1

Cheers

[thanigai]

Yes,
It is easy but...
We have to recreate the controlfiles....for the newinstance.
Thanks.
Thanigaivasan.