使用DBLINK查询时报ORA-00600: internal error code, arguments: [kzdlk_zt2 err]
来源:互联网 发布:火焰之地怎么去乎门人 编辑:程序博客网 时间:2024/06/08 21:42
在测试重建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], [], [], [], [], [], [], [], [], [], []
报了个600的错误。Metalink的文章Doc ID 1309705.1,解释了这一错误:
导致这个错误的原因就是在创建DBLINK时使用了IDENTIFIED BY VALUES这中形式。改成正常的IDENTIFIED BY该问题就解决了(Oracle也是有点坑的,既然会报错,那就不要创建成功啊。能让你创建却不让你使用。。。)。
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], [], [], [], [], [], [], [], [], [], []
报了个600的错误。Metalink的文章Doc ID 1309705.1,解释了这一错误:
导致这个错误的原因就是在创建DBLINK时使用了IDENTIFIED BY VALUES这中形式。改成正常的IDENTIFIED BY该问题就解决了(Oracle也是有点坑的,既然会报错,那就不要创建成功啊。能让你创建却不让你使用。。。)。
0 0
- 使用DBLINK查询时报ORA-00600: internal error code, arguments: [kzdlk_zt2 err]
- ORA-00600 [kzdlk_zt2 err]
- ORA-00600 internal error code, arguments
- ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], []
- ORA-00600: internal error code, arguments: [ksuinfos_modact1], [], [], [], [], [], [], []
- ora-00600 internal error code arguments: [kcratrl_lastbwr],[],[],[],[],[],[],[]
- ORA-00600: internal error code, arguments: [19004]
- ORA-00600 internal error code,arguments
- ORA-00600: internal error code, arguments: [1265]
- ORA-00600: internal error code, arguments: [17182]
- ORA-00600: internal error code, arguments: [keltnf
- ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []
- ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [], [], [], []
- ORA-00600 internal error code,arguments: 问题
- ORA-00600: internal error code, arguments: [kdsgrp1]
- ORA-00600 internal error code,arguments
- ORA-00600: internal error code, arguments: [ktrgcm_3]
- ORA-00600: internal error code, arguments: [ktprhtnew6], [], [], [], [], [], [], []
- Leetcode173: Add and Search Word - Data structure design
- 资源文件包 Bundle
- 开发工具准备
- Windows 系统错代码
- linux驱动程序调试常用方法
- 使用DBLINK查询时报ORA-00600: internal error code, arguments: [kzdlk_zt2 err]
- 集合和泛型知识记录
- Android之Intent 简介
- 用 startActivityForResult 方法启动 Activity 的简单使用
- [Struts]Struts2 - 常用的constant总结
- c++操作符重载操作
- android ratingbar 星星间距问题,自定义ratingBar
- 第 15 章 设备无关位图
- MySQLConnector/C++连接方式一