Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re^2: (OT) DBD error Ora-12154

by Anonymous Monk
on Apr 10, 2015 at 18:06 UTC ( [id://1123056]=note: print w/replies, xml ) Need Help??


in reply to Re: (OT) DBD error Ora-12154
in thread (OT) DBD error Ora-12154

Man here almost 9 years later I am going through the same head against the wall, bleeding, eyes flaming. Oracle is really the biggest pain to config and I go through this every so many years.

To all those with idea it's the tnsnames.ora or it cant find it is just flat wrong. Why?

tnsping hits my alias in tnsnames.ora fine
toad works fine with the same oracle home
sqlplus connects with tnsname
environment vars set
ORACLE_HOME standard app/client/"username"/client/oracle
TNS_ADMIN oracle_home/network/admin
then perl dbi TNS:could not resolve the connect identifier !!! WHAT THE HECK !!!

Replies are listed 'Best First'.
Re^3: (OT) DBD error Ora-12154
by Anonymous Monk on Jul 16, 2020 at 17:20 UTC
    Any luck? I am going through the same thing now. Everything was working fine and suddenly I can't connect to Oracle from perl.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1123056]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others having an uproarious good time at the Monastery: (7)
As of 2024-04-18 03:11 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found