I believe one also needs to remove the *.dat files in the
$ORACLE_HOME/otrace directory (shutdown the listener first)
Florin David wrote in message <37B4FCD9.F4F6ADCB_at_earthlink.net>...
>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 Mon Aug 16 1999 - 01:48:21 CDT
