lsnrctl services

[Scunningham99]

Hi We are having a problem with one of our servers in rac, wherby instance "ausl2" is not registering correctly with the listener as it is picking up sunatlsunx001 as the host, but this should be sunatlsunx002.

see below:-

Service "auslive.sunterra.com" has 4 instance(s).
Instance "ausl1", status READY, has 2 handler(s) for this service...
Handler(s):
"D001" established:0 refused:0 current:2 max:1002 state:ready
DISPATCHER <machine: sunatlsunx001, pid: 4941>
(ADDRESS=(PROTOCOL=tcp)(HOST=sunatlsunx001.sunterra.com)(PORT=32800))
"DEDICATED" established:0 refused:0 state:ready
REMOTE SERVER
(ADDRESS=(PROTOCOL=TCP)(HOST=sunatlsunx001)(PORT=1521))
Instance "ausl2", status READY, has 2 handler(s) for this service...
Handler(s):
"D001" established:0 refused:0 current:0 max:1002 state:ready
DISPATCHER <machine: sunatlsunx002, pid: 3603>
(ADDRESS=(PROTOCOL=tcp)(HOST=sunatlsunx002.sunterra.com)(PORT=32799))
"DEDICATED" established:0 refused:0 state:blocked
REMOTE SERVER
(ADDRESS=(PROTOCOL=TCP)(HOST=sunatlsunx001) <<--- here should be sunatlsunx002 """(PORT=1521))
Instance "ausl3", status READY, has 2 handler(s) for this service...
Handler(s):
"D001" established:0 refused:0 current:3 max:1002 state:ready
DISPATCHER <machine: sunatlsunx003, pid: 4765>
(ADDRESS=(PROTOCOL=tcp)(HOST=sunatlsunx003.sunterra.com)(PORT=32788))
"DEDICATED" established:0 refused:0 state:ready
REMOTE SERVER
(ADDRESS=(PROTOCOL=TCP)(HOST=sunatlsunx003)(PORT=1521))
Instance "ausl4", status READY, has 2 handler(s) for this service...
Handler(s):
"D001" established:0 refused:0 current:1 max:1002 state:ready
DISPATCHER <machine: sunatlsunx004, pid: 4247>
(ADDRESS=(PROTOCOL=tcp)(HOST=sunatlsunx004.sunterra.com)(PORT=32785))
"DEDICATED" established:0 refused:0 state:ready
REMOTE SERVER
(ADDRESS=(PROTOCOL=TCP)(HOST=sunatlsunx004)(PORT=1521))
The command completed successfully


Sy UK

 

[SantaMufasa]

Sy,

Please do the following for us:

1) Invoke "lsnrctl"...enter the command, "status"
2) Confirm the fully qualified name of the "listener.ora" file.
3) Post the contents of that "listener.ora" file so we can troubleshoot/confirm the contents.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]

 

[Scunningham99]

Hi

1) $ lsnrctl status

LSNRCTL for Linux: Version 9.2.0.6.0 - Production on 25-APR-2006 04:52:39

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sunatlsunx002)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 9.2.0.6.0 - Production
Start Date 24-APR-2006 00:47:12
Uptime 1 days 4 hr. 5 min. 27 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /u01/oracle/product/9.2.0/network/admin/listener.ora
Listener Log File /u01/oracle/product/9.2.0/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sunatlsunx002.sunterra.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sunatlsunx002.sunterra.com)(PORT=8080))(Presentation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sunatlsunx002.sunterra.com)(PORT=2100))(Presentation=FTP)(Session=RAW))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "ausl2" has 1 instance(s).
Instance "ausl2", status UNKNOWN, has 1 handler(s) for this service...
Service "auslXDB.sunterra.com" has 4 instance(s).
Instance "ausl1", status READY, has 1 handler(s) for this service...
Instance "ausl2", status READY, has 1 handler(s) for this service...
Instance "ausl3", status READY, has 1 handler(s) for this service...
Instance "ausl4", status READY, has 1 handler(s) for this service...
Service "auslive.sunterra.com" has 4 instance(s).
Instance "ausl1", status READY, has 2 handler(s) for this service...
Instance "ausl2", status READY, has 3 handler(s) for this service...
Instance "ausl3", status READY, has 2 handler(s) for this service...
Instance "ausl4", status READY, has 2 handler(s) for this service...
The command completed successfully



2)
$ more listener.ora
# LISTENER.ORA.SUNATLSUNX002 Network Configuration File: /u01/oracle/product/9.2
.0/network/admin/listener.ora.sunatlsunx002
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sunatlsunx002)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/oracle/product/9.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = ausl2)
(ORACLE_HOME = /u01/oracle/product/9.2.0)
)
)

LISTENER_RACT2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sunatlsunx002)(PORT = 1522))
)
)
)

SID_LIST_LISTENER_RACT2 =
(SID_LIST =
(SID_DESC =
(SID_NAME = RACT2)
(ORACLE_HOME = /u01/oracle/product/9.2.0)
)
)

thanks in advance...




Sy UK

 

[SantaMufasa]

Sy,

Is there a chance that you have started up a LISTENER from some other machine (such as "sunatlsunx001")?...which would account for the LISTENER's confusion.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]

 

[Scunningham99]

Hi Thanks for reply.

We started each listener in turn on each of the 4 nodes as local listeners.

any ideas?


Sy UK

 

[SantaMufasa]

Yes, my idea is that you must check the contents of each listener.ora. When this same sort of thing has happened to me in the past, it is because of an inadvertent server "mis-specification" in some obscure listener.ora (typically on some "other" machine) that I never would have thought would have/could have caused the problem.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]