ORACLE_SID unix help(ASAP)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: ORACLE_SID unix help(ASAP)

  1. #1
    Join Date
    Nov 2000
    Posts
    62
    the Unix box have a 8.1.5 oracle server, and I just installed oracle 8.1.6 in the same machine using a different ORACLE_HOME directory.
    I put different oracle_home directories according to the SID_NAME in the oratab file.

    For example
    HOST:/export/oracle/app/product/8.1.5:N
    CODE:/export/oracle/app/product/8.1.6:N

    If I ran profile file whenever I change the ORACLE_SID, Oracle read a right ORACLE_HOME directory, but if I change ORACLE_SID in the shell prompt.

    export ORACLE_SID=HOST
    echo $ORACLE_SID
    >HOST
    echo $ORACLE_HOME
    >/export/oracle/app/product/8.1.6
    then shows me a wrong ORACLE_HOME path.

    What do I need to put to the profile file for the user oracle to manage both ORACLE_SID and ORACLE_HOME separately?
    Thanks.

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    I think you have to edit the profile (add an entry) in order for it to reflect the new db created with 8.1.6

  3. #3
    Join Date
    Nov 2000
    Posts
    62

    Two Server in the same Unix box. Ungent

    I think that oracle pick up ORALCE_HOME path from oratab.
    and I already put the following in the profile file.

    ORACLE_SID=HOST; export
    . /usr/local/bin/oraenv
    TNS_ADMIN=$ORACLE_HOME/network/admin; export ORACLE_HOME
    LD_LIBRARY_PATH=$ORACLE_HOME/lib; export LD_LIBRARY_PATH

    Now, I can not connect to the existing database.
    It says that
    ld.so.1: oracleHOST: fatal: relocation error: file /export/oracle/app/product/8.1.6/lib/libjox8.so: symbol joxsgal_: referenced symbol not found
    ERROR:
    ORA-12547: TNS:lost contact

    So I issued lsnrctl> status
    then
    ld.so.1: lsnrctl: fatal: relocation error: file lsnrctl: symbol naemd5s: referenced symbol not found
    Killed.

    Is there anybody who is familiar with this issue?

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    Changing your environment after you login is a real pain.

    We try to source the oraenv script every time we change the ORACLE_SID. In a previous company, we had scripts for each instance that we would source. Those scripts would re-source .profile and then tack on the apropriate environment variables.

    With using oraenv, I find it easier to logout and log back in...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    I would change
    LD_LIBRARY_PATH=$ORACLE_HOME/lib; export LD_LIBRARY_PATH
    to
    LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH; export LD_LIBRARY_PATH
    Hope it helps
    Ramon Caballero, DBA, rcaballe@yahoo.com

  6. #6
    Join Date
    Nov 2000
    Posts
    62
    So far it seems that the only wat to change ORACLE_HOME path dynamically is to run profile file.

    Thanks.

  7. #7
    Join Date
    Nov 2000
    Posts
    62
    At this point , I am using 8.1.5's listener and I put each SID's Home directory like the following
    BEFORE:
    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = CODE)
    )
    (SID_DESC =
    (SID_NAME = HOST)
    )
    )
    AFTER:
    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (ORACLE_HOME=/export/oracle/app/product/8.1.6)
    (SID_NAME = CODE)
    )
    (SID_DESC =
    (ORACLE_HOME=/export/oracle/app/product/8.1.5)
    (SID_NAME = HOST)
    )
    )
    Then I reloaded Lstener

    LSNRCTL> reload

    Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=XXXXX)(PORT=XXXX))
    TNS-01201: Listener cannot find executable /epxort/oracle/app/product/8.1.6/bin/oracle for SID CODE

    If I remove all the directory I entered and then It work
    LSNRCTL> status
    Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=XXXXX)(PORT=XXXX))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for Solaris: Version 8.1.5.0.0 - Production
    Start Date 22-MAY-00 11:13:55
    Uptime 184 days 4 hr. 10 min. 0 sec
    Trace Level off
    Security OFF
    SNMP OFF
    Listener Parameter File /export/oracle/app/product/8.1.5/network/admin/listener.ora
    Listener Log File /export/oracle/app/product/8.1.5/network/log/listener.log
    Services Summary...
    CODE has 1 service handler(s)
    The command completed successfully

    Please help me ~

  8. #8
    Join Date
    Jul 2000
    Posts
    50
    1. You can have one value for each variable in your profile file.e.g.
    If you have the following parameters in your profile file:

    ORACLE_HOME=/export/oracle/app/product/8.1.5

    ORACLE_SID=HOST

    And, you want to start CODE database, you need to change the ORACLE_HOME and ORACLE_SID at $prompt.

    2. oratab file parameters:

    HOST:/export/oracle/app/product/8.1.5:N
    CODE:/export/oracle/app/product/8.1.6:N

    This is for starting the database at system bootup.

    3. For listener.ora: I guess you need to add one more ADDRESS for the new software i.e. oracle 8.1.6.0 with change SID_LIST_LISTENER that you did already.

    Regards,

    abhijit


  9. #9
    Join Date
    Nov 2000
    Posts
    62
    Thank you for the all the help.
    LISTENER PROBLEM is related to prot setting.
    Since two listerner are running in different version, I needed two ports and different listener name.

    SID problem:
    whatever I do I could not change ORACLE_HOME path accoding to ORACLE_SID change.
    temporary, I will change PATH in shell prompt explicitly.
    I need to think about this more.

    Again thanks.

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