Multiple Listeners on the same server
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Multiple Listeners on the same server

Hybrid View

  1. #1
    Join Date
    May 2002
    Posts
    36

    Multiple Listeners on the same server

    Hi
    We have a sun solaris server with 2 instances of Oracle 8.0.5 installed.One Oracle 8 listner is running for both the instances.
    Now we have installed Oracle 9i on the same server.we have configured the listener for oracle8 (old one) to listen to the 9i database also.
    What i am interested is is there a way to run both the Oracle 8 and Oracle 9i listeners together on the same machine?

    Thanks
    Sam

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: Multiple Listeners on the same server

    Originally posted by samx18
    Hi
    We have a sun solaris server with 2 instances of Oracle 8.0.5 installed.One Oracle 8 listner is running for both the instances.
    Now we have installed Oracle 9i on the same server.we have configured the listener for oracle8 (old one) to listen to the 9i database also.
    What i am interested is is there a way to run both the Oracle 8 and Oracle 9i listeners together on the same machine?

    Thanks
    Sam
    Yes, you can. Is it the same OS user who owns the 8 and 9i binaries? Remember to satrt the listener under the 8 binaries!
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  3. #3
    Join Date
    May 2002
    Posts
    36
    The Oracle OS users are different for Oracle 8 and Oracle 9i
    When we try to start the Oracle 9i listner it gives a message of address already in use.

    Sam

  4. #4
    Use another port for your 9i listener.
    www.cnoug.org

  5. #5
    Join Date
    May 2002
    Posts
    36
    Have already tried changing the port numbers but it dosent seem to work.
    Sam

  6. #6
    Look at my sample:

    [oracle@ish2 oracle]$ lsnrctl start

    LSNRCTL for Linux: Version 8.1.7.0.0 - Production on 22-FEB-2003 19:51:10

    (c) Copyright 1998 Oracle Corporation. All rights reserved.

    Starting /home/oracle/product/8.1.7/bin/tnslsnr: please wait...

    TNSLSNR for Linux: Version 8.1.7.0.0 - Production
    System parameter file is /home/oracle/product/8.1.7/network/admin/listener.ora
    Log messages written to /home/oracle/product/8.1.7/network/log/listener.log
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ish2.eachnet.com)(PORT=1521)))

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ish2)(PORT=1521)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for Linux: Version 8.1.7.0.0 - Production
    Start Date 22-FEB-2003 19:51:10
    Uptime 0 days 0 hr. 0 min. 0 sec
    Trace Level off
    Security OFF
    SNMP ON
    Listener Parameter File /home/oracle/product/8.1.7/network/admin/listener.ora
    Listener Log File /home/oracle/product/8.1.7/network/log/listener.log
    Services Summary...
    archdb has 1 service handler(s)
    catalog has 1 service handler(s)
    ora9 has 1 service handler(s)
    The command completed successfully


    [oracle@ish2 oracle]$ . ora9.env
    [oracle@ish2 oracle]$ lsnrctl start ora9standby

    LSNRCTL for Linux: Version 9.2.0.1.0 - Production on 22-FEB-2003 19:51:49

    Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

    Starting /oradata/9.2.0/bin/tnslsnr: please wait...

    TNSLSNR for Linux: Version 9.2.0.1.0 - Production
    System parameter file is /oradata/9.2.0/network/admin/listener.ora
    Log messages written to /oradata/9.2.0/network/log/ora9standby.log
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ish2.eachnet.com)(PORT=1522)))

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ish2)(PORT=1522)))
    STATUS of the LISTENER
    ------------------------
    Alias ora9standby
    Version TNSLSNR for Linux: Version 9.2.0.1.0 - Production
    Start Date 22-FEB-2003 19:51:49
    Uptime 0 days 0 hr. 0 min. 0 sec
    Trace Level off
    Security OFF
    SNMP OFF
    Listener Parameter File /oradata/9.2.0/network/admin/listener.ora
    Listener Log File /oradata/9.2.0/network/log/ora9standby.log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ish2.eachnet.com)(PORT=1522)))
    Services Summary...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Service "ora9" has 1 instance(s).
    Instance "ora9", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully

    my ora9 listener.ora file:

    SID_LIST_ora9standby =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = /oradata/9.2.0)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = ora9)
    (ORACLE_HOME = /oradata/9.2.0)
    (SID_NAME = ora9)
    )
    )
    ora9standby =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ish2)(PORT = 1522))
    )
    )
    )

    my ora8 listener.ora:
    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ish2)(PORT = 1521))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = ora9)
    (ORACLE_HOME = /oradata/9.2.0)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = catalog.eachnet.com)
    (ORACLE_HOME = /home/oracle/product/8.1.7)
    (SID_NAME = catalog)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = archdb.eachnet.com)
    (ORACLE_HOME = /home/oracle/product/8.1.7)
    (SID_NAME = archdb)
    )
    )
    www.cnoug.org

  7. #7
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by chao_ping
    Use another port for your 9i listener.
    and also change the listener name....
    the way chao_ping has shown above.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

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