Re: Oracle 7.3.2.2 - Login taking forever

The problem is due to a faulty tracing mechanism. Related bugs are (if I'm not mistaken) 443047,374964,387175.
Solution:
1) At the unix prompt: (If in ksh you can do it in one line) EPC_DISABLED=TRUE
export EPC_DISABLED
This will disable the tracing for you in the current session. 2) Add the above two lines to /etc/profile, so everyone will be exporting the above value of this variable.
This will disable the tracing for everyone that logs into the machine and then goes to sqlplus.
3) Add in the listener.ora file, in the SID__LIST_listener clause, just after the ORACLE_HOME=... line:
(ENVS='EPCS_DISABLED=TRUE')
This will ensure that the tracing will be disabled also for those coming in through SQL*NET, wirthout logging into the machine. 4) Remove from the directory $ORACLE_HOME/otrace/admin the files process.dat and regid.dat
(In fact you'll see that this files have grown to a significant size. It seems that any login to sqlplus reads these files and then adds an entry into them and that's why the problem gets worse over time.) 5) Run $ORACLE_HOME/bin/otrccref (this step is deemed very important by Oracle, and in fact if you skip it, every logon to sqlplus will result in a core dump!)

Finally, it's supposed to have been fixed in Oracle 8.0.4.3 and on.

I hope this helps,
Florin

Krister Lundmark wrote:

> 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 Sat Aug 14 1999 - 00:21:29 CDT