Skip Menu |
 

Preferred bug tracker

Please visit the preferred bug tracker to report your issue.

This queue is for tickets about the DBD-Oracle CPAN distribution.

Report information
The Basics
Id: 9166
Status: resolved
Priority: 0/
Queue: DBD-Oracle

People
Owner: Nobody in particular
Requestors: n.wuest [...] arcor.de
Cc:
AdminCc:

Bug Information
Severity: Normal
Broken in: 1.12
Fixed in: (no value)



Subject: Can´t connect to remoteserver with several dbinstances
Download (untitled) / with headers
text/plain 1.2k
My System SuSE Linux 8.0 with kernel 2.4.18-64GB-SMP, Oracle 8.1.7, perl 5.6.1, DBD::Oracle 1.12, DBI 1.20 I tried to connect to another host with the same configuration trough DBD::Oracle without tnsnames.ora. On the remote System there are two instances. The first with SID=elwiso, the other with SID=pub. Connecting to elwiso everything works fine, but connection to pub i got an error "ORA-12545: Connect failed because target host or object does not exist (DBD ERROR: OCIServerAttach)" Next i tried to connect with tnsnames.ora and everything worked fine. After a few tests i found this: In tnsnames.ora for every service there is the tag (SID=XXX)(SERVER=DEDICATED, so i tried to understand Oracle.pm how to configure connection without using tnsnames.ora and found in line 201 '$dbname = "(DESCRIPTION=$addrs(CONNECT_DATA=(SID=$sid)))";' Next i changed it to '$dbname = "(DESCRIPTION=$addrs(CONNECT_DATA=(SID=$sid)(SERVER=$dbname{SERVER})))"; ' Now it´s possible to use connection string like "dbi:Oracle:host=$host;sid=$sid;server=$servertype" and everything works find. Ignoring server is also no problem. Next i compared DBD::Oracle 1.12 with DBD::Oracle 1.16 and i think the changes must also be done there, but I can´t test it here, cause this version doesn´t work on my hosts.


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.