Oracle Database Discussions

Hi,
I am getting this error at standby in this time.
LSNRCTL> start
Starting tnslsnr: please wait...

TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Production
System parameter file is C:\oracle\product\10.1.0\db_1\network\admin\listener.or
a
Log messages written to C:\oracle\product\10.1.0\db_1\network\log\listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROCipc)
))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.17.150)(PO
RT=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...

LSNRCTL>

Listener.ora entry as below:
--------------------------------------
#listener.ora Network Configuration File: C:\oracle\product\10.1.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools
# ON MANOJ
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS=(PROTOCOL=ipc)(KEY=ANYTHING))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.17.150)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = MANOJ)
(ORACLE_HOME = C:\oracle\product\10.1.0\db_1)
(SID_NAME = MANOJ)
)
)
# ON STAN
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS=(PROTOCOL=ipc)(KEY=ANYTHING))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.17.151)(PORT = 1521))
)
)
SID_LIST_LISTENER
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = MANOJ)
(ORACLE_HOME = C:\oracle\product\10.1.0\db_1)
(SID_NAME = STAN)
)
)


TNS.ora entry as below:
---------------------------------
# tnsnames.ora Network Configuration File: C:\oracle\product\10.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
#ON STAN

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.17.151)(PORT = 1521))
)
)

STAN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.17.151)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID_NAME=STAN)
)
)

# ON MANOJ
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.17.150)(PORT = 1521))
)
)

MANOJ =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.17.150)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MANOJ)
)
)

Pleas help us for resolving this issue.

Thanks,Manoj

Edited by: Manoj K Singh on Mar 8, 2011 12:12 AM