Re: Help with oci dll in PHP
| From: | Philippe Saladin | Date: | Wed, 04 Jun 2003 08:46:29 +0000 |
| Subject: | Re: Help with oci dll in PHP | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-28292@lists.php.net to get a copy of this message | ||
> Warning: ocilogon
> (): _oci_open_server: Error while trying to retrieve
> text for error ORA-12538 in c:\inetpub\wwwroot\php\index.php on line 15
ORA-12538 means "TNS : no such protocol"
- you have a problem in your TCP protocol ?
- or there is a typo error in your line :
> $db = " (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)
> (HOST =192.168.1.9) (PORT=1521)) (CONNECT_DATA = (SERVICE_NAME=test1))) ";
Here is what I use in my case :
$db="
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = <ip_address>)
(Port = 1521)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = <ip_address>)
(Port = 1526)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
";
Note the difference in CONNECT_DATA. Would it come from that ?
Hope it will help.
Regards,
Philippe