dynamic service registration

From: Ed Stevens <nospam_at_noway.nohow>
Date: Fri, 19 Mar 2004 11:07:51 -0600
Message-ID: <6n8m505961qjtaqk45g436r6vr9n1jfsul@4ax.com>

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.ora (host name masked for public viewing)

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)

    )
  )

initVITSB01.ora

db_domain=""
db_name="VITSB01"
instance_name=VITSB01
service_names=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

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

Listener Parameter File
/u01/app/oracle/product/9.2.0.1.0/network/admin/listener.ora Listener Log File
/u01/app/oracle/product/9.2.0.1.0/network/log/listener.log Listening Endpoints Summary...

(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

listener.ora (host name masked)

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxxxx)(PORT = 1521))
    )
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = CMPM1240))
    )
  )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(ORACLE_HOME = /u01/app/oracle/product/9.2.0)
(SID_NAME = CMPM1240)

    )
  )

initVITSB01.ora

db_name = "CMPM1240"
service_names = CMPM1240
instance_name = CMPM1240
db_domain=""

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

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

Listener Parameter File
/u01/app/oracle/product/9.2.0/network/admin/listener.ora Listener Log File
/u01/app/oracle/product/9.2.0/network/log/listener.log Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxxxx)(PORT=1521)))   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=CMPM1240))) Services Summary...
Service "CMPM1240" has 2 instance(s).
  Instance "CMPM1240", status UNKNOWN, has 1 handler(s) for this service...
  Instance "CMPM1240", status READY, has 1 handler(s) for this service...
The command completed successfully

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