Saturday, December 5, 2020

Cleanup in STANDARD mode is failing in EBS

 Error Info :

Running cleanup in STANDARD mode.
Log: @ADZDSHOWLOG.sql "2020/11/25 14:14:50"

Statement Handler Error Code: 600
Statement Handler Error Message: ORA-00600: internal error code, arguments: [15239], [], [], [], [], [], [], [], [], [], [], []

ORA-06512: at "SYS.DBMS_SQL", line 1163

ORA-06512: at "SYS.AD_ZD_SYS", line 263

ORA-06512: at "APPS.AD_ZD", line 447

ORA-06512: at "APPS.AD_ZD", line 960

ORA-06512: at line 3 (DBD ERROR: OCIStmtExecute)

Reference of statement-handler is valid, not attempting database reconnect.

Failed to execute SQL statement:
begin

execute immediate 'alter session set DDL_LOCK_TIMEOUT = 600';
ad_zd.cleanup('STANDARD');

end;

Error Message:

ORA-00600: internal error code, arguments: [15239], [], [], [], [], [], [], [], [], [], [], []

ORA-06512: at "SYS.DBMS_SQL", line 1163

ORA-06512: at "SYS.AD_ZD_SYS", line 263

ORA-06512: at "APPS.AD_ZD", line 447

ORA-06512: at "APPS.AD_ZD", line 960

ORA-06512: at line 3 (DBD ERROR: OCIStmtEx
Diagnosis: Select the 'Next' button to proceed with the creation of the SR.

Solution: 

Steps to patch the data dictionary (trigger$):

1) It is recommended to take a full backup or enable flashback in case it is needed to restore the database to a point in time before modifying the data dictionary. ----> You have already taken the backup and now you are doing the patching on the Non-Prod (Test) server.

2) SHUTDOWN IMMEDIATE and STARTUP UPGRADE.

SQL> shutdown immediate;

SQL> startup upgrade;

3) Create a new user called PATCH_USER, the user# assigned will be used to update TRIGGER$:

SQL> create user PATCH_USER identified by <password>;

4) Update TRIGGER$ with the user id of PATCH_USER

SQL> update trigger$ set baseobject = (select user# from sys.user$ where name = 'PATCH_USER') where obj# = &obj;

In the example above the obj value to be provided as input is OBJ#= 7132051 & 7132052.

SQL> update trigger$ set baseobject = (select user# from sys.user$ where name = 'PATCH_USER') where obj# = 7132051;

SQL> update trigger$ set baseobject = (select user# from sys.user$ where name = 'PATCH_USER') where obj# = 7132052;

5) COMMIT;

6) SHUTDOWN ABORT -- It must be shutdown abort
7) STARTUP

8) Drop the trigger:

SQL> drop trigger SCOTT.LOGON_TRG; ----> Here mention the Trigger which is causing an issue in your environment.  Verify alert log and trace log file to get the Trigger name at the time of error .

9) Drop user created in step 3:
SQL> drop user PATCH_USER;

Retest the issue now ,It will resolve .

No comments:

Post a Comment

ORACLE DATABASE CONTENT

ORACLE DATABASE 11gR2 & 12C  CONTENT Pre-Requisite: UNIX, SQL Basics Introduction to Oracle Database §   Introduction of Database ...