The errors found in the listener.log after crash : 26-OCT-2008 14:27:37 * (CONNECT_DATA=(SERVICE_NAME=PSD)(FAILOVER_MODE=(TYPE=SEL TNS-12582: TNS:invalid operation TNS-12623: TNS:operation is illegal in this state TNS-12518: TNS:listener could not hand off client connection TNS-12547: TNS:lost contact TNS-12560: TNS:protocol adapter error TNS-00517: Lost contact VMS Error: 32: insufficient privilege or object protection violationasync event) 26-OCT-2008 14:27:37 * service_update * MANDB2 * 0 ================================================== PSDDB1 ORACLE> LSNRCTL STAT LSNRCTL for VMS: Version 10.2.0.2.0 - Production on 29-OCT-2008 11:44:03 Copyright (c) 1991, 2005, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER_PSDDB1 Version TNSLSNR for VMS: Version 10.2.0.2.0 - Production Start Date 28-OCT-2008 14:31:05 Uptime 0 days 21 hr. 13 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File ORACLEHOME:[ORACLE.PSDRACHOME.network.admin]listener.o ra Listener Log File ORACLEHOME:[ORACLE.PSDRACHOME.network.log]listener_psd db1.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.4.21)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.4.41)(PORT=1521))) Services Summary... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... Service "PSD" has 2 instance(s). Instance "MANDB1", status READY, has 2 handler(s) for this service... Instance "MANDB2", status READY, has 1 handler(s) for this service... Service "PSD_XPT" has 2 instance(s). Instance "MANDB1", status READY, has 2 handler(s) for this service... Instance "MANDB2", status READY, has 1 handler(s) for this service... The command completed successfully PSDDB1 ORACLE> ================================================ - Checking quota for listeners : which seems very good: on psddb2: Process Name ORA_R_PSDDB2485 Process Id 204112E6 Images Invoked so far 2 Username ORACLE Current image $1$DGA2:[ORACLE.PSDRACHOME.][bin]TNSLSNR.EXE;1 Time 29-OCT-2008 10:53:36.89 Process State HIB Page faults 1533 Pages Available 2147483647 -------------------------------------------------------------------------------- PROCESS RESOURCE QUOTAS Resource Unused Quota %Remain | Resource Unused Quota %Remain | CPU limit 6365 0 ---% | Direct I/O 150 150 100% Byte limit 659584 659584 100% | Buff I/O 141 150 94% Timer Q 98 100 98% | File Lim 2042 2048 99% Page file 1975488 2000000 98% | Sub-proc's 32 32 100% Enqueue 8192 8192 100% | AST limit 988 1000 98% WS Current 2034576 2103296 96% | | ====================================================== on psddb1: PROCESS MONITOR Process Name ORA_R_PSDDB1491 Process Id 202181B8 Images Invoked so far 2 Username ORACLE Current image $1$DGA2:[ORACLE.PSDRACHOME.][bin]TNSLSNR.EXE;1 Time 29-OCT-2008 10:53:43.05 Process State HIB Page faults 1650 Pages Available 2147483647 -------------------------------------------------------------------------------- PROCESS RESOURCE QUOTAS Resource Unused Quota %Remain | Resource Unused Quota %Remain | CPU limit 9293 0 ---% | Direct I/O 150 150 100% Byte limit 662784 662784 100% | Buff I/O 141 150 94% Timer Q 98 100 98% | File Lim 2042 2048 99% Page file 1973824 2000000 98% | Sub-proc's 32 32 100% Enqueue 8192 8192 100% | AST limit 988 1000 98% WS Current 2034576 2103296 96% | |