ORACLE.EXE Hangs With Increase in Non-Paged Pool Memory . BEQ Connection may Fail With ORA-12560 (Doc ID 866622.1)

Last updated on OCTOBER 31, 2016

Applies to:

Oracle Net Services - Version 8.1.7.0 to 10.2.0.4.0 [Release 8.1.7 to 10.2]
Oracle Database - Enterprise Edition - Version 8.1.7.0 to 10.2.0.4 [Release 8.1.7 to 10.2]
z*OBSOLETE: Microsoft Windows
Microsoft Windows


Symptoms

Oracle database instance will hang after several hours .

The BEQ (bequeath) connection fails with :

ERROR:
ORA-12560: TNS:proto adapter error
ERROR: ORA-12500: TNS:listener failed to start a dedicated server process

The remote connections fail with :

TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12540: TNS:internal limit restriction exceeded
TNS-12560: TNS:protocol adapter error
TNS-00510: Internal limit restriction exceeded
32-bit Windows Error: 8: Exec format error

You may see the below symptoms :
---------------------------------

1] The SQL> count (*) from v$processes; shows the count below the limit defined in the parameter file.
2] The memory usage of oracle.exe is well below the 32-bit limitation .
3] Monitoring the ORACLE.EXE process using process explorer / Task Manager shows an abnormal non-paged pool  count which keeps on increasing. (In terms of MB)
4] Usually the non-paged pool count for an ORACLE.EXE would be less than an MB. You might see the non-paged pool count for other instance (oracle.exe) on the same machine less than 1MB.
5] Many handles persist (the process explorer output shown in the screenshot below) thus keeping non-paged pool at a high level .

 

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