Analytics Analysis Fails With ORA-01033: ORACLE Initialization Or Shutdown In Progress
(Doc ID 2658084.1)
Last updated on AUGUST 02, 2023
Applies to:
Primavera Analytics Cloud Service - Version 19.12 and laterInformation in this document applies to any platform.
Symptoms
When attempting to run a new analysis in Analytics (Primavera - Project user defined fields) and choosing project id and project name,
ERROR occurs.
ERROR
Odbc driver returned an error (SQLExecDirectW).
Error Details
Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 17001. [nQSError: 17001] Oracle Error code: 1033, message: ORA-01033: ORACLE initialization or shutdown in progress at OCI call OCISessionBegin. (HY000)
State: HY000. Code: 17014. [nQSError: 17014] Could not connect to Oracle database. (HY000)
SQL Issued: SELECT 0 s_0, "Primavera - Project User Defined Fields"."General - (Project)"."Project ID" s_1, "Primavera - Project User Defined Fields"."General - (Project)"."Project Name" s_2 FROM "Primavera - Project User Defined Fields" FETCH FIRST 65001 ROWS ONLY
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 |