OraFAQ Forum: Windows » ORA-12154: TNS:could not resolve the connect identifier specified

Home » Infrastructure » Windows » ORA-12154: TNS:could not resolve the connect identifier specified

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-12154: TNS:could not resolve the connect identifier specified [message #360614]

Fri, 21 November 2008 11:00

shrinivas.boga
Messages: 5
Registered: November 2008

Junior Member

Report message to a moderator

Re: ORA-21545 Problem [message #360617 is a reply to message #360614]

Fri, 21 November 2008 11:38

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Code: [Select all] [Show/ hide]

ORA-12545: Connect failed because target host or object does not exist
 *Cause: The address specified is not valid, or the program being
 connected to does not exist.
 *Action: Ensure the ADDRESS parameters have been entered correctly; the
 most likely incorrect parameter is the node name.  Ensure that the
 executable for the server exists (perhaps "oracle" is missing.)
 If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change the
 host name to a numeric IP address and try again.

Try to ping the target host.

Regards
Michel

Report message to a moderator

Re: ORA-21545 Problem [message #360618 is a reply to message #360617]

Fri, 21 November 2008 11:42

shrinivas.boga
Messages: 5
Registered: November 2008

Junior Member

Hi,

How to do that, because I am using the alias to host IP. when iam doing ping to that alias then it is saying that "unable to resolve the name"

As I said I am new to Oracle, whatever you explain me please do in in very descriptive manner.

I would be very thankful if you do so.

Thanks You.

Report message to a moderator

Re: ORA-21545 Problem [message #360623 is a reply to message #360618]

Fri, 21 November 2008 12:02

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

This has nothing to do with Oracle.
If you can't ping the host then Oracle can't do it either.
You have to correctly configure your OS network parameters or use use IP.

Regards
Michel

Report message to a moderator

Re: ORA-21545 Problem [message #360624 is a reply to message #360623]

Fri, 21 November 2008 12:05

shrinivas.boga
Messages: 5
Registered: November 2008

Junior Member

Thanks, I will check the IP's I am trying to connect and whether i am able to ping them.

Report message to a moderator

Re: ORA-21545 Problem [message #360639 is a reply to message #360623]

Fri, 21 November 2008 13:49

shrinivas.boga
Messages: 5
Registered: November 2008

Junior Member

Now I am able to ping to the host. My TNSNAME.ora and SQLNET.ora look like below.

################
# Filename......: tnsnames.ora
# Name..........: LOCAL_REGION.world
# Date..........: 20-APR-96 13:38:47
################
# 02/04/99 Burlock - Entries in support of pdw on the benchmark system, pdw_bench, dps_bench, rpt_bench
pdw_bench.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = hts_tcpip.world)
(PROTOCOL = TCP)
(Host = dps.bm2.lab)
(Port = 1523)
)
)
(CONNECT_DATA =
(SID = pdwp)
)
)
dps_bench.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = hts_tcpip.world)
(PROTOCOL = TCP)
(Host = dps.bm2.lab)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = dpsp)
)
)
dps_prod.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = hts_tcpip.world)
(PROTOCOL = TCP)
(Host = dps)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = dpsp)
)
)
pdw_prod.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = hts_tcpip.world)
(PROTOCOL = TCP)
(Host = pdw)
(Port = 1523)
)
)
(CONNECT_DATA =
(SID = pdwp)
)
)
htsu36_dpsd.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = hts_tcpip.world)
(PROTOCOL = TCP)
(Host = htsu36)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = dpsd)
)
)

htsu63.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = htsu63)(PORT = 1521))
)
(CONNECT_DATA = (SID = hrznd)(SERVER = DEDICATED))
)

hrzn.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hrzn)(PORT = 1525))
)
(CONNECT_DATA = (SID = hrznp)(SERVER = DEDICATED))
)
htsu36_pdwd.world =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = htsu36)(PORT = 1521))
(CONNECT_DATA = (SID = pdwd))
)

################
#
# Filename......: SQLNET.ora
#
################

AUTOMATIC_IPC = OFF
TRACE_LEVEL_CLIENT = OFF
NAMES.DIRECTORY_PATH = (TNSNAMES)
names.default_domain = world
name.default_zone = world

Now I am getting the Error : ORA-12154: TNS:could not resolve the connect identifier specified

Report message to a moderator

