Re: Random successful access with oci and PHP
From: joel garry <joel-garry_at_home.com>
Date: Tue, 27 Mar 2012 09:57:50 -0700 (PDT)
Message-ID: <e42d6342-a11a-4bfe-a02a-28de398735b5_at_ms3g2000pbb.googlegroups.com>
On Mar 27, 5:18 am, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> On Tue, 27 Mar 2012 02:39:18 -0700, steeve_dun wrote:
> > Warning: ocilogon() [function.ocilogon]: OCIEnvNlsCreate() failed.
>
> I haven't seen this in a long, long time. Let me guess: your database is
> version 10.2.0.x and your Apache2 is running on the same machine as the
> Oracle RDBMS? You need to run changePerm.sh. I am not sure of the exact
> name, I no longer have Oracle 10g on my box. It is in $ORACLE_HOME/install
> This will set up the needed file permissions so that the user "apache"
> can access $ORACLE_HOME/network, $ORACLE_HOME/lib, $ORACLE_HOME/nls and
> $ORACLE_HOME/mesg,
> Also, my advice would be not to use OCI, as it is ancient, but OCI8 which
> is much newer and much better maintained. You could also try with ADOdb,
> which is great.
>
> --http://mgogala.byethost5.com
Date: Tue, 27 Mar 2012 09:57:50 -0700 (PDT)
Message-ID: <e42d6342-a11a-4bfe-a02a-28de398735b5_at_ms3g2000pbb.googlegroups.com>
On Mar 27, 5:18 am, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> On Tue, 27 Mar 2012 02:39:18 -0700, steeve_dun wrote:
> > Warning: ocilogon() [function.ocilogon]: OCIEnvNlsCreate() failed.
>
> I haven't seen this in a long, long time. Let me guess: your database is
> version 10.2.0.x and your Apache2 is running on the same machine as the
> Oracle RDBMS? You need to run changePerm.sh. I am not sure of the exact
> name, I no longer have Oracle 10g on my box. It is in $ORACLE_HOME/install
> This will set up the needed file permissions so that the user "apache"
> can access $ORACLE_HOME/network, $ORACLE_HOME/lib, $ORACLE_HOME/nls and
> $ORACLE_HOME/mesg,
> Also, my advice would be not to use OCI, as it is ancient, but OCI8 which
> is much newer and much better maintained. You could also try with ADOdb,
> which is great.
>
> --http://mgogala.byethost5.com
That changePerm.sh issue had several iterations over 10g point versions (and variants on platforms), so the patch level is important too.
jg
-- _at_home.com is bogus. http://www.crn.com/news/components-peripherals/232700308/hp-seeks-pre-trial-court-ruling-in-itanium-suit-against-oracle.htmReceived on Tue Mar 27 2012 - 11:57:50 CDT