Could you please clearify?
> Either make sure you use the name of your computer in the HOST=
> section
Where, in Oracle or ...?
> Or set up
> 127.0.0.1 localhost
> in %WINNT%\system32\drivers\etc\hosts
This comes as a default value when installing WinXP
> In both listener.ora and tnsnames.ora obviously
Do you mean defining localhost in these files?
- Pete
MCSE, SCJP, SCJD, SCWCD
"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message
news:s6e5509sev8o55n1kl1por69u146pcn1ue_at_4ax.com...
> 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
Received on Sat Mar 13 2004 - 02:26:10 CST
