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