Windows: Ora.LISTENER.lsnr Status goes to INTERMEDIATE CHECK TIMED OUT

(Doc ID 1523366.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Generic Windows

Symptoms

The local listeners or scan listeners will be unreachable and the status shows  either INTERMEDIATE or UNKNOWN CHECK TIMED OUT.

From the listener logs:

 Thu Oct 11 05:59:55 2012
 11-OCT-2012 05:59:55 *
 (CONNECT_DATA=(SID=DWPRD1)(CID=(PROGRAM=D:\app\Middleware\agent11g\perl\bin\pe
 rl.exe)(HOST=myrachost3)(USER=SYSTEM))) *
 (ADDRESS=(PROTOCOL=tcp)(HOST=X.X.X.X)(PORT=4120)) * establish * DWPRD1 * 0
 11-OCT-2012 05:59:56 *
 (CONNECT_DATA=(SID=AMDPRD1)(CID=(PROGRAM=D:\app\Middleware\agent11g\perl\bin\p erl.exe)(HOST=myrachost3)(USER=SYSTEM))) *
 (ADDRESS=(PROTOCOL=tcp)(HOST=X.X.X.X)(PORT=4123)) * establish * AMDPRD1 *0
 11-OCT-2012 05:59:58 * 12531
 TNS-12531: TNS:cannot allocate memory      <<<<<<<<<<<<
 11-OCT-2012 05:59:59 * 12531
 TNS-12531: TNS:cannot allocate memory
 Thu Oct 11 06:00:06 2012
 11-OCT-2012 06:00:06 * service_update * dwprd1 * 0
 11-OCT-2012 06:00:12 * service_update * cayprod1 * 0
 11-OCT-2012 06:00:15 *
 (CONNECT_DATA=(SERVICE_NAME=DW02)(CID=(PROGRAM=d:\app\oracle\product\10.2.0\db
 _1\bin\ORACLE.EXE)(HOST=myrachost3)(USER=SYSTEM))(SERVER=dedicated)(INSTANCE_NAME
 =dwprd1)) * (ADDRESS=(PROTOCOL=tcp)(HOST=X.X.X.X)(PORT=4333)) * establish * DW02 * 0
 11-OCT-2012 06:00:15 * service_update * dwprd1 * 0
 Thu Oct 11 06:00:18 2012

 

The cvutrace shows:

 [11932@racdb03] [main] [ 2012-10-11 05:00:31.389 PDT ]
 [VerificationUtil.getNodelist:685]  ==== Nodelist after: nodelist[0]:racdb03
 Exception in thread "main" java.lang.NullPointerException
     at
 sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:989)
     at java.lang.Double.valueOf(Double.java:447)
     at java.lang.Double.<init>(Double.java:539)
     at
 oracle.ops.verification.framework.engine.component.FreeSpaceComponent.initiali
 zeReqdValues(FreeSpaceComponent.java:240)
     at
 oracle.ops.verification.framework.engine.component.FreeSpaceComponent.init(Fre
 eSpaceComponent.java:98)
     at
 oracle.ops.verification.framework.engine.component.FreeSpaceComponent.<init>(F
 reeSpaceComponent.java:85)
     at
 oracle.ops.verification.framework.engine.component.ComponentFactory.createComp
 onent(ComponentFactory.java:164)
     at
 oracle.ops.verification.framework.engine.component.HealthComponent.verifyCompo
 nents(HealthComponent.java:205)
     at
 oracle.ops.verification.framework.engine.component.HealthComponent.verify(Heal
 thComponent.java:139)
     at
 oracle.ops.verification.framework.engine.ClusterVerifier.verifyComponent(Clust
 erVerifier.java:117)
     at
 oracle.ops.verification.client.CluvfyDriver.main(CluvfyDriver.java:276)

 

We can see that lot more cmd.exe processes are hanging in Task Manager.

Name                Pid    Pri  Thd  Hnd   Priv       CPU Time     Elapsed Time
 cmd               12640   8   1   33   2972     0:00:00.015    72:09:09.142
 cmd               12292   8   1   33   2972     0:00:00.046    66:09:09.109
 cmd               11376   8   1   33   2972     0:00:00.046    60:09:09.140
 cmd               12540   8   1   33   2972     0:00:00.031    54:09:09.354
 cmd               12468   8   1   33   2972     0:00:00.031    48:09:09.214
 cmd                8804   8   1   33   2972     0:00:00.031    42:09:09.384
 cmd                3248   8   1   33   2972     0:00:00.046    36:09:09.550
 cmd               13020   8   1   33   2972     0:00:00.015    30:09:09.393
 cmd               11384   8   1   33   2972     0:00:00.031    24:09:09.598
 cmd               10224   8   1   33   2972     0:00:00.031    18:09:09.804
 cmd                6960   8   1   33   2972     0:00:00.015    12:09:09.570
 cmd               12576   8   1   33   2972     0:00:00.031     6:09:09.925
 cmd                4680   8   1   33   2972     0:00:00.031     0:09:10.021

 

Other symptoms we may see when hitting this issue are:

o TNSping reports TNS-12541 TNS:No listener
o LSNRCTL services errors with TNS-01189: The Listener could not authenticate the user
o LSNRCTL status hangs
o Java Application log reports - java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms