Edit report at https://bugs.php.net/bug.php?id=58266&edit=1
ID: 58266
Updated by: cmb@php.net
Reported by: j dot kaluza at redcross-transfusion dot be
Summary: TNS PROBLEM
-Status: Open
+Status: Feedback
Type: Bug
-Package: PDO_OCI
+Package: PDO OCI
Operating System: Windows XP pro
PHP Version: 5.2.5
-Assigned To:
+Assigned To: cmb
Block user comment: N
Private report: N
New Comment:
Is this still an issue with any of the actively supported PHP
versions[1]?
[1] <https://www.php.net/supported-versions.php>
Previous Comments:
------------------------------------------------------------------------
[2008-08-07 09:24:10] j dot kaluza at redcross-transfusion dot be
tnsnames.ora contents :
TEST1_SFSORAA1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sfsoraa1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test)
(INSTANCE_NAME = test1)
)
(HS = OK)
)
SFSWEB02.CRBSFS.LOCAL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sfsweb02.crb-sfs.local)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = web02prd.crbsfs.local)
)
)
------------------------------------------------------------------------
[2008-07-08 09:40:37] j dot kaluza at redcross-transfusion dot be
Description:
------------
Hello,
While trying to connect to Oracle database with PDO_OCI, i get ORA error following :
ORA-12533:TNS:illegal ADDRESS parameters
If i modify the TNS identifier in the source code (index dbname of $params array) nothing change,
even if the tns i use doesn't exist. With Oracle software, it works, it will work also with
oci8 package
Reproduce code:
---------------
$options = array ( Zend_Db::CASE_FOLDING => Zend_Db::CASE_UPPER);
$params = array ('username' => 'myuser',
'password' => 'mypass',
'dbname' => 'TEST1_SFSORAA1',
'options' => $options);
try{
$db = Zend_Db::factory("PDO_OCI",$params);
$db->getConnection();
return $db;
}catch(Zend_Db_Adapter_Exception $e){
echo $e->getMessage();
}
Expected result:
----------------
successfull logon
Actual result:
--------------
logon faailure due to TNS problem
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=58266&edit=1