标题: ORA-600 [kpndbcon-svchpnotNULL] Raised by Query Through DBlink [打印本页] 作者: 刘泽宇 时间: 2024-5-26 13:10 标题: ORA-600 [kpndbcon-svchpnotNULL] Raised by Query Through DBlink 现象：
Executing a query over a database link, the alert log reports an error like below:
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
原因：
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.