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