Sunday 19 July 2020

ERROR at line 1: ORA-03113: end-of-file on communication channel ERROR: ORA-03114: not connected to ORACLE

ERROR:
======
sqlplus -s APPS/***** @/mwdb-pl/ebsap/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/mwdb-pl/ebsap/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/ADZDWRKR.sql &un_apps &systempwd CUTOVER 0 3 10'
Connected.
PL/SQL procedure successfully completed.
Connected.
Session altered.
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.

SOLUTIONS:
=========

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

OS Watcher Installation in RAC

 Step:1 Download and untar the oswbb812.tar under the grid user in RAC on the both nodes. Follow the OS Watcher User's Guide (Doc ID 153...