Environment
Oracle e-Business Suite 12.1.3 (Oracle EBS)
Oracle Linux 5.7
Symptoms
The following error occurs when trying to login to the new
cloned environment.
500 Internal Server Error
File application.log in $LOG_HOME/ora/10.1.3/j2ee/oacore/oacore_default_group_1
shows
Caused by: oracle.apps.jtf.base.resources.FrameworkException:
ORA-01578: ORACLE data block
corrupted (file # 12, block # 180784)
ORA-01110: data file 12:
'/data/oradata/TEST12/APPS_TS_SUMMARY01.dbf'
ORA-26040: Data block was loaded
using the NOLOGGING option
Solution
To identify the corrupted object use:
select s.*
from dba_extents s
where file_id = 12 -- change
and 180784 -- change
between block_id and (block_id
+ blocks -1);
It happened to be APPLSYS.WF_LOCAL_USER_ROLES
The solution is described in Oracle Support Doc ID 781413.1
sqlplus 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;
/
Useful info
Partitions in Workflow Local Tables are Automatically Switched to NOLOGGING (Doc ID 433280.1)
Http 500 : Internal Server Error When Login To A New Cloned Environment (Doc ID 781413.1)
