Re: PHP/Oracle home problem ?

From: Michael O'Shea <michael.oshea_at_tessella.com>
Date: Sun, 09 Sep 2007 02:49:33 -0700
Message-ID: <1189331373.739116.86270@g4g2000hsf.googlegroups.com>

On Aug 30, 4:51 pm, Jason Cartledge <jcartledge9..._at_hotmail.co.uk> wrote:
> Hello all, I have what I thought was a PHP problem but I think it is
> an Oracle setup and configuration problem with PHP. I know this is an
> Oracle group but I have had no luck in the PHP groups and Mladen
> Gogala is Oracle and PHP so I am trying to get help posting here. I
> have read the charter and if I am violating it I apologize in
> advance.
>
> Here is my configuration
>
> jason_at_home:~$
> jason_at_home:~$ free
> total used free shared buffers
> cached
> Mem: 3075856 866608 2209248 0 12532
> 668632
> -/+ buffers/cache: 185444 2890412
> Swap: 578300 0 578300
> jason_at_home:~$ uname -a
> Linux home 2.6.20-16-generic #2 SMP Thu Jun 7 20:19:32 UTC 2007 i686
> GNU/Linux
> jason_at_home:~$ php --version
> PHP 5.2.1 (cli) (built: Jul 17 2007 18:14:23)
> Copyright (c) 1997-2007 The PHP Group
> Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies
> jason_at_home:~$
> jason_at_home:/var/www$ php testoci.php
>
> Logon OK
>
> jason_at_home:/var/www$
> jason_at_home:/var/www$
> jason_at_home:/var/www$ cat testoci.php
> <?php
> require_once('DB.php');
> # $db=DB::connect("oci8://scott:tiger_at_orcl");
> $db=OCILogon("scott","tiger","orcl");
> if (!DB::iserror($db))
> {
> echo "\r\nLogon OK\n";
> }
> else
> {
> echo "\r\nLogon NOT OK\r\n";
> #echo $db->getDebugInfo();
> }
> ?>
>
> jason_at_home:/var/www$
> jason_at_home:/var/www$ sqlplus scott/tiger_at_orcl
>
> SQL*Plus: Release 11.1.0.6.0 - Production on Thu Aug 30 16:22:42 2007
>
> Copyright (c) 1982, 2007, Oracle. All rights reserved.
>
> Connected to:
> Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
> With the Partitioning, OLAP, Data Mining and Real Application Testing
> options
>
> SQL>
>
> When I execute testoci.php from the command line like I show above, I
> see "Logon OK" like I show above.
> When I execute this program fromhttp://localhost/testoci.phpI see
>
> Warning: ocilogon() [function.ocilogon]: OCIEnvNlsCreate() failed.
> There is something wrong with your system - please check that
> ORACLE_HOME is set and points to the right directory in /var/www/
> testoci.php on line 4
> Logon OK
>
> I don't understand it. In my Apache startup script, I have added echo
> $ORACLE_HOME >/1.lst. When I reboot the computer, and examine this
> file, it shows /oracle/test11g which is my Oracle home.
>
> In a separate thread last year (http://www.thescripts.com/forum/
> thread454404.html), Mladen suggests (for Oracle 10.2) trying "chmod -R
> o+rx $ORACLE_HOME" but this doesn't work either. I am using 11g.
>
> If anyone can suggest what else to test, I would be most greatful.
>
> Thank you
> Jason
>
> Just one more thing, please post to the sig. This is just a junk e-
> mail account so I can avoid getting spammed on my real one.

Hi Jason. When I encounter problems like this, the first thing I do is read the warning or error message.

> Warning: ocilogon() [function.ocilogon]: OCIEnvNlsCreate()
> failed. There is something wrong with your system - please
> check that ORACLE_HOME is set and points to the right directory in
> /var/www/testoci.php on line 4

Add

echo "ORACLE_HOME=".getenv("ORACLE_HOME");

to your PHP script report what you see in the browser. If you don't see "ORACLE_HOME=your oracle home" then you have your answer.

Regards
Mike

TESSELLA Michael.OShea_at_tessella.com

__/__/__/ Tessella Support Services plc
__/__/__/ 3 Vineyard Chambers, ABINGDON, OX14 3PX, England
__/__/__/ Tel: (44)(0)1235-555511 Fax: (44)(0)1235-553301

www.tessella.com Registered in England No. 1466429 Received on Sun Sep 09 2007 - 04:49:33 CDT