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

I have the same problem. Would you tell me how to up the Oracle Agent in Oracle for Linux?

Timothy

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:09:52 CST