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

Thread: Urgent: how to change SID name

  1. #1
    Join Date
    Nov 2000
    Posts
    164

    Urgent: how to change SID name

    Dear all,

    We have both Oracle8i and Oracle9i on the same server and with the same sid name. Up to this far, Oracle9i is up running, and only one database is allowed to run when they have the same name. Now I need to start up Oracle8i to run as well, and changing its ORACLE_SID is necessary for having both databases running at the same time. Can anyone provide detail steps of how to change SID? This is urgent, help!



    Thanks,
    Unna

  2. #2
    Join Date
    Dec 1999
    Posts
    217
    First you will need to bring the 9i instance down. Next, you need bring up the 8i instance and then issue the command
    "alter database rename global_name to ;"
    This command will change the SID name, but be sure to make the necessary changes in the initialization file after this change has been made in the database.

    -Chintz

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Jeff Hunter

  4. #4
    Join Date
    Nov 2000
    Posts
    164
    Thanks! However, the 9i is our production db and we can't afford to shutting it down now. Is there work around for the changing without shuting down the 9i db?

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by marist89
    http://download-west.oracle.com/docs...4b.htm#2061129

    See "SET DATABASE" command.
    Jeff Hunter

  6. #6
    Join Date
    Nov 2000
    Posts
    164
    Thanks Jeff, but I got very comfused on how to "Use SET DATABASE to change the name of the database"? Anyhow, I found this article from metallink on how to "change DB_NAME or ORACLE_SID",

    http://metalink.oracle.com/metalink/...T&p_id=15390.1

    or "Modifying a database to run under a new ORACLE_SID" from, http://asktom.oracle.com/pls/ask/f?p...A:318216852435



    Thanks again!

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