Home » Infrastructure » Windows » ORA-12154: TNS:could not resolve the connect identifier specified
ORA-12154: TNS:could not resolve the connect identifier specified [message #360614] Fri, 21 November 2008 11:00 Go to next message
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-12545: Connect failed because target host or object does not exist.

Any body help me in this
Re: ORA-21545 Problem [message #360617 is a reply to message #360614] Fri, 21 November 2008 11:38 Go to previous messageGo to next message
Michel Cadot
Messages: 58485
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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
Re: ORA-21545 Problem [message #360618 is a reply to message #360617] Fri, 21 November 2008 11:42 Go to previous messageGo to next message
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.
Re: ORA-21545 Problem [message #360623 is a reply to message #360618] Fri, 21 November 2008 12:02 Go to previous messageGo to next message
Michel Cadot
Messages: 58485
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: ORA-21545 Problem [message #360624 is a reply to message #360623] Fri, 21 November 2008 12:05 Go to previous messageGo to next message
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.
Re: ORA-21545 Problem [message #360639 is a reply to message #360623] Fri, 21 November 2008 13:49 Go to previous messageGo to next message
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
ORA-12154: TNS:could not resolve the connect identifier specified [message #360642 is a reply to message #360614] Fri, 21 November 2008 14:10 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 58485
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous message
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
Previous Topic: How to connect Developer 6i and Oracle 8i.
Next Topic: Help ! Ipconfig command unrecognized
Goto Forum:
  


Current Time: Tue Jul 22 13:26:45 CDT 2014

Total time taken to generate the page: 0.13228 seconds