Re: Weird TNS error with DBI::Oracle 1.21 & oracle 11G

From: johnson@xxxxxxxxxxxxxxxxxxxx (Bruce Johnson)
Date: Tue, 29 Jul 2008 16:17:53 -0700

On Jul 29, 2008, at 11:51 AM, Bruce Johnson wrote:

Perl 5.8, DBI 1.607, DBI::Oracle 1.21, Oracle 11g (11.1.0)

Any script I try to run results in the error:

Database connection not made: ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach) at ./testdbi.pl line 9.

Bypassing TNS by specifying the connection as "host=hostname:port;sid=sid" works, so we're doing that for the moment.

--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group

Institutions do not have opinions, merely customs

.

References:
- Weird TNS error with DBI::Oracle 1.21 & oracle 11G
  - From: Bruce Johnson

Prev by Date: Weird TNS error with DBI::Oracle 1.21 & oracle 11G
Next by Date: Re: Questions related to DBI and DBD::Oracle
Previous by thread: Weird TNS error with DBI::Oracle 1.21 & oracle 11G
Next by thread: Re: Weird TNS error with DBI::Oracle 1.21 & oracle 11G
Index(es):
- Date
- Thread