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))
)
)

RE: ORA-12154 message

Have you looked into the Oracle error docs? What happens if you
'tnsping MAINO1'?

--
Ron Reidy
Lead DBA=20
Array BioPharma, Inc.

-----Original Message-----
From: Angela Chan [mailto:achan90@gmail.com]=20
Sent: Friday, March 10, 2006 9:24 AM
To: dbi-users@perl.org
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 =
==================== =====3D=
==================== =====3D=
==========
The following is my perl program:
use strict;
use DBI;
my $dbh_target;

$dbh_target =3D 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";

==================== =====3D=
==================== =====3D=
===========3D
The following is my TNSNAME.ora file setting:
MAIN01=3D
(DESCRIPTION =3D
(ADDRESS_LIST =3D
(ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D 162.16.90.58)(PORT =3D =
1521))
(ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D 162.16.90.59)(PORT =3D =
1521))
)
(CONNECT_DATA =3D
(SERVICE_NAME =3D SDPA)
(FAILOVER_MODE =3D (TYPE=3D SELECT)(METHOD=3DBASIC))
)
)





This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
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.