Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2006

    Unanswered: Listener Configuration


    We would like to figure out the cause of truncated archived log files that are being shipped from one of our primary database to the standby server. Our assumption that the SQL Net inspection (former fixup) feature of the firewall is causing this problem. We would like to reconfigure the port for one of our standbys. The problem is that on the standby server we have 2 standbys which are being listened on the default 1521 port. Is it possible to have one listener that will use one port (1521) for one standby and another port (for example, 1522) for the other db?

    Any help will be greatly appreciated!


  2. #2
    Join Date
    Jul 2003
    you can listen on any port you want.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Nov 2006
    hmmm... I understand that I can choose whatever port for a database. However, my question was the following: if i have only one listener (for now) which is listening for 2 databases on the server. Can I have different ports for these databases or not? So, listener1 will listen for database1 on port 1521 and the same listener1 will listen for database2 on port 1522?

  4. #4
    Join Date
    Jun 2003
    West Palm Beach, FL

    Thumbs down No way.

    No, listener1 will listen for database1 on port 1521 and listener2 will listen for database2 on port 1522.

    You need to configure two listeners.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  5. #5
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    oracle@bcm-laptop:/u01/app/oracle/network/admin$ lsnrctl start
    LSNRCTL for Linux: Version - Production on 11-SEP-2009 19:09:43
    Copyright (c) 1991, 2007, Oracle.  All rights reserved.
    Starting /u01/app/oracle/bin/tnslsnr: please wait...
    TNSLSNR for Linux: Version - Production
    System parameter file is /u01/app/oracle/network/admin/listener.ora
    Log messages written to /u01/app/oracle/network/log/listener.log
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bcm-laptop)(PORT=1521)))
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bcm-laptop)(PORT=1522)))
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bcm-laptop)(PORT=1521)))
    Alias                     LISTENER
    Version                   TNSLSNR for Linux: Version - Production
    Start Date                11-SEP-2009 19:09:44
    Uptime                    0 days 0 hr. 0 min. 0 sec
    Trace Level               off
    Security                  ON: Local OS Authentication
    SNMP                      OFF
    Listener Parameter File   /u01/app/oracle/network/admin/listener.ora
    Listener Log File         /u01/app/oracle/network/log/listener.log
    Listening Endpoints Summary...
    Services Summary...
    Service "PLSExtProc" has 1 instance(s).
      Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully
    A single listener can listen on 1 or more ports, but by doing so the different ports are not database/instance specific.

    At best, minimal benefit is obtained by listening on multiple ports.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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