OCI - Connection Request Sent To RAC Node In Mounted State Causing Application Connectivity Failure "java.sql.SQLException: ORA-01109: database not open"
(Doc ID 2969577.1)
Last updated on MAY 16, 2024
Applies to:
Oracle Cloud Infrastructure - Database Service - Version N/A to N/A [Release 1.0]Linux x86-64
Symptoms
Connection request sent to RAC node in the mounted state causing application connectivity failure "java.sql.SQLException: ORA-01109: database not open"
Application connectivity failed when the request was sent to the node which was down.
Message ODI-1217: Session ...fails with return code 8000.
ODI-1226: Step VAR_EXIXST_SESSION_NAME fails after 1 attempt(s).
ODI-1228: Task Variable-VAR_EXIXST_SESSION_NAME- fails on the target connection ODI_REPO.
Caused By: java.sql.SQLException: ORA-01109: database not open
ODI-1226: Step VAR_EXIXST_SESSION_NAME fails after 1 attempt(s).
ODI-1228: Task Variable-VAR_EXIXST_SESSION_NAME- fails on the target connection ODI_REPO.
Caused By: java.sql.SQLException: ORA-01109: database not open
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |