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)