ocilogon(): _oci_open_server: Error while trying to retrieve text for error ORA-12538

najm25

Hi All,

I am getting the following error:
ocilogon(): _oci_open_server: Error while trying to retrieve text for error ORA-12538

My environment is:
OS: Windows 2000
DB: Oracle 9.2
using php 4.3.10

database Server and IIS or on the same machine. I have done manual installation of php and it looks correct to me.

my question is do i need to setup 'ORACLE_HOME and TNS_ADMIN vars in windows as well..........
if I do need to do so what are the my best options.
Thanks.
Najm

LordShryku

Yes, you need ORACLE_HOME and ORACLE_SID. You should be able to get away with setting them using [man]putenv[/man].

<?php
putenv('ORACLE_HOME=C:\\ora8\\product\\8.1.7');
putenv('ORACLE_SID=ora8i');

/* rest of script */

See if doing that helps...

najm25

Thank you very much for your reply. However it did not help me.
here is snips of code that i am using to connect:
echo "<pre>";
putenv('ORACLE_HOME=D:\oracle\ora92');
putenv('ORACLE_SID=oradb2');

$db = "oradb2";

$c1 = ocilogon("scott", "tiger", $db) or die("Could not connet");
$c2 = ocilogon("scott", "tiger", $db)or die("Could not connet");

my both oracle 9.2.0.2 and php are in windows environment.

Thanks in advance for all your help

Regards,
Najm