Internal Error with ResponseCode=1000 ReasonCode=2000(ALL_DB_DOWN)

Document ID : KB000007736
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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. 
08/16/17 14:17:26.290 INFO TXN_NATIVE -269493392 115230562 - ArDBPoolManagerImpl::reportQueryFailure: Notifying the monitor thread on database failure. 
08/16/17 14:17:26.291 WARN MONITOR -178353296 0MONITOR - ArDBPoolManagerImpl::recoverPool: [primary] pool [arcotdsn] is marked bad. Will try to clean and connect... 
08/16/17 14:17:26.291 INFO MONITOR -178353296 0MONITOR - ArDBPool::clean Pool [(primary)]: [1] number of connections are still held. Waiting for [100] milli secs. 
08/16/17 14:17:26.291 INFO TXN_NATIVE -269493392 115230562 - ArDBM::Detected a DB-FailOver situation while executing Query[SysQuery_FetchTime] 
08/16/17 14:17:26.291 INFO TXN_NATIVE -269493392 115230562 - ArDBPoolManagerImpl::getLockedDBConnection: Pool marked as active [primary] is not alive *now*. Will check another pool 
08/16/17 14:17:26.295 WARN TXN_NATIVE -269493392 115230562 - ArDBM::Caught ArcotException in _DbOp!. err : [Arcot Exception,Error: All database pools are inactive] 
08/16/17 14:17:26.295 WARN TXN_NATIVE -269493392 115230562 - Failed to get time from DB (System time will be taken) 
08/16/17 14:17:26.295 INFO TXN_NATIVE -269493392 115230562 - Txn-Begin : TxnID=115230562 | ClientTxnID=[_ZDDX_1_45] | Protocol=5 (TXN_NATIVE) | ReqSize=53 | TST=2017-08-16 21:17:26:295 (SYS) 
08/16/17 14:17:26.296 WARN TXN_NATIVE -269493392 115230562 - All the Databases are down!.Aborting the transaction and setting response code as INTERNAL_ERROR 
08/16/17 14:17:26.296 INFO TXN_NATIVE -269493392 115230562 - Caught ArWFTxnAbortException in WebFortFrameworkImpl::process while attempting to do Self check prior to transaction processing. 
08/16/17 14:17:26.296 INFO TXN_NATIVE -269493392 115230562 - ArWFTxnAbortException. : Response Code: [1000] Reason Code: [2000] Detail: [All the Databases are down - detected by self check prior to transaction processing] 
08/16/17 14:17:26.297 INFO TXN_NATIVE -269493392 115230562 - Txn-End : TxnID=115230562 | ClientTxnID=[_ZDDX_1_45] | Processor=21 (USERMGMT) | Operation=2005 (ISSUANCE_USER_GET_PAM) | Response=1000 (INTERNAL_ERROR) | Reason=2000 (ALL_DB_DOWN) | RespSize=78 | Time=31 | DBT=27 | NQ=1 | ExtEvents={ NONE } | AddInfo=[NONE] | LTB=01129 | LNL=0005/0005 | LML=227 

=====================================================   End of arcotwebfort.log ==========================================

Environment:
Production
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:
Search for links for "How to set IDLE_TIME in Oracle Database" in for detailed instructions. Here is a suggested link
 
https://oracleracdba1.wordpress.com/2014/08/06/how-to-set-idle-time-in-oracle-database/