RE: Connect failure: OCIEnvNlsCreate (check ORACLE_HOME and NLS settings 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')
...?

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
$ENV{'LD_LIBRARY_PATH'} = '/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,
>
> 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.
>
> -----------------
> Ron Reidy
> Lead DBA
> Array BioPharma, Inc.
>
>

--
Victor Churchill <victor@xxxxxxxxxxxxx>
Qonnectis Group plc

.

Relevant Pages

  • Re: File and Print Sharing Problems
    ... > Thanks Ron! ... > That fix did get rid of the not enough server storage available error ... That means all sharing operates via the guest account, ... or with the share or NTFS permissions. ...
    (microsoft.public.windowsxp.network_web)
  • Error 1307: Adding File Permissions to NTFS using System.Management Object in ASP.NET
    ... with adding File Permissions to a directory. ... I am developing with Framework 1.1 and Windows XP. ... Shell Name Explorer.exe in Registry not found in process ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Sharing complete HD?
    ... The shell is often easier than a GUI once you know what you're doing. ... The following assumes that you are NOT logged on as root. ... There is a "Permissions" tab on the properties dialog that will allow you ... The equivalent of the "chmod a+rwx" ...
    (uk.comp.os.linux)
  • Re: Sharing complete HD?
    ... The shell is often easier than a GUI once you know what you're doing. ... The following assumes that you are NOT logged on as root. ... There is a "Permissions" tab on the properties dialog that will allow you ... The equivalent of the "chmod a+rwx" ...
    (uk.comp.os.linux)
  • file permission when harddisk connected to another computer
    ... is there a way that my file permissions are kept ... harddisk offline, from being browsed or write on it? ... runs a certain program, that can't be run without the shell program, ... changes in my folders. ...
    (microsoft.public.windowsxp.hardware)