Hello,
I having this problem of long or hanging situation
when try to do DBI->connect(...) with the Oracle
database server (the server is 7.x). From the
README.help file, I notice the following:
-------------------------------------------------------------------------------
Connection/Login slow. Takes a long time and may
coredump
Oracle bug number: 227321 related to changing the
environment before
connecting to oracle. Reported to be fixed in 7.1.6
(or by patch 353611).
To work around this bug, do not set any environment
variables in your
oraperl script before you call ora_login, and when you
do call
ora_login, the first argument must be the empty
string. This means
that you have to be sure that your environment
variables ORACLE_SID
and ORACLE_HOME are set properly before you execute
any oraperl
script. It is probably also possible to pass the SID
to ora_login as
part of the username (for example, ora_login("",
"SCOTT/TIGER@PROD",
"")), although I have not tested this.
This workaround is based on information from Kevin
Stock.
Also check $ORACLE_HOME/otrace/admin. If it contains
big *.dat files
then you may have otrace enabled. Try setting
EPC_DISABLED=TRUE
in the environment of the database and listener before
they're started.
Oracle 7.3.2.2.0 sets this to FALSE by default, which
turns on tracing
of all SQL statements, and will cause very slow
connects once that
trace file gets big. You can also add
(ENVS='EPC_DISABLED=TRUE') to
the SID_DESC part of listener.ora entries. (With
thanks to Johan
Verbrugghen [EMAIL PROTECTED])
-------------------------------------------------------------------------------
Now the situation is: I have two database. 1 is 8.x
and another is 7.x. Both need to be connected from a
client machine (The client is using oracle9ias). These
three machines are physically different machine.
No problem when connecting to 8.x, but problem of
long/halt DBI->connect(...) occur when connecting to
7.x
After reading the README.help, I suspect is the same
problem that I am facing. The question here is, the
ENVs, are thet set at the client machine or the
machine that host 7.x?
I tried with setting it at the client machine. It does
not work.
This is how I set the ENVs at the client machine:
%> export ORACLE_HOME=</path/to/oracle/home>
%> export ORACLE_SID=<SID>
%> export EPC_DISABLE=TRUE
Anyone has any idea?
__________________________________________________
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest free email!
http://mail.yahoo.com/
