Skip to Main Content

Error (ORA-28547) - PHP. Please help

881764Aug 11 2011 — edited Aug 12 2011
I am trying to connect

With this code:

<?php
$tns = '(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = supertrain)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = train)
)
)';

$conn = oci_connect('user', 'pass', $tns);
echo "<pre>";
print_r($conn);
?>

+But get an error: Warning: oci_connect() [function.oci-connect]: ORA-28547: connection to server failed, probable Oracle Net admin error in C:\Zend\Apache2\htdocs\odbc\index.php on line 10+

My configuration:
-----
Zend Server Community Edition
Version 5.1.0
Build ZendServer-CE-5.1.0_B104-5.3.5-Windows_x86

PHP
Version 5.3.5
PHP Configuration File C:\Zend\ZendServer\etc\php.ini

oci8
OCI8 Support enabled
Version 1.4.5
Revision $Revision: 305257 $
Active Persistent Connections 0
Active Connections 0
Oracle Instant Client Version Unknown
Temporary Lob support enabled
Collections support enabled

Directive Local Value Master Value
oci8.connection_class no value no value
oci8.default_prefetch 100 100
oci8.events Off Off
oci8.max_persistent -1 -1
oci8.old_oci_close_semantics Off Off
oci8.persistent_timeout -1 -1
oci8.ping_interval 60 60
oci8.privileged_connect Off Off
oci8.statement_cache_size 20 20

Web Server
Server Name localhost
Server Software Apache/2.2.16 (Win32) mod_ssl/2.2.16 OpenSSL/0.9.8o
OS Version Windows XP

Oracle
Client - Oracle - OraClient11g_home1 (11.1.0)
Server - Oracle 11
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Sep 9 2011
Added on Aug 11 2011
1 comment
912 views