Re: (OT) DBD error Ora-12154

Well, that means that Oracle couldn't connect to the name you gave it . . . doesn't get much simpler than that. You need to consult with your DBA and or sysadmin and make sure that "CDWP02" is the right database name (I think "sid" in Oracle parlance) to be using.

Comment on Re: (OT) DBD error Ora-12154

Replies are listed 'Best First'.
Re^2: (OT) DBD error Ora-12154 by Anonymous Monk on Apr 10, 2015 at 18:06 UTC
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 !!!	[reply]
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.	[reply]
Re^2: (OT) DBD error Ora-12154 by Anonymous Monk on Apr 13, 2006 at 16:55 UTC
Well CDWP02 worked before with the same type of settings here is what the tnsnames.ora file has for this database: `CDWP02.HQ.TARGET.COM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = cdwdb)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = CDWP02) ) )` [download] This is what the other software are using to connect to oracle and they seem to be working fine. Thanks again...	[reply] [d/l]