net8 can't find tnsnames?

I am trying to make another connection from within sql*plus (8.0.4 on NT) session by typing

connect user_at_tnsalias

then it prompts me for password, I type it, then it gives me:

ERROR:
ORA-12203: TNS:unable to connect to destination

However, if I try

connect user/password_at_tnsalias

then it connects properly.

sqlnet.log that gets generated indicates that the unsuccessful connection attempt tries to connect to local database using bequeath, so apparently it is not looking at the connection information for tnsalias?

This behavior started happening ever since I installed 8.0.4 and Net8.

Does anybody know what the exact search order for connections in sql*plus v. 8.0.4? Imp80 and Exp80 work properly even if I leave password to be typed later at the prompt.

Thanks.
k& Received on Tue Feb 23 1999 - 19:01:11 CET