R12.2 Apps DBA. Powered by Blogger.

After Applying RUP And Cutover Failing With Ora-07445 Errors (Doc ID 2191199.1)

No comments :
SYMPTOMS
On : 12.2.4 version, ISSUES WITH FUNCTIONALITY OF AD UTILITIES
Cutover failing with ora-07445 errors, after RUP 8 is applied. It is failing with ora-07445 errors in worker log file
ora-07445 [audbfr()+130]
Patch log files show:
ATTENTION: All workers either have failed or are waiting:
FAILED: file ADZDWRKR.sql on worker 1.
FAILED: file ADZDWRKR.sql on worker 2.
FAILED: file ADZDWRKR.sql on worker 3.
FAILED: file ADZDWRKR.sql on worker 4.
FAILED: file ADZDWRKR.sql on worker 5.
FAILED: file ADZDWRKR.sql on worker 6.
FAILED: file ADZDWRKR.sql on worker 7.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Worker log files show:
PL/SQL procedure successfully completed.
declare
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
ERROR:
ORA-03114: not connected to ORACLE
CAUSE
 Database Auditing is Enabled.
SOLUTION
Disable Auditing with the following steps:
1- SHOW PARAMETER AUDIT
2- Check audit_trail='DB','EXTENDED'
none or false - Auditing is disabled.
db or true - Auditing is enabled, with all audit records stored in the database audit trial (SYS.AUD$).
db,extended - As db, but the SQL_BIND and SQL_TEXT columns are also populated.
xml- Auditing is enabled, with all audit records stored as XML format OS files.
xml,extended - As xml, but the SQL_BIND and SQL_TEXT columns are also populated.
os- Auditing is enabled, with all audit records directed to the operating system's audit trail.
3-  NOAUDIT ALL;
4-  alter system set audit_trail='NONE';
5- Reboot database
6- Retest the issue, it should go successful.

No comments :

Post a Comment

Note: only a member of this blog may post a comment.