Zend Framework

Can not connect to Oracle Database with SERVICE_NAME and can't use tnsnames.ora as well

Details

  • Type: Bug Bug
  • Status: Open Open
  • Priority: N/A N/A
  • Resolution: Unresolved
  • Affects Version/s: None
  • Fix Version/s: None
  • Component/s: Zend_Db_Adapter_Oracle
  • Labels:
    None

Description

I am using zend core version 2.5.2 and attempting to connect to Oracle 10g database. I used following code to set up the details
$config = new Zend_Config(
array(
'database' => array(
'adapter' => 'pdo_oci',
'params' => array('host'=> 'host1, 'port'=>'1521','dbname'=> 'DEV','username' => 'dev','password' => 'pwd')
)
)
);
$db = Zend_Db::factory($config->database);
Zend_Db_Table::setDefaultAdapter($db);

I keep getting ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (ext\pdo_oci\oci_driver.c:581)' for this.
The database is expecting SERVICE_NAME instead of SID. And for this reason I can't seem to connect to the database.

I tried putting TNS_ADMIN in environment variable and assign tnsnames.ora entry to dbname. Then I get illegal address parameter error. I could connect to the databases which can accept SID parameter. But since this is clustered database, it expects service_name.
Any help is appreciated. I am running out of ideas.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Vik Paul added a comment -

I changed:

../library/Zend/Db/Adapter/Pdo/Oci.php
line 89: replaced SID with SERVICE_NAME

It is working fine now.

Show
Vik Paul added a comment - I changed: ../library/Zend/Db/Adapter/Pdo/Oci.php line 89: replaced SID with SERVICE_NAME It is working fine now.
Hide
Permalink
Jurrien Stutterheim added a comment -

Which version of the Pdo_Oci adapter are you using? There's a patched version in the trunk that allows you to use tnsnames.ora.

Show
Jurrien Stutterheim added a comment - Which version of the Pdo_Oci adapter are you using? There's a patched version in the trunk that allows you to use tnsnames.ora.
Hide
Permalink
Vik Paul added a comment -

We are using zend core v2.5. I couldn't see any version info on pdo_oci in admin console. But found following line in ../ZendFramework/library/Zend/Db/Adapter/Pdo/Oci.php file

@version $Id: Oci.php 11942 2008-10-13 20:21:18Z mikaelkael $

Show
Vik Paul added a comment - We are using zend core v2.5. I couldn't see any version info on pdo_oci in admin console. But found following line in ../ZendFramework/library/Zend/Db/Adapter/Pdo/Oci.php file @version $Id: Oci.php 11942 2008-10-13 20:21:18Z mikaelkael $
Hide
Permalink
Mickael Perraud added a comment -

Try the new 1.8, please

Show
Mickael Perraud added a comment - Try the new 1.8, please
Hide
Permalink
Roger Hunwicks added a comment -

We are using the Oracle Easy Connect syntax in conjunction with the service name. I think this approach is better, because all the configuration is within the Zend_Config, we are not reliant on the TNSNAMES being configured correctly. Obviously, if you have a cluster or something like that, TNSNAMES is probably the better option:

$config = new Zend_Config(
array(
'database' => array(
'adapter' => 'oracle',
'params' => array('dbname'=> '//hostname.domain.tld/service_name','username' => 'dev','password' => 'pwd')
)
)
);
$db = Zend_Db::factory($config->database);
Zend_Db_Table::setDefaultAdapter($db);
Show
Roger Hunwicks added a comment - We are using the Oracle Easy Connect syntax in conjunction with the service name. I think this approach is better, because all the configuration is within the Zend_Config, we are not reliant on the TNSNAMES being configured correctly. Obviously, if you have a cluster or something like that, TNSNAMES is probably the better option: 
$config = new Zend_Config(
array(
'database' => array(
'adapter' => 'oracle',
'params' => array('dbname'=> '//hostname.domain.tld/service_name','username' => 'dev','password' => 'pwd')
)
)
);
$db = Zend_Db::factory($config->database);
Zend_Db_Table::setDefaultAdapter($db);
Hide
Permalink
franek added a comment -

Hi,

For us, Oracle Easy Connect syntax does not work.
To resolve the problem we need to use tnsnames.ora syntax : 

$config = new Zend_Config(
array(
'database' => array(
'adapter' => 'oracle',
'params' => array(
	'dbname'=> '(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = hostname.domain.tld)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = service_name)))',
	'username' => 'dev',
	'password' => 'pwd')
	)
)
);
$db = Zend_Db::factory($config->database);
Zend_Db_Table::setDefaultAdapter($db);

...

Show
franek added a comment - Hi, For us, Oracle Easy Connect syntax does not work. To resolve the problem we need to use tnsnames.ora syntax : 
$config = new Zend_Config(
array(
'database' => array(
'adapter' => 'oracle',
'params' => array(
	'dbname'=> '(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = hostname.domain.tld)(PORT = 1521))(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = service_name)))',
	'username' => 'dev',
	'password' => 'pwd')
	)
)
);
$db = Zend_Db::factory($config->database);
Zend_Db_Table::setDefaultAdapter($db);
...

People

Vote (1)
Watch (2)

Dates

  • Created:
    Updated:
Atlassian JIRA (v4.4.3#663-r165197) | Report a problem
Powered by a free Atlassian JIRA open source license for Zend Framework. Try JIRA - bug tracking software for your team.