RE: :Oracle - with ora10g oci.dll

This is most likely not a DBD::Oracle nor DBI error. From oerr:

$ oerr ora 12514
12514, 00000, "TNS:listener could not resolve SERVICE_NAME given in
connect descriptor"
// *Cause: The SERVICE_NAME in the CONNECT_DATA was not found in
// the listener's tables.
// *Action: Check to make sure that the SERVICE_NAME specified is
correct.
// *Comment: This error will be returned if the (database) service has
not been
// registered with the listener; a database instance that is part of
this
// service may need to be started or configured properly.

Looking at your code, your connection descriptor seems suspect:
irmops.prod.irm

The correct syntax is: 'dbi:Oracle:DBNAME' # DBNAME is your database
identifier.

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-----Original Message-----
From: Mitchell, Louise M [mailto:Louise.Mitchell@xxxxxxx]
Sent: Friday, December 30, 2005 12:57 PM
To: dbi-users@xxxxxxxx
Subject: DBD::Oracle - with ora10g oci.dll


Hi,

I am having some issues with the DBD::Oracle.

I'm running Perl 5.8.7 build 813 from active state on a win2k3 server.

I installed Oracle 9.2.0 client.

I then installed DBI and DBD::Oracle (1.16), which installs the oci.dll
as well as oraociei10.dll.

I can connect using sqlplus manually from the command window, but my
connection through the dbi fails with the following error:

*******************************
DBI connect('irmops.prod.irm','batchrun',...) failed: ORA-12154:
TNS:could not resolve the connect identifier specified (DBD ERROR:
OCIServerAttach) at D:\apps\test\test.pl line 9
ORA-12154: TNS:could not resolve the connect identifier specified (DBD
ERROR: OCIServerAttach) at D:\apps\test\test.pl line 10.
************************

This would indicate an sqlnet configuration error. We use nameservers,
so I have my sqlnet.ora file properly set up in my 9.2.0 installation
under the /network/admin directory.

I'm guessing that the 10i oci is not properly configured to understand
how to get to our nameservers.

I'm a little puzzled and not sure how to handle this error, since the
10g installation is really just a few files in the /perl/bin directory.

Any help is appreciated.

Thanks,
LouiseM

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

.

Relevant Pages

  • status on DBI installation on AIX 5.2
    ... I have compiled successfully the DBI by following your suggestion. ... when I re-built Perl 5.8.7 from source code, ... I tried Perl 5.8.6 installation from source code, ... Onderwerp: RE: DBI installation failure on AIX 5.2, ...
    (perl.dbi.users)
  • RE: Intranet Installation Error
    ... I understand that sometimes to resolve the issue efficiently is more ... This newsgroup only focuses on SBS technical issues. ... you may want to contact Microsoft CSS directly. ... Subject: Intranet Installation Error ...
    (microsoft.public.windows.server.sbs)
  • RE: DBI and DBD::Oracle throw error Had to create DBD::Oracle::dr::imp_data_size unexpectedly
    ... on the system of the dbd to build a new one. ... perl is running without the recommended perl -w option ... Subject: DBI and DBD::Oracle throw error Had to create ... identical installation on some new quad core servers the script fails ...
    (perl.dbi.users)
  • Re: DBI and DBD::Oracle throw error Had to create DBD::Oracle::dr::imp_data_size unexpectedly
    ... on the system of the dbd to build a new one. ... perl is running without the recommended perl -w option ... Subject: DBI and DBD::Oracle throw error Had to create ... identical installation on some new quad core servers the script fails ...
    (perl.dbi.users)
  • Re: Word 2007 has encountered a problem and needs to close
    ... sorry for the delay in responding as it has taken some time to resolve. ... getting the error message either in Word or Powerpoint. ... "Jomark" wrote: ... My problem is that the office installation has been corrupted and I ...
    (microsoft.public.word.application.errors)