Re: SqlNet Connection from Oracle 8 to Oracle 7

Hi Rob:

On the ORACLE8 box, you will probably have two tnsnames.ora files: one in \network\admin and one in \net8\admin. It sounds like one of these has the connection information for the ORACLE7 instance, and the other does not. The ORACLE8 instance will attempt to connect to the ORACLE7 instance using NET8, so it sounds like the entry for the ORACLE7 instance is probably missing from the /NET8/ADMIN/tnsnames.ora.

Good luck,
Dave

Rob wrote in message <6ve2ct$41j$1_at_goof.de.uu.net>...
>Hi,
>I can not solve this simple Problem:
>
>I try to connect to my Oracle 7.3 Server from a Machine where
>Oracle 8.0x is running using ServerManger :
>
>connect username/password_at_tnsname
>I get the message
>
>ORA-12505 The listener could not resolve SID given in connect description.
>
>The sqlnet works in a different way.
>
>The tns entry seams correct because I can get the connection when I use
>the same connect string from an application ( Java)
>
>Can anybody help me
>TIA Rob
>
>
>
Received on Tue Oct 06 1998 - 19:36:08 CDT