使用DBLINK查询时报ORA-00600: internal error code, arguments: [kzdlk_zt2 err]
SYS@oradg11g > select INSTANCE_NAME,host_name from v$database@DBLINK_tns_oradgphy_LHR;
select INSTANCE_NAME,host_name from v$database@DBLINK_tns_oradgphy_LHR
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kzdlk_zt2 err],
[18446744073709551603], [], [], [], [], [], [], [], [], [], []
SYS@oradg11g >
点击(此处)折叠或打开
- create public database link dblink_ogg1
- connect to lhr identified by lhr
- using '(DESCRIPTION =
- (ADDRESS_LIST =
- (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.59.129)(PORT = 1521))
- )
- (CONNECT_DATA =
- (SERVICE_NAME = ogg1)
- )
- )';
-
-
- create public database link DBLINK_OGG1
- connect to LHR identified by lhr
- using 'OGG1';
-
-
- SELECT NB.PASSWORD FROM sys.USER$ NB WHERE NB.NAME = 'SYS';
-
- --ORA-00600: internal error code, arguments: [kzdlk_zt2 err],
- create public database link DBLINK_OGG1
- connect to LHR identified by values '72979A94BAD2AF80'
- using 'OGG1';
-
-
- CREATE DATABASE LINK DBLINK_OGG1
- CONNECT TO CURRENT_USER
- USING 'remote';
-
-
-
- CREATE DATABASE LINK DBLINK_OGG1
- USING 'remote'
在测试重建DBLINK,因为不知道帐号的密码,所以使用了IDENTIFIED BY VALUES进行创建:
SQL> CREATE PUBLIC DATABASE LINK WEBDB CONNECT TO WEBAPP identified by values '3960A527B983671C' using 'CSS';
Database link created.
创建过程一切OK,但是在使用时问题就来了:
SQL> select sysdate from dual@WEBDB;
select sysdate from dual@WEBDB
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kzdlk_zt2 err], [18446744073709551603], [], [], [], [], [], [], [], [], [], []