[Resolved] Oracle + PHP + command prompt = no access

[AstroTeg]

I'm thinking this is probably an environment variable problem. I'm on a W2k Pro machine with Apache v1.3 & PHP v4.3.4. I'm able to connect to Oracle and do whatever from within Apache. But I get the following error if I try from the command prompt:

Oracle: Connection Failed: ORA-12154: TNS:could not resolve service name

Connection string looks a little something like this:

$connection = ora_logon("[e-mail]","user") or die("Couldn't logon to database.");

I'm thinking I need to set some environment variables from within PHP but I haven't had much luck. Anybody run into this before?

[LordShryku]

I have. Just using putenv to set the variables, and it worked for me.

putenv("ORACLE_HOME=/opt/ora8/product/8.1.7");
putenv("ORACLE_SID=ora8i");

[AstroTeg]

Hmm... I've tried that. Here's what I currently have:

<?
putenv("ORACLE_HOME=C:/oracle");
putenv("ORACLE_SID=UAT");
$connection = ora_logon("[e-mail]", "pass") or die("Couldn't logon to database.\n" . ora_error());
?>

I've set ORACLE_SID to both UAT and UAT.world without luck.

What's odd is I can run sqlplus from the command prompt just fine. I can run the above code from Apache just fine. And I can run this on a Win98 box just fine. Odd. I'm positive I'm missing something...

[AstroTeg]

It appears I found the problem...

SQLNET.ORA and TNSNAMES.ORA must both use Unix style carriage returns, not PC flavored. I switched the style and I was able to connect from the command prompt.

Here's the quote I found from php.net:

"When using PHP4 in CGI-mode with Windows NT or Windows 2000 with IIS or Apache, make sure that the TNSNAMES.ORA and the SQLNET.ORA do not contain DOS/Windows CR/LF line endings.<br> Instead, they must have UNIX (only LF) endings. Otherwise, you will get an ORA-12154 error (TNS cannot resolve service name) when connecting to a remote database.<br>
This all does not matter if you use the ISAPI mode. "

[LordShryku]

That's strange...good to know though. Thanks for posting the answer 🙂