In this Document
Symptoms |
Changes |
Cause |
Solution |
References |
APPLIES TO:
Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]Information in this document applies to any platform.
SYMPTOMS
Installed the Oracle 11.2.0.3 Grid Infrastructure and encountered the following status on SCAN listener when running 'crsctl stat res -t'.
ora.LISTENER_SCAN1.lsnr
1 ONLINE INTERMEDIATE psdphprddb02 Not All Endpoints Registered
1 ONLINE INTERMEDIATE psdphprddb02 Not All Endpoints Registered
$GRID_HOME\log\diag\tnslsnr\<hostname>\listener_scan1\trace\listener_scan1.log
08-JUL-2013 21:35:46 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=SYSTEM))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER_SCAN1)(VERSION=186647296)) * status * 0
Mon Jul 08 21:35:57 2013
08-JUL-2013 21:35:57 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=pssvcora01))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER_SCAN1)(VERSION=186647296)) * status * 0
Mon Jul 08 21:36:44 2013
08-JUL-2013 21:36:44 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=SYSTEM))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER_SCAN1)(VERSION=186647296)) * status * 0
08-JUL-2013 21:36:44 * service_died * LsnrAgt * 12537
08-JUL-2013 21:36:45 * version * 0
Error listening on: (ADDRESS=(PROTOCOL=TCP)(HOST=172.17.235.139)(PORT=1521))
08-JUL-2013 21:36:45 * service_register * LsnrAgt * 12542
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
64-bit Windows Error: 48: Unknown error
Mon Jul 08 21:35:57 2013
08-JUL-2013 21:35:57 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=pssvcora01))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER_SCAN1)(VERSION=186647296)) * status * 0
Mon Jul 08 21:36:44 2013
08-JUL-2013 21:36:44 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=SYSTEM))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER_SCAN1)(VERSION=186647296)) * status * 0
08-JUL-2013 21:36:44 * service_died * LsnrAgt * 12537
08-JUL-2013 21:36:45 * version * 0
Error listening on: (ADDRESS=(PROTOCOL=TCP)(HOST=172.17.235.139)(PORT=1521))
08-JUL-2013 21:36:45 * service_register * LsnrAgt * 12542
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
64-bit Windows Error: 48: Unknown error
CHANGES
None, all of the basic configuration checks at RAC/clusterware level seems to show a correct configuration.
CAUSE
The local node HOSTS file (on Windows: c:\windows\system32\drivers\etc\hosts, on UNIX: /etc/hosts) file may contain a duplicate entry.
SOLUTION
For hosts file configuration in RAC, refer to the section "Example of what we expect" from Document 1054902.1