ID: 10206
User Update by: [EMAIL PROTECTED]
Old-Status: Feedback
Status: Open
Bug Type: OCI8 related
Description: PHP in CGI mode fails to perform OCILogon

php manual suggests to set such enviroment variables:
ORACLE_HOME - seems to be path to a directory where an ORACLE product is. Am I right ?
I've tried to set it as 
and then run php
C:\php4\php.exe c:\InetPub\wwwroot\test.php4
and I've got the same TNS-12154 error :-(
Could you possibly tell, what's is going wrong ?
P.S. I don't have any problems with php3 and Oracle on the same machine.
ORACLE_SID - seems to be SID identifier, TNSNAMES.ORA already has got SID defined for 
my TNS alias.
LD_PRELOAD - this variable seems to has meaning only for U*NIX systems
LD_LIBRARY_PATH - this variable seems to has meaning only for U*NIX systems
I can't guess what above two variables should contain on Win32 system. Could you 
possibly enlight me in this issue?
NLS_LANG,ORA_NLS33 - these variables seem to contain NLS settings, so windows registry 
has it

Previous Comments:

[2001-04-06 11:14:10] [EMAIL PROTECTED]
Just wondering if you have all the necessary environment
variables set? Check the manual page



[2001-04-06 08:47:51] [EMAIL PROTECTED]
When I use php in CGI mode any script can't connect to the Oracle DB throught the 
OCILogon call.
When I switch to the ISAPI mode these scripts work OK.
the sample script:
 if (! $dbconn=OCILogon($dbuser,$dbpass,$dbhost)) 
      print("Cannot connect to oracle db '$dbhost' as user '$dbuser'");
oracle reports:
ORA-12154: TNS:could not resolve service name in C:InetPubwwwroottest.php4 on line 5


Full Bug description available at:

PHP Development Mailing List <>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to