OBIA 11g ETL Hangs with ODI-1228 / ORA-01089: immediate shutdown in progress - no operations are permitted / ORA-06512: at "SYS.DBMS_PARALLEL_EXECUTE"
(Doc ID 1957960.1)
Last updated on FEBRUARY 01, 2022
Applies to:
Business Intelligence Applications Consumer - Version 11.1.1.8.1 and laterInformation in this document applies to any platform.
Symptoms
While attempting to run an ETL with EBS as the datasource for OFA, part way through the ETL, encountering a step where approximately 10 indexes are being built. The ETL hangs at this step for many hours before failing with the following errors:
ODI-1228: Task SIL_APTransactionFact_Reverse_DiffManLoad.W_AP_XACT_F (Integration) fails on the target ORACLE connection BIAPPS_DW.
Caused By: java.sql.SQLRecoverableException: ORA-01089: immediate shutdown in progress - no operations are permitted
ORA-06512: at "SYS.DBMS_LOCK", line 205
ORA-06512: at "SYS.DBMS_PARALLEL_EXECUTE", line 44
ORA-06512: at "SYS.DBMS_PARALLEL_EXECUTE", line 391
ORA-06512: at "SYS.DBMS_PARALLEL_EXECUTE", line 418
ORA-06512: at line 109
ODI-1228: Task SIL_GLLinkageInformationGeneral.W_GL_LINKAGE_INFORMATION_G (Integration) fails on the target ORACLE connection BIAPPS_DW.
Caused By: java.sql.SQLRecoverableException: ORA-01089: immediate shutdown in progress - no operations are permitted
ORA-06512: at "SYS.DBMS_LOCK", line 205
ORA-06512: at "SYS.DBMS_PARALLEL_EXECUTE", line 44
ORA-06512: at "SYS.DBMS_PARALLEL_EXECUTE", line 391
ORA-06512: at "SYS.DBMS_PARALLEL_EXECUTE", line 418
ORA-06512: at line 109
ODI-1228: Task SIL_BudgetFact.W_ACCT_BUDGET_F (Integration) fails on the target ORA
CLE connection BIAPPS_DW.
Caused By: java.sql.SQLRecoverableException: ORA-01089: immediate shutdown in progress - no operations are permitted
ORA-06512: at "SYS.DBMS_LOCK", line 205
ORA-06512: at "SYS.DBMS_PARALLEL_EXECUTE", line 44
ORA-06512: at "SYS.DBMS_PARALLEL_EXECUTE", line 391
ORA-06512: at "SYS.DBMS_PARALLEL_EXECUTE", line 418
ORA-06512: at line 109
Caused By: java.sql.SQLRecoverableException: ORA-01089: immediate shutdown in progress - no operations are permitted
ORA-06512: at "SYS.DBMS_LOCK", line 205
ORA-06512: at "SYS.DBMS_PARALLEL_EXECUTE", line 44
ORA-06512: at "SYS.DBMS_PARALLEL_EXECUTE", line 391
ORA-06512: at "SYS.DBMS_PARALLEL_EXECUTE", line 418
ORA-06512: at line 109
ODI-1228: Task SIL_GLLinkageInformationGeneral.W_GL_LINKAGE_INFORMATION_G (Integration) fails on the target ORACLE connection BIAPPS_DW.
Caused By: java.sql.SQLRecoverableException: ORA-01089: immediate shutdown in progress - no operations are permitted
ORA-06512: at "SYS.DBMS_LOCK", line 205
ORA-06512: at "SYS.DBMS_PARALLEL_EXECUTE", line 44
ORA-06512: at "SYS.DBMS_PARALLEL_EXECUTE", line 391
ORA-06512: at "SYS.DBMS_PARALLEL_EXECUTE", line 418
ORA-06512: at line 109
ODI-1228: Task SIL_BudgetFact.W_ACCT_BUDGET_F (Integration) fails on the target ORA
CLE connection BIAPPS_DW.
Caused By: java.sql.SQLRecoverableException: ORA-01089: immediate shutdown in progress - no operations are permitted
ORA-06512: at "SYS.DBMS_LOCK", line 205
ORA-06512: at "SYS.DBMS_PARALLEL_EXECUTE", line 44
ORA-06512: at "SYS.DBMS_PARALLEL_EXECUTE", line 391
ORA-06512: at "SYS.DBMS_PARALLEL_EXECUTE", line 418
ORA-06512: at line 109
Changes
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 |
Changes |
Cause |
Solution |
References |