OBIA 11g ETL Hangs with ODI-1228 / ORA-01089: immediate shutdown in progress - no operations are permitted / ORA-06512: at "SYS.DBMS_PARALLEL_EXECUTE"
Last updated on APRIL 03, 2018
Applies to:
Business Intelligence Applications Consumer - Version 11.1.1.8.1 and laterInformation in this document applies to any platform.
Checked for currency April 03, 2018
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
Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms