Friday, February 14, 2014

HTTP-500 error in R12 instance after clone with ORA-01578

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;
/