OraFAQ Forum: Server Administration » dblink through difference oracle versions

Home » RDBMS Server » Server Administration » dblink through difference oracle versions

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

dblink through difference oracle versions [message #57189]

Tue, 27 May 2003 09:19

Daniele Rattellini
Messages: 38
Registered: August 2002

Member

Hi everybody,
I've two oracle instances

1) oracle 7.3.3.0.0 (sqlplus 3.3.3.0.0)
2) oracle 9.2.0.1.0

I created a database link from ora73 to ora92

> create public database link foo
connect to system identified by manager
using 'tns_entry';

If I try to execute the following query on ora73

> select * from dba_tablespaces@foo;

I get ORA-03113: end-of-file on communication channel

Furthermore, If I try to connect directly to ora92 through sql*plus (on ora73) I get this new error

ERROR: ORA-03106: fatal two-task communication protocol error

However, trying tnsping from ora73 to ora92 seems to work well.

I also tried to make the same thing using another oracle version (8.1.7) instead of 9.2.2, and everything works fine!

Maybe I should upgrade to newer version the database linker...

Any suggestion could be useful
Thanks

Daniele

Report message to a moderator

Re: dblink through difference oracle versions [message #57192 is a reply to message #57189]

Tue, 27 May 2003 15:55

Maaher
Messages: 7065
Registered: December 2001

Senior Member

BTW: You *do* know that the latest version of Oracle 7 is version 7.3.4.5.1 (if I'm not mistaken), right? Because, you might as well hitting a bug. If not, check the listener version. Perhaps a V7 listener has problems with Oracle 9i?

I'd suggest you check out Metalink, Oracle's support site, to find out more specific info. One thing I came across was that the ORA-03113 was most often accompanied by a ORA-07445 in the trace file. If so, it would be useful to post the details too.

Report message to a moderator

Re: dblink through difference oracle versions [message #57195 is a reply to message #57192]

Wed, 28 May 2003 02:47

Daniele Rattellini
Messages: 38
Registered: August 2002

Member

Thanks for your help Maaher.
Unfortunately, no error log line has been written in the trace file, neither in the alert.log.

Why did you talk about V7 listener? I'm just trying to db linking from ora73 to ora93 using V92 listener.

Maybe, I did not understand what you ment.
Could you shred some light on this?

Thanks regards

Daniele

Report message to a moderator

Re: dblink through difference oracle versions [message #57252 is a reply to message #57195]

Fri, 30 May 2003 16:51

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Well, it was just a long shot. I was merely repeating some very common symptoms I came across. Sorry, but I can't help you any further. I'm far from a DBA and I really suggest you launch an ITar at Metalink (see previous reply). One thing that I'm pretty sure of is that Oracle 7.3.3 isn't supported anymore. Perhaps 7.3.4 is, but I wouldn't bet on it...

Perhaps there are some DBAs around that might help you out.

MHE

Report message to a moderator

Re: dblink through difference oracle versions [message #57293 is a reply to message #57252]

Tue, 03 June 2003 01:12

Daniele Rattellini
Messages: 38
Registered: August 2002

Member

Thanks anyway

daniele

Report message to a moderator

Previous Topic:	Oracle 9i
Next Topic:	forcing hash join

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 11:25:22 CDT 2024