ID: 35572
Updated by: tony2001@php.net
Reported By: lauris at nix dot lv
-Status: Open
+Status: Feedback
Bug Type: OCI8 related
Operating System: Mandriva Linux 2006
PHP Version: 5.1.1
New Comment:
Did you try it with PHP CLI ?
Previous Comments:
------------------------------------------------------------------------
[2005-12-06 18:02:42] lauris at nix dot lv
Just tried connecting to database when database name is in format
"//host:port/service_name" and now oci_connect returns false and also
oci_error returns false. Realy have no ideas what to do...
------------------------------------------------------------------------
[2005-12-06 17:47:22] lauris at nix dot lv
Did so and it did not help.
I have following enviroment variables set:
export ORACLE_SID=/opt/oracle/OraHome_1
export TNS_ADMIN=/opt/oracle/OraHome_1/network/admin
export ORACLE_OWNER=oracle
export ORACLE_HOME=/opt/oracle/OraHome_1
export PATH=$PATH:$ORACLE_HOME/bin/
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export NLS_LANG=LATVIAN_LATVIA.BLT8CP921
ls -la /opt/oracle/OraHome_1/network/admin/tnsnames.ora
-rw-r--r-- 1 oracle oracle 3207 Aug 25 19:23
/opt/oracle/OraHome_1/network/admin/tnsnames.ora
So tnsnames.ora is readable to all.
And still I'm getting the same error :(
What more info I can provide?
------------------------------------------------------------------------
[2005-12-06 17:35:50] tony2001@php.net
Remove the trailing slash, restart the web-server and try again.
------------------------------------------------------------------------
[2005-12-06 17:30:57] lauris at nix dot lv
phpinfo() returns:
...
oci8
OCI8 Support enabled
Revision $Revision: 1.269.2.3 $
Active Persistent Links 0
Active Links 0
Oracle Version no value
Compile-time ORACLE_HOME no value
Libraries Used no value
Temporary Lob support enabled
Collections support enabled
...
PHP Variables
Variable Value
_SERVER["ORACLE_HOME"] /opt/oracle/OraHome_1/
_SERVER["LD_LIBRARY_PATH"] /opt/oracle/OraHome_1/lib/
_SERVER["NLS_LANG"] LATVIAN_LATVIA.BLT8CP921
ORACLE_HOME is set to right direcotry. I'm stuck with this problem for
weeks and have no idea what to do :(
------------------------------------------------------------------------
[2005-12-06 17:25:58] tony2001@php.net
Most likely that means that you didn't set ORACLE_HOME or set it to a
wrong dir.
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/35572--
Edit this bug report at http://bugs.php.net/?id=35572&edit=1