Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DBI/DBD/Oracle connect failing (ORA-12154)

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

From: <websoftpro_at_my-deja.com>
Date: Mon, 13 Dec 1999 11:12:43 GMT
Message-ID: <832kba$ust$1@nnrp1.deja.com>


In article <83058u$r4$1_at_news101.telia.com>,   "AG" <anders.larsen_at_bigfoot.com> wrote:
> You need to start the "OracleAgent"-service in your control
panel\services,
> otherwise your system won't know that your database exists.
>
> AG.
>
> JC52C3500-P.J.REITER(HOR877)NONE <myhandle_at_lucent.com> wrote in
message
> news:384EDAA3.AB872872_at_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
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Dec 13 1999 - 05:12:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US