| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: New Listener Question
I disagree. Mine only registers itself if I have the "service_names" entry in the init.ora file. Comment this line out and see what happens...
-----Original Message-----
Smith
Sent: Tuesday, July 17, 2001 1:31 PM
To: Multiple recipients of list ORACLE-L
In Oracle 8i a database will self register with the default listener even if you do not have it defined. There are parameters that you can put in your init.ora to prevent this.
-----Original Message-----
Sent: Tuesday, July 17, 2001 9:35 AM
To: Multiple recipients of list ORACLE-L
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))
)
(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
(c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.
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
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
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: kimberly.smith_at_gmd.fujitsu.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: c-glenn.travis_at_wcom.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Jul 18 2001 - 10:03:44 CDT
 |
 |