Issue/Introduction:
Error Message :
ORA-03114: not connected to ORACLE
Workflows are not executing and Agents go into an offline status.
Investigation
Upon further investigation of the WP logs found in the Automation Engine's temp folder, the following error is seen:
20161026/072301.546 - U00003592 UCUDB - Status: '' Native error: '1089' Msg: 'ORA-01089: immediate shutdown in progress - no operations are permitted
Process ID: XXXXX
Session ID: XXXXX Serial number: XXXXX'
20161026/072301.546 - U00003536 UCUDB: FATAL DATA BASE ERROR: Re-connection will be attempted in 10 seconds.
20161026/072301.546 - U00003537 UCUDB - RECONNECT: DB call 'OCITransRollback': Return code: '-1'.
20161026/072301.546 - U00003590 UCUDB - DB error: 'OCITransRollback', 'ERROR ', '', 'ORA-03114: not connected to ORACLE'
20161026/072301.546 - U00003592 UCUDB - Status: '' Native error: '3114' Msg: 'ORA-03114: not connected to ORACLE'
20161026/072301.581 - U00003537 UCUDB - RECONNECT: DB call 'OCILogon': Return code: '-1'.
20161026/072301.581 - U00003590 UCUDB - DB error: 'OCILogon', 'ERROR ', '', 'ORA-12541: TNS:no listener'
Cause:
Cause type:
Other
Root Cause: Connection was lost between the Automation Engine and the Oracle database.
Environment:
OS Version: N/A
Resolution:
Contact your Database Administer to check connectivity to the Oracle database. The ORA-01089 error seen above indicates that the database is down. Therefore, we recommend that you ensure the database is available. Some things to check would be to:
- Ensure the Oracle listener is running on the server where you are attempting to establish the database connection
- Execute the tnsping command on the machine where you are attempting to establish the database connection to ensure that the database can be reached
- Attempt to establish a connection to the database from the server where AE is installed using the SQL*Plus command
Fix Status: No Fix
Fix Version(s):
N/A
Additional Information:
Workaround :
N/A