Have you looked into the Oracle error docs? What happens if you 'tnsping MAINO1'?
-- Ron Reidy Lead DBA Array BioPharma, Inc. -----Original Message----- From: Angela Chan [mailto:[EMAIL PROTECTED] Sent: Friday, March 10, 2006 9:24 AM To: [email protected] Subject: ORA-12154 message Hi, all, Since I can't get Oracle Client 9i ot 10g, I just down grade my PERL to 5.6.1 Build 638, and try to connect to ORACLE 8i. However, I get the following message: "DBI connect('MAIN01','owner',...) failed: ORA-12154: TNS:could not resolve the connect identifier specified (DBD ERROR: OCIServerAttach) at con_db.pl line 9" Does anyone know to solve this problem? Thanks Angela ============================================================ The following is my perl program: use strict; use DBI; my $dbh_target; $dbh_target = DBI->connect('dbi:Oracle:MAIN01', 'owner', 'oracle') or die "Can't connect to TARGET ODBC database [Error:".DBI->errstr."]"; print "\tPPS TARGET database: $dbh_target\n"; ============================================================= The following is my TNSNAME.ora file setting: MAIN01= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 162.16.90.58)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 162.16.90.59)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = SDPA) (FAILOVER_MODE = (TYPE= SELECT)(METHOD=BASIC)) ) ) 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.
