| Listener TNS-00515: Connect failed because target host or object does not exist [message #646353] |
Mon, 28 December 2015 09:38  |
 |
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 #646358 is a reply to message #646357] |
Mon, 28 December 2015 11:52  |
|
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 #646360 is a reply to message #646358] |
Mon, 28 December 2015 12:10 |
John Watson
Messages: 8966
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
