Try putting the IP-number in tnsnames.ora instead of the hostname
(the problem is probably related to a slow DNS).
/Krister Lundmark
Paul da Cruz <pauldc_at_iscorvdb.co.za> wrote in message
news:3795928A.14A0F8C4_at_iscorvdb.co.za...
> Hi, I am running Oracle 8.05 on NT4 for almost a year with no problem.
> Over the last 2 weeks I have noticed exactly the same symptoms as yours.
> Connection times with various tools average 90 to 120 seconds. Initially
> it was around 5 minutes, and I reinstalled all network components,
> resulting in the current scenario. I would also appreciate any ideas.
> Paul da Cruz
>
> Susan Halligan wrote:
> >
> > We are running an Oracle 7.3.2.2 on Solaris 2.6 It has been up and
> > running for almost a year with no problems. We have noticed in the
> > past month or so that when we login using SQL*Plus 2.3.2.2.0 that it
> > is taking up to 90 seconds to get to the SQL prompt. Any ideas? We
> > are not running auditing, redo logs are ok, temp TS is ok. Once
> > logged in performance is fine.
> >
> > Thanks,
> > Susan
Received on Fri Aug 13 1999 - 21:17:29 CDT
