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

Thread: listerner config

  1. #1
    Join Date
    Jan 2001
    Posts
    230

    Question

    Hi:

    I am having a problem with configuring listerner.
    I have three database instance on same machine.
    Two of the instance uses 8.1.5 oracle and one uses 8.0.5 oracle.

    Please let me know how can I configure listerner with two different version of oracle.

    Thanks.

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    see the listener on my unix box which has 2 versions.
    <font face=courier>
    LISTENER =
    ---(ADDRESS_LIST =
    --------(ADDRESS =
    ----------(COMMUNITY = tcpcom.world)
    ----------(PROTOCOL = TCP)
    ----------(Host = apps)
    ----------(Port = 1521)
    --------)
    ---)
    SID_LIST_LISTENER =
    --(SID_LIST =
    ----(SID_DESC =
    ------(GLOBAL_DBNAME = iiip.world)
    ------(SID_NAME = iiip)
    ------(ORACLE_HOME = /u01/oracle/product/734)
    ----)
    ----(SID_DESC =
    ------(GLOBAL_DBNAME = caae.world)
    ------(SID_NAME = caae)
    ------(ORACLE_HOME = /u01/oracle/product/815)
    ----)
    --)
    </font>

    [Edited by sreddy on 01-31-2001 at 04:16 PM]

  3. #3
    Join Date
    Jan 2001
    Posts
    230
    Reddy:

    Since I have two oracle_home, one for oracle 8.0.5 and one for 8.1.5
    so which one should I use? I think due to upward compability, I should use 8.1.5/network/admin
    directory.

    Thanks,
    -Nitesh

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    YOu have to use most latest version of Networking. If its 815 use 815 networking. If you have 817 binaries also sitting on it, use 817 networking.

    Your $TNS_ADMIN should always point to latest version of Networking for better results.

    Whichever version you want to use to go that O_H/network/admin and modify listener.ora and tnsnames.ora as per your requirement.

    Make sure, you don't invoke older versions of executables by renaming 'em after you setup for latest version of Networking.

    In logical sence, all(8x) use Net8. But, we do this way in our shop, by allowing 734 instances also to use Net8 rather SQL*Net.

    [Edited by sreddy on 01-31-2001 at 06:10 PM]

  5. #5
    Join Date
    May 2000
    Posts
    50
    Hmm....This definitely put me in thinking mode. I was always under the impression that the new and latest products have the backward compatibility as against the previous products having upward compatibility. And hence, I have all the different versions of instances looking at the oldest version of the listener and tnsnames files instead of the other way around as said by sreddy. May be I need to try this.

  6. #6
    Join Date
    Feb 2001
    Posts
    1

    Multiple Listeners Config

    Use these 2 files as you different version of Oracle running 2 different listeners.
    execute this command after changing the $ORACLE_HOME and $ORACLE_SID

    lsnrctl start LISTENER

    FILE 1:
    ________________________________________________________

    LISTENER =
    (ADDRESS_LIST =
    (ADDRESS =
    (COMMUNITY = tcpcom.world)
    (PROTOCOL = TCP)
    (Host = apps)
    (Port = 1521)
    )
    )
    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = iiq.world)
    (SID_NAME = iiq)
    (ORACLE_HOME = /u01/oracle/product/734)
    )
    )
    --------------------------------------------------------------------------

    lsnrctl start LSNR

    FILE 2:
    ------------------------------------------------------------------------

    LSNR =
    (ADDRESS_LIST =
    (ADDRESS =
    (COMMUNITY = tcpcom.world)
    (PROTOCOL = TCP)
    (Host = apps)
    (Port = 1526)
    )
    )
    SID_LIST_LSNR =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = iiip.world)
    (SID_NAME = iiip)
    (ORACLE_HOME = /u01/oracle/product/815)
    )
    )

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