oracle9.0.1通过数据库链访问oracle7.3.4报600错误

[复制链接]
查看11 | 回复2 | 2009-2-23 21:48:25 | 显示全部楼层 |阅读模式
甲端:
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
PL/SQL Release 9.0.1.1.1 - Production
CORE9.0.1.1.1 Production
TNS for 32-bit Windows: Version 9.0.1.1.0 - Production
NLSRTL Version 9.0.1.1.1 - Production
SQL>
乙端:
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle7 Server Release 7.3.4.0.0 with the 64-bit option - Produc
PL/SQL Release 2.3.4.0.0 - Production
CORE Version 3.5.4.0.0 - Production
TNS for DEC OSF/1 AXP: Version 2.3.4.0.0 - Production
NLSRTL Version 3.2.4.0.0 - Production
SQL>
用户是 "LINKUSER"
SQL> select * from abcde;
没有查到记录
=======================================
两端的listener.ora和tnsnames.ora均配置好
可以创建同义词.
SQL> conn manager/manager@gjgh
连接成功.
SQL> create database link test
2connect to linkuser identified by linkuser using 'orayy1';
数据库连接已建立.
SQL> desc abcde@test
错误:
ORA-00600: 内部错误代码,参数: [2252], [2077], [576848773], [], [], [], [], []
请问,是不是BUG?
回复

使用道具 举报

千问 | 2009-2-23 21:48:25 | 显示全部楼层
不兼容,
回复

使用道具 举报

千问 | 2009-2-23 21:48:25 | 显示全部楼层
是不兼容,
但是我以前使用oracle 9.0.1(UNIX)和ORACLE 7.3.4可以进行数据库链访问
只是访问时 不可直接建立同义词
而是要建立视图(也可再建同义词)
经查metalink发现其他版本,发生此错误时
fact: Oracle Server - Enterprise Edition 8.1
symptom: Query that uses a database link between two machines fails
symptom: ORA-02068: following severe error from %s%s
symptom: ORA-00600: internal error code, arguments: [2252]
symptom: Able to create database link on each machine
symptom: System date differs between the two machines
cause: Argument [2252] for the ORA-00600 indicates that the System Change
Number (SCN) Oracle is calculating for a transaction is an unreasonable number.
The SCN is calculated based in part on the host system date.If the system
date is a LONG way off, the maximum possible value calculated for the SCN may
be impossibly large which would result in an ORA-600[2252].
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行