Home » RDBMS Server » Server Administration » Listener TNS-00515: Connect failed because target host or object does not exist ( 64-bit windows 7 Enterprise, Oracle 11 G 11.2.0.2.0)
Listener TNS-00515: Connect failed because target host or object does not exist [message #646353] Mon, 28 December 2015 09:38 Go to next message
matulaspox
Messages: 3
Registered: September 2011
Junior Member
Hello,

I cannot get my listener to start, I have spent hours searching forums and couldn't find any solution.
My goal is to start APEX, but first I have to get listener up&running, when I try, I'm getting:

C:\Users\matulewi>lsnrctl start

LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 28-GRU-2015 15:20:45

Copyright (c) 1991, 2014, Oracle. All rights reserved.

Starting tnslsnr: please wait...

TNSLSNR for 64-bit Windows: Version 11.2.0.2.0 - Production
System parameter file is C:\oraclexe\app\oracle\product\11.2.0\server\network\admin\listener.ora
Log messages written to C:\oraclexe\app\oracle\diag\tnslsnr\MATULEWI1\listener\alert\log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MATULEWI1.emea.xxxxx.net)(PORT=1521)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
64-bit Windows Error: 1004: Unknown error

My tnsnames.ora:

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = MATULEWI1.emea.xxxxx.net)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)


listener.ora:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
(PROGRAM = extproc)
)
)


LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = MATULEWI1.emea.xxxxx.net)(PORT = 1521))
)
)


DEFAULT_SERVICE_LISTENER = (XE)


Could somebody please help out?

Re: Listener TNS-00515: Connect failed because target host or object does not exist [message #646354 is a reply to message #646353] Mon, 28 December 2015 09:48 Go to previous messageGo to next message
John Watson
Messages: 7255
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

Your searches for TNS-12545 must have been very unfortunate. The problem is (as all the references say) that your hostname is either incorrect or not resolving correctly. You are trying to listen on MATULEWI1.emea.xxxxx.net, does this name actually exist and resolve? What does your etc/hosts file and your DNS say about it?
Re: Listener TNS-00515: Connect failed because target host or object does not exist [message #646356 is a reply to message #646354] Mon, 28 December 2015 10:30 Go to previous messageGo to next message
matulaspox
Messages: 3
Registered: September 2011
Junior Member
Hi,

thanks for the prompt reply.
Yes, that name exists and that is the name of my machine.
My hosts file:

127.0.0.1 localhost MATULEWI1.emea.xxxxx.net

I've added MATULEWI1.emea.xxxxx.net later on , to check whether it is the cause. (I've x'ed out company name)
DNS are to set to automaticly obtain.

K.
Re: Listener TNS-00515: Connect failed because target host or object does not exist [message #646357 is a reply to message #646356] Mon, 28 December 2015 11:01 Go to previous messageGo to next message
John Watson
Messages: 7255
Registered: January 2010
Location: Global Village
Senior Member
So prove it. With ping and nslookup. Note that it would be highly unusual to have a fixed static address mapped to 127.0.0.1 in your DNS.
Re: Listener TNS-00515: Connect failed because target host or object does not exist [message #646358 is a reply to message #646357] Mon, 28 December 2015 11:52 Go to previous messageGo to next message
matulaspox
Messages: 3
Registered: September 2011
Junior Member
here you are

C:\Users\matulewi>nslookup
Default Server: pl-waw4a-dns04.chello.pl
Address: 62.179.1.63

C:\Users\matulewi>ping localhost

Pinging MATULEWI1.emea.xxxxx.net [127.0.0.1] with 32 bytes of data:
Reply from 127.0.0.1: bytes=32 time=1ms TTL=128
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128

Ping statistics for 127.0.0.1:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 1ms, Average = 0ms

[Updated on: Mon, 28 December 2015 11:52]

Report message to a moderator

Re: Listener TNS-00515: Connect failed because target host or object does not exist [message #646359 is a reply to message #646358] Mon, 28 December 2015 12:05 Go to previous messageGo to next message
John Watson
Messages: 7255
Registered: January 2010
Location: Global Village
Senior Member
Well, running nslookup as you did doesn't tell you a lot about what the DNS thinks is the address of your name, does it?
And pinging localhost doesn't tell you anything, either.

Seriously, you need to learn how to use these tools. Then think about configuring Oracle Net.
Re: Listener TNS-00515: Connect failed because target host or object does not exist [message #646360 is a reply to message #646358] Mon, 28 December 2015 12:10 Go to previous messageGo to next message
John Watson
Messages: 7255
Registered: January 2010
Location: Global Village
Senior Member
I see that you have just edited your post, and therefire obscured what you actually did. Please don't do that, editing posts without explanation causes dreadful confusion, because no-one knows what the truth is.

And please read the links I provided earlier, about using [code] tags.

I'll give you a quick-fix solution:

Edit your listener.ora file and tnsnames.ora file to specify 127.0.0.1 as the address, not that host name. Then everything should work, until you want to connect from an external address.


--update: removed some identification information, which I guess is why OP edited his post before.

[Updated on: Mon, 28 December 2015 12:13]

Report message to a moderator

Re: Listener TNS-00515: Connect failed because target host or object does not exist [message #646363 is a reply to message #646360] Mon, 28 December 2015 12:46 Go to previous message
John Watson
Messages: 7255
Registered: January 2010
Location: Global Village
Senior Member
Problem solution received in a private message - posting here to make it available to others:

Quote:

<snip>
many thanks for the resolution - it helped.
And I've edited the post for privacy purposes - I wanted to hide my domain.
<snip>
Previous Topic: ORA-12154: TNS:could not resolve the connect identifier specified in oracle 12c
Next Topic: EXP-00008: ORACLE error 1406 encountered ORA-01406: fetched column value was truncated EXP-00000: Ex
Goto Forum:
  


Current Time: Sun Feb 18 13:16:23 CST 2018

Total time taken to generate the page: 0.01191 seconds