Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> PHP/Oracle home problem ?
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 578300jason_at_home:~$ uname -a
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 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
![]() |
![]() |