9i database link to 8i bug? 1

[JediDan]

Hello all,

I am writing a stored procedure in Oracle 9i which contains a database link to an 8i db. The procedure compiles fine without the link, but as soon as I add the link in, whatever program I'm using to compile the procedure (I've tried both SQL*Plus and SQL Navigator) crashes, i.e. becomes totally unresponsive.

Any ideas?

We're running Oracle 9i 9.2.0.2 (parent), and 8.1.6 (db link target).

Thanks

 

[vivekm]

Please give the error message from your alert log file or trace files.

It seems strange that the procedure compiles without any errors without the database link. Have you got the same tables/objects that you are referring to in your stored procedure in the Oracle9i database?

Regards,
Vivek

 

[beneazv]

Hello

I have nearly the same problem using 9i (9.2.0.3) dblink to 8i (8.1.7.4) over WAN.

I haven´t solved it yet and it seemed to be a problem only between 9i and 8i over an slowly connection ( 2mbit ). The rpc from 9i to 8i over dblink and 100mbit working fine. The strange thing is it works with 9i and 9i over WAN.
If anyone knows a solution - please let me know.
The error message tells something about:
04052 Couldn´t find object...

Regards
bene

 

[tallbloke]

I think you may need to patch up to 8.1.7.4.11. We had a similar problem selecting fields over dblink from 8.1.5. to 9.2.0.

 

[aggieangler]

Hi,

I found that there is a syntax difference in creating a DBLInk from a 9i to 9i vs a db link between 9i and 8.

Hopefully this helps....

To connect from Oracle 9i to Oracle 8i, use the following:

CREATE DATABASE LINK "8TO9"
CONNECT TO "schemaname" IDENTIFIED BY "password"
USING '(description=(address=(protocol=TCP)
(host=IP ADDRESS or NAME)(port=1521))(connect_data=(sid=orcl)))';



for an oracle9 to oracle9 the following will also work:

CREATE DATABASE LINK "9TO9"
CONNECT TO "schemaname" IDENTIFIED BY "password"
USING 'IP ADDRESS or NAME';

make sure that name is in your TNS NAMES file if you are using the name inseatd of the IP.

I bet this solves the object not found error message....

As far as the performance goes, I have not seen an issue on our 100Mb network, but am starting to see one on a client network that is using a mainframe for the Oracle8 piece.

HTH,

Aggieangler