Re: Why connection to the database takes > than 10 minutes

Before doing any of this, I'd get the proper procedure from oracles web site. Search for EPC_DISABLED.

Check process.dat, regid.dat, and collect.dat under $ORACLE_HOME/otrace/admin.

If they are large ( and large here isn't very large ), remove them. Then set EPC_DISABLED=TRUE for everyone's environment. This will disable some internal RDMS tracing functionality that has gone astray.

This was bug(387185) in 7.3.x.x. I'm not sure if 7.3.4 has the same problem, but this smells suspiciously so.

-Kevin

--

remove the x for an email reply
drona_at_my-dejanews.com wrote in message <712k36$8rp$1_at_nnrp1.dejanews.com>...
>The following is a brief explanation of the database connection problem I
am
>experiencing.
>The databases are functioning normally!!!!!!!!!!!!!!. Yes there is no
error
>message written to the log file.
>
>When the problem occurred few days back we assumed it is of resource
problem.
>Every GUI connection was taking 30% of the CPU and we have 2 CPU on server.
>Then I opened a tar with Oracle Support thinking it may be of corrupted
>system table problem. Oracle Support thinks it is resource problem . Any
how
>I havn't closed the tar with Oracle yet.
>
> If a user gets the connection to the database he/she will not have any
>problem executing any statements on database. Looks like even when we have
>20% of CPU is free the connection to the database takes approximately 10
>minutes. Whe load on Servr is absolutely low then I have no problem
>connecting to the databases.Can it be any of the UNIX resource( any
parameter
>settings not being set properly) being not available at that instant to
the
>user trying to get connected? By the way I am running on HP-UX 10.20 with
>7.3.4.2.0 oracle database. We have two instances one being run in Archive
>mode.
>
>Any clues and suggestions are welcome.
>Drona
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Oct 26 1998 - 15:08:21 CST