New Listener Question

From: Edward W. Carr <ecarr_at_qwest.com>
Date: Tue, 17 Jul 2001 08:27:30 -0700
Message-ID: <F001.0034C34B.20010717083524@fatcity.com>

First Off, I would like to thank everyone who replied yesterday, your answers were most helpful!

Today, I am facing a new puzzle. I am currently running 3 databases on a server, but only two of them are listed in the listener.ora (bdw and rcvr). If I do a 'lsnrctl status' it shows a listener for all three databases (bdw rcvr and webprod). How is this possible? I have included my current listener.ora and output from 'lsnrctl status' ... Also, people who access these databases go through VIRTUAL ip's, i.e. the box itself has IP address xxx.xxx.xxx.11 the bdw ip is xxx.xxx.xxx.31 and the webprod ip is xxx.xxx.xxx.30
The reason for the virt ip's is for the fail over we have in place, so people do not have to reconfigure their machines when we move the databases around.

So by all rights I do not see how anyone can connect, but they are?!?!?!? WTH??? Thanks again guys ...

# LISTENER.ORA Configuration
File:/apps/oracle/product/816/network/admin/listener.ora # Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = bdw1)(PORT = 1521))
      )

)
(DESCRIPTION =
(PROTOCOL_STACK =

        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )


      (ADDRESS = (PROTOCOL = TCP)(HOST = bdw1)(PORT = 2481))

)
)

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /apps/oracle/product/816)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = bdw)
(ORACLE_HOME = /apps/oracle/product/816)
(SID_NAME = bdw)

    )
    (SID_DESC =
(GLOBAL_DBNAME = rcvr)
(ORACLE_HOME = /apps/oracle/product/816)
(SID_NAME = rcvr)

    )
  )

oracle_at_bdw1 SID: bdw /apps/oracle/product/816/network/admin > lsnrctl status

LSNRCTL for Solaris: Version 8.1.6.0.0 - Production on 17-JUL-2001 09:24:30

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) STATUS of the LISTENER

Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 8.1.6.0.0 -
Production
Start Date                10-JUL-2001 15:14:01
Uptime                    6 days 18 hr. 10 min. 30 sec
Trace Level               off
Security                  OFF
SNMP                      OFF

Listener Parameter File
/apps/oracle/product/816/network/admin/listener.ora Listener Log File /apps/oracle/product/816/network/log/listener.log Services Summary...

  PLSExtProc            has 1 service handler(s)
  WEBPROD               has 2 service handler(s)
  bdw           has 1 service handler(s)
  bdw           has 1 service handler(s)
  rcvr          has 1 service handler(s)

The command completed successfully

Edward W. Carr
UNIX Systems Administrator
Qwest Communications
Broadband Services Inc.

Received on Tue Jul 17 2001 - 10:27:30 CDT