Issue:
Performed oracle ebs r12 application clone from PROD with RMAN Backup. Cloned instance is configured and services are brought up. When tried to launch the application getting HTTP-500 Internal error.
Checked application.log file under $LOG_HOME/ora/10.1.3/j2ee/oacore/oracore_default_group~1/ directory and found below errors.
Caused by: oracle.apps.jtf.base.resources.FrameworkException: Failure in CacheLoader: oracle.apps.jtf.base.resources.FrameworkException
Caused by: oracle.apps.jtf.base.resources.FrameworkException: ORA-01578: ORACLE data block corrupted (file # 131, block # 59236)
... 31 more
ORA-01110: data file 131: '/u01/oradata/UAT/apps_ts_tx_data_34.dbf'
ORA-26040: Data block was loaded using the NOLOGGING option
Cause:
As per metalink note 781413.1 the issue is Data in APPLSYS.WF_LOCAL_USER_ROLES are not synchronized.
query of table WF_LOCAL_USER_ROLES throws block corruption error
Solution:
Synchronize workflow tables from backend as below
sqlplus apps/<apps password>
set serveroutput on size 100000;
declare
begin
WF_LOCAL_SYNCH.BULKSYNCHRONIZATION(
P_ORIG_SYSTEM => 'ALL',
P_PARALLEL_PROCESSES => null,
P_LOGGING => null,
P_RAISEERRORS => TRUE);
exception
when others then
dbms_output.put_line('sqlerrm = ' || sqlerrm);
end;
/
Performed oracle ebs r12 application clone from PROD with RMAN Backup. Cloned instance is configured and services are brought up. When tried to launch the application getting HTTP-500 Internal error.
Checked application.log file under $LOG_HOME/ora/10.1.3/j2ee/oacore/oracore_default_group~1/ directory and found below errors.
Caused by: oracle.apps.jtf.base.resources.FrameworkException: Failure in CacheLoader: oracle.apps.jtf.base.resources.FrameworkException
Caused by: oracle.apps.jtf.base.resources.FrameworkException: ORA-01578: ORACLE data block corrupted (file # 131, block # 59236)
... 31 more
ORA-01110: data file 131: '/u01/oradata/UAT/apps_ts_tx_data_34.dbf'
ORA-26040: Data block was loaded using the NOLOGGING option
Cause:
As per metalink note 781413.1 the issue is Data in APPLSYS.WF_LOCAL_USER_ROLES are not synchronized.
query of table WF_LOCAL_USER_ROLES throws block corruption error
Solution:
Synchronize workflow tables from backend as below
sqlplus apps/<apps password>
set serveroutput on size 100000;
declare
begin
WF_LOCAL_SYNCH.BULKSYNCHRONIZATION(
P_ORIG_SYSTEM => 'ALL',
P_PARALLEL_PROCESSES => null,
P_LOGGING => null,
P_RAISEERRORS => TRUE);
exception
when others then
dbms_output.put_line('sqlerrm = ' || sqlerrm);
end;
/