Oracle Database Discussions

Hi All,

I am trying to connect to remote Database by using DB Link facing the below error.

ora-02068 following severe error & ora-03113 end of communication channel.

Version of Database - 8.0.6 ( source Database)

Target Database version - 11g ( Target Database)

Oracle Client s/w used - 9i

TNSPING from 8 version database to 11g is successful

C:\Documents and Settings\user>tnsping prdd

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 30-MAY-20
13 10:40:02

Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
D:\oracle9i\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(host =xx.xxx.xxx.xx) (Port = 1631))) (CONNECT_DATA =(SID = PRDD)))
OK (30 msec)


Connection successful from 8 to 11 Database remotely

C:\Documents and Settings\user>sqlplus

SQL*Plus: Release 9.2.0.1.0 - Production on Thu May 30 10:43:00 2013

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter user-name:username/pwd@prdd

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Automatic Storage Management, Oracle Label Security, OLAP

Data Mining, Oracle Database Vault and Real Application Testing options

SQL>


Connected to:
Oracle8 Enterprise Edition Release 8.0.6.0.0 - Production
With the Partitioning and Objects options
PL/SQL Release 8.0.6.0.0 - Production

SQL> select * from dual@xxx_dblink.world;
select * from dual@xxx_dblink.world
*
ERROR at line 1:
ORA-02068: following severe error from xxx_dblink
ORA-03113: end-of-file on communication channel


DBLink got created successfully but when ever trying to test the DBlink as above facing the below issue,please help.


Thanks in advance.