Re: Database link between Oracle7 and Oracle8

ruim_at_orfi.fr said...
> Yes, the bases TNSNAMES (in Oracle7 and Oracle8) are both all rigth.
> I have checked everything, and it looks ok... Global names are good in both
> definitions of databases.
> Maybe that's a general problem, but I just can't find a reference to that
> problem in the Internet... Even Oracle is not clear enough about that kind
> of thing.
>
> Thanx for your help.
>

You stated that your dblink from Oracle8 to Oracle7 works, but not from Oracle7 to Oracle8. Therefore, you know it's (probably) not a network problem.

A couple of questions remain:

1. Are the Oracle7 and Oracle8 db on different hosts? Same or different O/S? Maybe you could post the O8DESC entry in your Oracle7 tnsnames.ora and your entire Oracle7 sqlnet.ora.
2. Can you do a "tnsping o8desc" from your Oracle7 host? If yes, then the Oracle8 listener is receiving your request. If no, then you might want to turn on listener tracing in your Oracle8 listener.ora (trace_level_listener = USER | ADMIN | SUPPORT) and see if that helps. Maybe you could post the description_list portion of your Oracle8 listener.ora.

If none of this helps, then you can try setting the following two sqlnet.ora trace parameters to USER | ADMIN | SUPPORT: trace_level_client on the Oracle7 side and trace_level_server on the Oracle8 side. Actually, I can't remember if Oracle7 had this parameter. Look at the trace files, at a point just before the error occurs, and you should see an indication of what was happening just before the error. Understanding what it says can be a challenge, however.

-- 
/Karsten
DBA > retired > DBA