|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #58266 TNS PROBLEM
Submitted: 2008-07-08 09:40 UTC Modified: 2008-08-07 09:24 UTC
From: j dot kaluza at redcross-transfusion dot be Assigned:
Status: Open Package: PDO_OCI (PECL)
PHP Version: 5.2.5 OS: Windows XP pro
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
Block user comment
Status: Assign to:
Bug Type:
From: j dot kaluza at redcross-transfusion dot be
New email:
PHP Version: OS:


 [2008-07-08 09:40 UTC] j dot kaluza at redcross-transfusion dot be
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);
  $db = Zend_Db::factory("PDO_OCI",$params);
  return $db;
}catch(Zend_Db_Adapter_Exception $e){
	echo $e->getMessage();

Expected result:
successfull logon

Actual result:
logon faailure due to TNS problem


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2008-08-07 09:24 UTC] j dot kaluza at redcross-transfusion dot be
tnsnames.ora contents :

      (ADDRESS = (PROTOCOL = TCP)(HOST = sfsoraa1)(PORT = 1521))
      (SERVICE_NAME = test)
      (INSTANCE_NAME = test1)
    (HS = OK)

      (ADDRESS = (PROTOCOL = TCP)(HOST = sfsweb02.crb-sfs.local)(PORT = 1521))
      (SERVICE_NAME = web02prd.crbsfs.local)
PHP Copyright © 2001-2020 The PHP Group
All rights reserved.
Last updated: Sun Feb 23 02:01:26 2020 UTC