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:[EMAIL PROTECTED] Sent: Friday, December 30, 2005 12:57 PM To: [email protected] 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.
