ORA-00600: internal error code, arguments: [ORA-00600: internal error code, arguments: [4400], [560]

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

GOAL

When running a remote PL/SQL procedure through dblink the following error is raised:

ORA-00600: internal error code, arguments: [ORA-00600: internal error code, arguments: [4400], [560], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], [], [], [], [], []
], [], [], [], [], [], [], [], [], [], [], []
ORA-02063: preceding line from <DBLINK>

 The stack trace is:

npierr <- kpnerr <- kpnpst <- upirtrc <- upirtr <- upilof <- kputac <- ncodncf <- npidsc
  <- npiane0 <- npicon0 <- psdrpc <- prirpc <- pevm_RCAL <- pfrinstr_RCAL <- pfrrun <- plsql_run
   <- peicnt <- kkxexe <- opiexe <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv

 

The source database has REMOTE_DEPENDENCIES_MODE=SIGNATURE.

The target database has REMOTE_DEPENDENCIES_MODE=TIMESTAMP.

SOLUTION

1. Increase OPEN_LINKS from 4 to 10 on source and target databases
2. Change REMOTE_DEPENDENCIES_MODE to SIGNATURE on target database, source database already set to SIGNATURE.

REFERENCES

NOTE:234579.1 - Transactions Fail When Connecting Through a DBLink With ORA-2046 & ORA-2063 Errors And Remote ORA-600 [4400]
BUG:19269405 - ORA-2019 ON DBLINK REFERENCE TO REMOTE FUNCTION WHEN IT IS MODIFIED