ORA-00600: internal error code, arguments: [2619], [2945]

Jump to table of contents
Dump continued from file: /oracle/diag/rdbms/apex/APEX/trace/APEX_mrp0_20439.trc
[TOC00001]
ORA-00600: internal error code, arguments: [2619], [2945], [], [], [], [], [], [], [], [], [], []
ORA-10877: error signaled in parallel recovery slave

Wed Aug 15 13:55:31 2018
Media Recovery Log /Archive/APEX/APEX_1_2945_981753388.arc
Errors in file /oracle/diag/rdbms/apex/APEX/trace/APEX_pr00_20444.trc 

(incident=368332):
ORA-00600: internal error code, arguments: [2619], [2945], [], [], [], [], [], [], [], [], [], []
Incident details in:

/oracle/diag/rdbms/apex/APEX/incident/incdir_368332/APEX_pr00_20444_i368332.trc
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE NODELAY DISCONNECT FROM SESSION
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors with log /Archive/APEX/APEX_1_2945_981753388.arc
MRP0: Background Media Recovery terminated with error 600
Wed Aug 15 13:55:32 2018
Errors in file /oracle/diag/rdbms/apex/APEX/trace/APEX_pr00_20444.trc:

Solution -
Cleared the space at DR site
Deleted the corrupted archive log /Archive/APEX/APEX_1_2945_981753388.arc
Re-copied it from Primary node to DR site

restarted the recovery -
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE NODELAY DISCONNECT FROM SESSION;

Verified the DR sync -


Reference- ORA-600[2619] During Physical Standby Recovery (Doc ID 1138913.1)

Steps to create/drop a private DB link - without user credentilas/ using proxy user

Steps to create/drop a private DB link - without user credentilas

Here, some how the DB link is not working, I have to recreate it to fix the issue, but I don't know user credentials.

I performed below steps

Granted the proxy user priveleges to another user.

alter user TEAM1 grant connect through PD1;

Grant succeeded.

SQL> conn PD1[TEAM1]
Enter password: PD1Password
Connected.
SQL> show user;
USER is "TEAM1"
SQL>  select name from v$database;

NAME
---------
M01

Drop database link DLNK;

CREATE DATABASE LINK DLNK CONNECT TO REPORT1 IDENTIFIED BY Password USING 'PR01';

SQL>  select name from v$database@DLNK;

NAME
---------
PR01

Revoked the privelege when DB link verified

alter user TEAM1 revoke  connect through PD1;

Reference - Using JDBC to Connect Through a Proxy User (Doc ID 227538.1)