Re: SQLPlus in local PC having DSL internet connection

On Fri, 12 Mar 2004 22:15:49 +0200, "Pete" <jik_at_jaja@com> wrote:

>Hello,
>
>Can anyone please tell me what "switch" should I put and were in
>configuration files that SQLPlus would work locally in my PC?
>
>Situation is following: I have a WinXP PC that is connected to Interned via
>DSL-modem. When I start using SQLPlus and try to log in into it, SQLPlus
>gives TNS listener not found errors. If I disconnect my PC from Internet
>(disconnecting DSL) SQLPlus runs in my PC locally like I want it to run.
>
>So, where to give that configuration information that tells SQLPlus that I'm
>running it and Oracle DB locally?
>
>Thanks,
>

Either make sure you use the name of your computer in the HOST= section
Or set up
127.0.0.1 localhost
in %WINNT%\system32\drivers\etc\hosts

and use localhost as host name

In both listener.ora and tnsnames.ora obviously

--
Sybrand Bakker, Senior Oracle DBA