-
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;
try this.
bye
saravann kumar
saravana kumar
-
Dont we have to create a new password file ??
Sridhar R Patnam
-
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|