Re: SQL*Net Connection Problem ERROR: ORA-12545

You need the Oracle client installed on the machine (It probably is) and you need a good tnsnames.ora file. The one on the local machines (dialing in via RAS) is missing a tnsnames.ora entry (file in the ORACLE_HOME\network\admin for Oracle 7 or ORACLE_HOME\net8\admin for Oracle 8). To access Oracle the users do not have to be able to access the drives where Oracle resides (an a good idea if they could not.). Try copying a tnsnames.ora file from a machine that works to one that does not and see if that helps.
Jim
Srinivas wrote in message <366AA076.DF7BA64E_at_one.net>...
>Hi,
>We are trying to solve the
>following problem. I need help from u guys.
>
>Scenario:
>We have Oracle 7.3 running on Windows
>NT Server. NT is connected to the local
>network. Problem is all users who have
>access to the LAN and are able access
>WindowsNT machine
>are able to access Oracle without any problem.
>
>Some users login into LAN using modems (thru RAS connection).
>These users able to access Windows NT machine where
>Oracle 7.3 is running.
>These users could not connect to Oracle thru
>SQL*Plus. The error I got when tried was:
>ERROR: ORA-12545 TNS: Name lookup Failure.
>What is going on. And what
>should I do to resolve this problem.
>I appreciate any help in this
>problem solution. Thanks in advance.
>
>sincerely
>Srinivas
>
Received on Sun Dec 06 1998 - 00:00:00 CET