DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Renaming Instance

  1. #1
    Join Date
    May 2001
    Posts
    57
    Does any one know how to rename a database instance? I felt that it is a lot of rework. Please suggest.

  2. #2
    Join Date
    Jun 2002
    Location
    VA,USA
    Posts
    83

    Cool

    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

  3. #3
    Join Date
    Apr 2002
    Location
    Phoenix, AZ
    Posts
    175
    Dont we have to create a new password file ??
    Sridhar R Patnam

  4. #4
    Join Date
    May 2000
    Location
    Budapest
    Posts
    9
    yes.

  5. #5
    Join Date
    Feb 2002
    Posts
    267
    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

  6. #6
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Your gonna have to rebuild you controlfiles. Try reading:

    Metalink Note:15390.1

    Cheers
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

  7. #7
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    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
  •  


Click Here to Expand Forum to Full Width