My Oracle Support Banner

FNDSCPRG Purge Signon Audit Data Program Fails With ORA-01578, ORA-01110 (Doc ID 1459317.1)

Last updated on JULY 29, 2018

Applies to:

Oracle Application Object Library - Version 12.0.4 to 12.2 [Release 12 to 12.2]
Information in this document applies to any platform.
Reviewed for Relevance 29 Jul 18.

Symptoms

When attempting to submit Purge Signon Audit Data concurrent request, it completes with error shown in the request log:


Concurrent Manager encountered an error while running SQL*Plus for your concurrent request <request_id>

When attempting to view the output file by selecting the View Output Button, the following error also occurs:

ERROR
-----------------------
FND_LOGIN_RESP_FORMS
FND_LOGIN_RESPONSIBILITIES
FND_LOGINS
delete from fnd_logins
  *
ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 487, block # 178788)
ORA-01110: data file 487: '+DATA/prd/datafile/apps_ts_archive.304.720876655'

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.