ORA-600 [kpndbcon-svchpnotNULL] Raised by Query Through DBlink

刘泽宇

现象：
Executing a query over a database link, the alert log reports an error like below:

Errors in file /oracle/app/diag/rdbms/<instance>/trace/<instance>_ora_4490.trc (incident=19372):
ORA-00600: internal error code, arguments: [kpndbcon-svchpnotNULL], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /oracle/app/diag/rdbms/<instance>/incident/incdir_19372/<instance>_ora_4490_i19372.trc

The trace file with the ORA-600 shows characteristics like:

----- Current SQL Statement for this session (sql_id=gfgws4ccmvuvb) -----
select customer_id,cust_first_name,cust_email from customers@dblink
where customer_id < 100 order by customer_id

----- Call Stack Trace -----

... kpnconn npicon0 kpndbcon OCIKDBLinkConn2 OCIKDBLinkConn ddfnet2Normal kkmfcbrm kkmpfcbk qcsprfro qcsprfro_tree ...

原因：
The ORA-600 [kpndbcon-svchpnotNULL] is related to the failure from the connection to the remote server and is addressed in documents such as Doc ID 1610510.1

This is a SqlNet problem.

Also please check your alert log and network logs (listener.log & sqlnet.log) for any errors around the time of the ORA-00600 [kpndbcon-svchpnotNULL] error. Specifically the following network errors are known to cause the ORA-00600 [kpndbcon-svchpnotNULL] error to occur:

TNS-12535: TNS:operation timed out
TNS-12541: TNS:no listener

Resolve the underlying network errors, and ensure that the listeners are always up and available.

处理方法：
To solve the issue, use any of below alternatives:

Upgrade to 12.1.0.1 or higher

- OR -

Apply patch set 11.2.0.2 or higher

- OR -

Apply interim patch 9583138, if available for your platform and Oracle version.

To check for conflicting patches, please use the MOS Patch Planner Tool

Please refer to
Note 1317012.1 - How To Use MOS Patch Planner To Check And Request The Conflict Patches?

If the issue still reproduces, please investigate the connection errors/underlying errors, if any, between these databases, while using the DBlink, e.g. any recent changes at the network level, like dynamically changing the tnsentries, etc.