Re: OCI Initialize error

is he using Connection-pooling ?

Merci Beaucoups
Martin--
----- Original Message -----
From: <scoles@xxxxxxxxxxx>
To: "Bill Longaker" <BLongaker@xxxxxxxx>
Cc: <dbi-users@xxxxxxxx>
Sent: Saturday, February 09, 2008 10:27 AM
Subject: Re: OCI Initialize error


Looks like a stale connection or one that is timeing out. As this is a
cron job you might want to have it run less often. Nothing to do with
DBD:Oracle me thinks

I am getting this error periodically - usually the connection works.



Unable to connect: (UNKNOWN OCI STATUS 1804)

OCIInitialize. Check ORACLE_HOME env var,

Oracle NLS settings, permissions etc.

at /home/olptlab/dev/crons/rslinv.pl line 26.



ORACLE_HOME is set correctly.



Connect to ORAQCLE 10g thru a linux box Perl version v5.8.8 built for
i386-linux-thread-multi





Any help appreciated



Thanks



Bill







.