DBI/DBD/Oracle connect failing (ORA-12154)

From: JC52C3500-P.J.REITER(HOR877)NONE <myhandle_at_lucent.com>
Date: Wed, 08 Dec 1999 17:24:35 -0500
Message-ID: <384EDAA3.AB872872@lucent.com>

Hi,

I'm new to this so I'm sorry if this has been answered X times before.

We have ORacle *i here.
We installed DBI and DBD.

I tried to connect to Oracle and keep on getting ORA-12154

Here is the line I am using...

---

$dbh = DBI->connect( 'DBI:Oracle:olsora1', 'webservr', 'oraclepass$$') || die " CANNOT OPEN DB\n";

---

Now my enrironment might be wrong, but I think the tnsnames.ora file is missing something. Could someone perhaps cut-n-paste relevant parts from their tnsnames.ora file?

Anyway, here is what I get everytime I run this...

---

DBI->connect failed: ORA-12154: TNS:could not resolve service name (DBD ERROR: OCIServerAttach) at pete.pl line 9
CANNOT OPEN DB

---

I'm a novice at this so anything might be wrong. Any pointers? Please?

Thanks much, and sorry if this should've been somewhere else.

Pete
--
Peter J. Reiter
Lucent Technologies
Holmdel, New Jersey
Rm. 3G-627
908-949-8545
pete_at_joker.lucent.com Received on Wed Dec 08 1999 - 16:24:35 CST