PHP/Oracle home problem ?

From: Jason Cartledge <jcartledge9054_at_hotmail.co.uk>
Date: Thu, 30 Aug 2007 08:51:40 -0700
Message-ID: <1188489100.103809.42550@d55g2000hsg.googlegroups.com>

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

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 from http://localhost/testoci.php I 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 email account so I can avoid getting spammed on my real one. Received on Thu Aug 30 2007 - 10:51:40 CDT