php.net |  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:
Package:
Bug Type:
Summary:
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
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

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2008-08-07 09:24 UTC] 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)
    )
  )
 
PHP Copyright © 2001-2019 The PHP Group
All rights reserved.
Last updated: Sat Sep 21 19:01:26 2019 UTC