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

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
Received on Sun Dec 12 1999 - 06:43:26 CST