Home » RDBMS Server » Networking and Gateways » Listener for oracle HS not starting
Listener for oracle HS not starting [message #499940] Wed, 16 March 2011 15:33 Go to next message
infinitenumbers
Messages: 33
Registered: November 2010
Member
Hi Guys,

I am done with my configuration for oracle HS to connect to SQLserver. When I tried to start my listener, it is giving the following errors.

-----------------------------------------------------------------
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
System parameter file is D:\oracle\product\10.2.0\db_1\network\admin\listener.or
a
Log messages written to D:\oracle\product\10.2.0\db_1\network\log\listenersqlodb
c.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=CINID180WTAPP.kend
le.com)(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
32-bit Windows Error: 49: Unknown error

Listener failed to start. See the error message(s) above...
----------------------------------------------------------------


Please help with this.

Contents of my listener.ora file are below
--------------------------------------------------------------
LISTENERSQLODBC =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST=
(ADDRESS= (PROTOCOL = tcp)(HOST = HOSTNAME)(PORT=1521))
(ADDRESS= (PROTOCOL = ipc)(KEY = PNPKEY))
)
)
)

SID_LIST_LISTENERSQLODBC =
(SID_LIST =
(SID_DESC = (SID_NAME = SQLODBC)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = HSODBC)
)
)
Re: Listener for oracle HS not starting [message #499942 is a reply to message #499940] Wed, 16 March 2011 17:10 Go to previous message
BlackSwan
Messages: 26752
Registered: January 2009
Location: SoCal
Senior Member
When all else fails, Read The Fine Manual

http://download.oracle.com/docs/cd/B19306_01/network.102/b14212/advcfg.htm#i474074

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Previous Topic: TNSPING HOSTNAME gives error
Next Topic: Urgent:Getting intermitant connection to DB
Goto Forum:
  


Current Time: Thu Oct 29 03:35:22 CDT 2020