Re: ORACLE8 + APACHE + WINDOWS + PHP
| From: | Leonardo Rezende | Date: | Fri, 01 Dec 2000 11:17:19 +0000 |
| Subject: | Re: ORACLE8 + APACHE + WINDOWS + PHP | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-4924@lists.php.net to get a copy of this message | ||
I put this in my httpd.conf:
SetEnv ORACLE_HOME "c:/orawin95"
SetEnv TNS_ADMIN "c:/orawin95/net80/admin"
SetEnv TNSDMIN "c:/orawin95/net80/admin"
If I write:
<?php echo "<HTML><HEAD><TITLE>TESTE
PHP</TITLE><BODY><PRE>";
$c1 = ocilogon("username","password","PHP"); echo $c1; echo
"</PRE><BODY></HTML>";?>
this error occur:
Warning: _oci_open_server: ORA-12154: TNS:could not resolve service name
in c:\arquivos de programas\apache group\apache\htdocs\index.php on line 6
but if I write this:
<?php
echo "<HTML><HEAD><TITLE>TESTE
PHP</TITLE><BODY><PRE>";
$c1 =
ocilogon("username","password","(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(COMMUNI
TY=PHP.world)(PROTOCOL=TCP)(HOST=200.100.100.2)(PORT=1521)))(CONNECT_DATA=(S
ERVICE_NAME=php)))");
echo $c1;
echo "</PRE><BODY></HTML>";?>
this error occur:
Warning: _oci_open_server: ORA-12699: Native service internal error
in c:\arquivos de programas\apache group\apache\htdocs\index.php on line 7
I have these line in my TNSNAME.ORA:
PHP.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 200.100.100.2)(PORT = 1521))
(CONNECT_DATA = (SID = MAC1))
)
I connect with SQLPlus normal. With "username", "password", "PHP";
I tested c:\orawin95\bin\tnsping80 php and the teste brings a OK result:
"Attempting to contact
(ADDRESS=(PROTOCOL=TCP)(HOST=200.100.100.2)(PORT=1521))OK (150 msec)
Please, help me...