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 ==========================================
IDLE_TIME on the Oracle DB needs to be set as UNLIMITED.
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>