Results 1 to 4 of 4

Thread: rename the SID

  1. #1
    Join Date
    Jul 2003
    Posts
    4

    Unhappy Unanswered: rename the SID

    I want to change the SID name.
    I installed oracle 920 for Linux, and the SID name is not a proper one, I have to move it to a better one.
    How can i do it without reinstalling Oracle?, can I?, I mean, is that possible?.

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    1) Shutdown the database.
    2) Change the ORACLE_SID environment variable in the .profile (or wherever it's set)
    3) Make sure TNSNAME.ora has the new SID name.
    4) Logoff/Login to Unix.
    5) startup Oracle.
    6) Stop/Start the listener.

  3. #3
    Join Date
    Jul 2003
    Location
    US
    Posts
    314

    Arrow oracle_SID

    Hi
    It might sound very basic, but I would like to know what the ORACLE_SID means, and what it means to have a better environment variable.
    Thanx and Regards
    Aruneesh

  4. #4
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    The oracle SID is the NAME given to the execution instance, this differs from the database name which is the name by which the database was created.

    This SID name is set by the environment variable ORACLE_SID. For example in Unix you would set the environment variables something like:

    #!/bin/ksh
    ORACLE_BASE=/opt/oracle
    ORACLE_HOME=/opt/oracle/product/8.1.7
    ORAENV_ASK=NO
    PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH
    LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/dt/lib:/usr/lib
    SHLIB_PATH=$ORACLE_HOME/lib:/usr/lib
    NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
    ORACLE_SID=GIPSYS
    export ORACLE_SID ORACLE_BASE ORACLE_HOME ORAENV_ASK PATH
    export LD_LIBRARY_PATH SHLIB_PATH NLS_LANG

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •