2016-06-09

HTTP 500: Internal Server Error when login to a new cloned environment

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)