ORA-12154: TNS:could not resolve the connect identifier specified [message #360642 is a reply to message #360614]

Fri, 21 November 2008 14:10

shrinivas.boga
Messages: 5
Registered: November 2008

Junior Member

Hi all,

I am very new to the Database. I dont know anything about database. Please somebody help me in below described problem.

I have an application running on Windows XP SP2. Which is connecting to a remote machine database. which is able to connect it and working properly as desired.

Problem : I have brought a new machine with advanced hardware. Installed same Windows XP SP2, the network configuration, gateway, subnet etc. all are same as the XP machine. I have installed the same version of oracle in this machine. I have copied the TNSNAMES.ora and SQLNET.ora files from old working XP machine. All the system DSN in Administrative tools->ODBC are set as they are in old machine.

But when I am trying to run the application, It is giving the below error.

Error : ORA-12154: TNS:could not resolve the connect identifier specified

My TNSNAME.ora and SQLNET.ora look like below.

################
# Filename......: tnsnames.ora
# Name..........: LOCAL_REGION.world
# Date..........: 20-APR-96 13:38:47
################
# 02/04/99 Burlock - Entries in support of pdw on the benchmark system, pdw_bench, dps_bench, rpt_bench
pdw_bench.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = hts_tcpip.world)
(PROTOCOL = TCP)
(Host = dps.bm2.lab)
(Port = 1523)
)
)
(CONNECT_DATA =
(SID = pdwp)
)
)
dps_bench.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = hts_tcpip.world)
(PROTOCOL = TCP)
(Host = dps.bm2.lab)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = dpsp)
)
)
dps_prod.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = hts_tcpip.world)
(PROTOCOL = TCP)
(Host = dps)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = dpsp)
)
)
pdw_prod.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = hts_tcpip.world)
(PROTOCOL = TCP)
(Host = pdw)
(Port = 1523)
)
)
(CONNECT_DATA =
(SID = pdwp)
)
)
htsu36_dpsd.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = hts_tcpip.world)
(PROTOCOL = TCP)
(Host = htsu36)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = dpsd)
)
)

htsu63.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = htsu63)(PORT = 1521))
)
(CONNECT_DATA = (SID = hrznd)(SERVER = DEDICATED))
)

hrzn.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hrzn)(PORT = 1525))
)
(CONNECT_DATA = (SID = hrznp)(SERVER = DEDICATED))
)
htsu36_pdwd.world =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = htsu36)(PORT = 1521))
(CONNECT_DATA = (SID = pdwd))
)

################
#
# Filename......: SQLNET.ora
#
################

AUTOMATIC_IPC = OFF
TRACE_LEVEL_CLIENT = OFF
NAMES.DIRECTORY_PATH = (TNSNAMES)
names.default_domain = world
name.default_zone = world

I have installed the Oracle ODAC for Net Manger and all. Which created a LISTENER.ORA and SQLNET.ORA in the location C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN

Where as the Oracle is installation created the TNSNAMES.ora and SQLNET.ora at the location C:\ORANT\NETWORK\ADMIN which are replaced by old machines copies.

Please somebody help, Its urgent.

[Updated on: Fri, 21 November 2008 14:28]

Report message to a moderator

Re: ORA-12154: TNS:could not resolve the connect identifier specified [message #360647 is a reply to message #360642]

Fri, 21 November 2008 14:30

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1/ Nothing is urgent in a forum
2/ You didn't tell us what was you connect string
3/ what you say and post ping statement
4/ tnsping the service you're trying to access (and post it)
5/ Post your OBDC connection string and DSN
...

Before please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and use code tags.
Use the "Preview Message" button to verify.

Regards
Michel

[Updated on: Fri, 21 November 2008 14:31]

Report message to a moderator

Re: ORA-12154: TNS:could not resolve the connect identifier specified [message #361994 is a reply to message #360642]

Sat, 29 November 2008 05:56

zoltanp
Messages: 58
Registered: March 2005
Location: Hungary

Member

Please try to write these hosts into the "hosts" on client.
(c:\winnt\system32\drivers\etc\hosts under XP) or change the value of HOST parameters in tnsnames.ora with IP number.

Regards,
Zoltan Patalenszki

Report message to a moderator

Previous Topic:	How to connect Developer 6i and Oracle 8i.
Next Topic:	Help ! Ipconfig command unrecognized

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 05 11:49:17 CDT 2025