Changing the name of an Instance
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Changing the name of an Instance

  1. #1
    Join Date
    Mar 2001
    Posts
    11

    Question

    Is it possible to change the name of an instance on Windows NT platform without dropping and re-creating the instance?

    Thanks.

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Use utility oradim.exe. It allows you to rename the instance, it also renames appropriate service(s).

    ORADIM -EDIT -SID myoldsid -NEWSID mynewsid ....
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828
    in thsi case jurij do you ahve to edit the values in the registry

  4. #4
    Join Date
    Nov 2000
    Posts
    26

    Cool

    hi,
    oradim takes care of the registry entries, u need not do anything with the registry
    cheers
    soren

  5. #5
    Join Date
    Feb 2001
    Posts
    15
    If your Oracle version is 8.0 then,

    ORADIM80 -EDIT -SID <oldsidname> -NEWSID <newsidname>

    If your Oracle version is 8i then
    ORADIM -EDIT -SID <oldsidname> -NEWSID <newsidname>

    Actually the utility ORADIM(80) can be used to create, modify or to delete the instances.
    If you want any help, just give,
    ORADIM -help

    All the best,
    Yajman

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