Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> dynamic service registration
Platform: Oracle 9.2 EE on Solaris 8
The last couple of days I've been playing around with the tns config on a new 'sandbox' server we just put up. It's all working, but I've been tweaking a few things to see what I can learn. What I've learned is that I didn't understand as well as I thought.
For instance, given the following:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxxxx)(PORT = 1521)) )
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = VITSB01)) )
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = VITSB01)
(ORACLE_HOME = /u01/app/oracle/product/9.2.0.1.0)
(GLOBAL_DBNAME = VITSB01)
)
)
listener status give the following. Notice that there is one instance of service VITSB01 listed, and in the Listening Endpoints Summary...the host is listed by IP address. :
LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 19-MAR-2004 09:52:41
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxxxx)(PORT=1521)))
STATUS of the LISTENER
Alias LISTENER Version TNSLSNR for Solaris: Version 9.2.0.1.0 - Production Start Date 19-MAR-2004 09:41:08 Uptime 0 days 0 hr. 11 min. 33 sec Trace Level off Security OFF SNMP OFF
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=nn.nnn.nnn.nnn)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=VITSB01)))
Services Summary...
Service "VITSB01" has 1 instance(s).
Instance "VITSB01", status UNKNOWN, has 1 handler(s) for this
service...
The command completed successfully
And yet, on a system that this was modeled after, I have the following
And lsnrctl status gives this. Notice that there are two instances of service CMPM1240 listed, and in the Listening Endpoints Summary...the host is listed by server name. :
LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 19-MAR-2004 09:58:36
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxxxx)(PORT=1521)))
STATUS of the LISTENER
Alias LISTENER Version TNSLSNR for Solaris: Version 9.2.0.1.0 - Production Start Date 04-MAR-2004 21:00:02 Uptime 14 days 12 hr. 58 min. 34 sec Trace Level off Security OFF SNMP OFF
So, if someone would care to clarify this or point me to some additional reading, I'd appreciate it. This is a situation where I know how to make it work, but I don't understand it. Received on Fri Mar 19 2004 - 11:07:51 CST
![]() |
![]() |