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

    Unanswered: Listener Configuration

    Hi,

    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!

    thanks,
    Alla

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    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
    Posts
    31
    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
    Location
    West Palm Beach, FL
    Posts
    2,713

    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
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Code:
    oracle@bcm-laptop:/u01/app/oracle/network/admin$ lsnrctl start
    
    LSNRCTL for Linux: Version 10.2.0.4.0 - 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 10.2.0.4.0 - 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)))
    STATUS of the LISTENER
    ------------------------
    Alias                     LISTENER
    Version                   TNSLSNR for Linux: Version 10.2.0.4.0 - 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...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bcm-laptop)(PORT=1521)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bcm-laptop)(PORT=1522)))
    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
  •