Internal Error with ResponseCode=1000 ReasonCode=2000(ALL_DB_DOWN)--> All database pools are inactive in Advanced Authentication
Article ID: 7736
Updated On:
Products
Issue/Introduction
Following footprints in arcotwebfort.log shown when an idle time exceeded - ORA-02396: exceeded maximum idle time, please connect again
================ Excerpt from arcotwebfort.log ===============================
08/16/17 14:17:26.285 INFO TXN_NATIVE -269493392 SVRMASTR - Generated TxnID : 115230562
08/16/17 14:17:26.290 INFO TXN_NATIVE -269493392 115230562 - Dbm::SQL State:08S01, Native Code: 95C, ODBC code: [CA Advanced Authentication][ODBC Oracle Wire Protocol driver][Oracle]ORA-02396: exceeded maximum idle time, please connect again
08/16/17 14:17:26.290 WARN TXN_NATIVE -269493392 115230562 - ArDBPoolManagerImpl::isKnownFailure: Error state [08S01] is detected as known failure(type:0)!
08/16/17 14:17:26.290 WARN TXN_NATIVE -269493392 115230562 - ArDBPoolManagerImpl::reportQueryFailure: Query failure is detected as DBFO for primary DSN [arcotdsn] and context [0]. Marking it bad.
===================================================== End of arcotwebfort.log ==========================================
Environment
Production
CA Strong Authentication
Cause
IDLE_TIME on the Oracle DB needs to be set as UNLIMITED.
Resolution
Connect to Oracle DB and Set the IDLE_TIME to "UNLIMITED". Here is output after the setting (using SQL prompt)
SQL> /PROFILE RESOURCE_NAME RESOURCE LIMIT—————————— ——————————– ——– —————————————-DEFAULT IDLE_TIME KERNEL UNLIMITED DEFAULT CONNECT_TIME KERNEL UNLIMITED SQL>Additional Information
Feedback
