Last updated on JULY 11, 2016
Applies to:
Business Intelligence Applications Consumer - Version 11.1.1.8.1 and laterInformation in this document applies to any platform.
Checked for currency July 11, 2016
Symptoms
While attempting to run an ETL with EBS as the datasource for OFA, part way through the ETL, you encounter 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