Re: Database link between Oracle7 and Oracle8

Well, first of all, thanx for your help, you guys. I guess the answer to my problem is a kind of a joke... Here's the thing :
The databases are defined on two different servers (both are NT servers). The fact was that, in the server wich contains the Oracle7 database, the Oracle8 database was'nt defined in the server TNSNAMES.ORA file !!! I know, it's a kind a dum...
I thought that the problem was in the client TNSNAMES file...

Thanx again,
See ya ! :)

Rui.

"Karsten Farrell" <kfarrell_at_belgariad.com> a écrit dans le message news: MPG.18ecdca3e76253d4989710_at_news.la.sbcglobal.net...
> 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
Received on Fri Mar 28 2003 - 05:05:05 CST