RE: Connect failure: OCIEnvNlsCreate (check ORACLE_HOME and NLSsettings etc.)

Victor,

Yes, this all makes sense - specifically your find for setting =
LD_LIBRARY_PATH. That sentence triggered a recollection for me. This =
was the issue I was refering to a few months ago.

As for how to set these vars for the httpd process owner, I think you =
will need to do this in a .conf file somewhere, but, I am not sure, =
since I am not a web developer.

-----------------
Ron Reidy
Lead DBA
Array BioPharma, Inc.


-----Original Message-----
From: Victor Churchill [mailto:victor@qonnectis.com]
Sent: Thursday, August 25, 2005 11:07 AM
To: Reidy, Ron
Cc: dbi-users@perl.org
Subject: RE: Connect failure: OCIEnvNlsCreate (check ORACLE_HOME and
NLSsettings etc.)


Hi Ron,
Thanks for the reply. I've done another search of the group but not
found anything specifically permissions-related. I assume you mean the
permissions of the owner of the httpd processes (on this box, 'nobody')
...?=20

I did pick up a suggestion that the %ENV settings might need to be done
at startup of the web server rather than at the time the script runs,
and have tried sourcing a file to set up the apache environment, but the
shell envt does not seem to find its way into the Perl ENV hash - at
least, not that I can see.

I've also tracked down, by manually setting/unsetting envt variables,
that the test-script from the command line depends specifically on
having LD_LIBRARY_PATH in the environment of the shell process : i.e.,
the owning shell needs to have this set _even though_ the perl script
explicitly sets=20
$ENV{'LD_LIBRARY_PATH'} =3D =
'/usr/local/OraClient/instantclient_10_2/lib';

- i.e., the same test scipt runs at the cmd line if the user has that
set but not if he does not.

So it looks like the question now becomes "How to set an environment
variable for the owner of the httpd process?" Does that make sense?

thanks,

victor

On Thu, 2005-08-25 at 15:57, Reidy, Ron wrote:
> Victor,
>=20
> I believe this is a permissions issue. There was a posting to this =
group a few months ago that was very similar in nature. Look around the =
archives for it.
>=20
> -----------------
> Ron Reidy
> Lead DBA
> Array BioPharma, Inc.
>=20
>=20

--=20
Victor Churchill
Qonnectis Group plc


This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
or use of the contents of this information is prohibited. Please notify =
the
sender of the delivery error by replying to this message, or notify us =
by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: Connect failure: OCIEnvNlsCreate (check ORACLE_HOME and

On Thu, 2005-08-25 at 18:15, Reidy, Ron wrote:
> Victor,
>
> Yes, this all makes sense - specifically your find for setting LD_LIBRARY_PATH. That sentence triggered a recollection for me. This was the issue I was refering to a few months ago.
>
> As for how to set these vars for the httpd process owner, I think you will need to do this in a .conf file somewhere, but, I am not sure, since I am not a web developer.

Cracked it.

in httpd.conf:

SetEnv LD_LIBRARY_PATH /usr/local/OraClient/instantclient_10_2/lib
SetEnv ORACLE_HOME /usr/local/OraClient/instantclient_10_2

Yay!

thanks,

victor

--
Victor Churchill
Qonnectis Group plc