be aware of different directories for tnsnames.ora:
Oracle 7 $ORACLE_HOME\network\admin
Oracle 8 $ORACLE_HOME\net80\admin
There are also different versions of tools e.g. lsnrctl vs. lsnrctl80
so you have to choose the appropriate one for configuration.
"michael" <michael_Shi__at_hotmail.com> schrieb im Newsbeitrag
news:f17f6cba.0111191154.16c600b7_at_posting.google.com...
> I got connect problem like this
>
> Oracle7.3.4 for winnt (one machine) :
> as " connect scott/tiger" is ok ;
> as " connect scott/tiger_at_DB_Instance_ID" it gives TNS : could not resolve
> the service name ;
> as"connect scott/tiger_at_DB_Name ", after using SQL NET to add DB_Name into
> tnsnames.ora, it gives TNS: unable to connect to destination" .
>
> Oracle8 no such problem .
Received on Tue Nov 20 2001 - 05:30:23 CST
