Hi,
Got dispatchers failing to start :
init.ora file contains
mts_servers = 1
mts_max_servers = 5
MTS_DISPATCHERS =
"(ADDRESS=(PROTOCOL=TCP)(HOST=obelix)(PORT=1526))(dispatchers=5)"
MTS_DISPATCHERS =
"(ADDRESS=(PROTOCOL=TCP)(HOST=obelix)(PORT=1521))(dispatchers=5)"
MTS_MAX_DISPATCHERS = 20
MTS_SERVICE = MON
MTS_LISTENER_ADDRESS="(ADDRESS=(PROTOCOL=TCP)(HOST=obelix)(port=1521))
"
local_listener="(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=obelix)(POR
T=1521)))"
but still getting on startup
Tue Aug 31 13:51:48 2004
dispatcher 'D004' encountered error setting up listening port
Tue Aug 31 13:51:48 2004
dispatcher 'D006' encountered error setting up listening port
Tue Aug 31 13:51:48 2004
dispatcher 'D007' encountered error setting up listening port
Tue Aug 31 13:51:48 2004
dispatcher 'D008' encountered error setting up listening port
Tue Aug 31 13:51:48 2004
dispatcher 'D009' encountered error setting up listening port
Tue Aug 31 13:52:51 2004
found dead dispatcher 'D001', pid = (11, 2)
found dead dispatcher 'D002', pid = (12, 2)
found dead dispatcher 'D003', pid = (13, 2)
found dead dispatcher 'D004', pid = (14, 2)
found dead dispatcher 'D006', pid = (16, 2)
found dead dispatcher 'D007', pid = (17, 2)
found dead dispatcher 'D008', pid = (18, 2)
found dead dispatcher 'D009', pid = (19, 2)
Tue Aug 31 13:52:52 2004
dispatcher 'D001' encountered error setting up listening port
Tue Aug 31 13:52:52 2004
dispatcher 'D002' encountered error setting up listening port
Tue Aug 31 13:52:52 2004
dispatcher 'D003' encountered error setting up listening port
Tue Aug 31 13:52:52 2004
dispatcher 'D004' encountered error setting up listening port
Tue Aug 31 13:52:52 2004
dispatcher 'D006' encountered error setting up listening port
Tue Aug 31 13:52:52 2004
dispatcher 'D007' encountered error setting up listening port
Tue Aug 31 13:52:52 2004
dispatcher 'D008' encountered error setting up listening port
Tue Aug 31 13:52:52 2004
dispatcher 'D009' encountered error setting up listening port
listener.ora contains
LISTENER =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY= A))
(ADDRESS= (PROTOCOL= IPC)(KEY= N))
(ADDRESS= (PROTOCOL= IPC)(KEY= MON))
(ADDRESS= (PROTOCOL= IPC)(KEY= TXOPS))
(ADDRESS= (PROTOCOL= TCP)(Host= obelix)(port=1521))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =?
(GLOBAL_DBNAME= obelix)
(ORACLE_HOME= /opt/app/oracle/product/8.0.5)
(SID_NAME = A)
)?
(SID_DESC =?
(GLOBAL_DBNAME= obelix)
(ORACLE_HOME= /opt/app/oracle/product/8.0.5)
(SID_NAME = N)
)?
(SID_DESC =
(GLOBAL_DBNAME= obelix)
(ORACLE_HOME= /opt/app/oracle/product/8.0.5)
(SID_NAME = MON)
)
(SID_DESC =?
(GLOBAL_DBNAME= obelix)
(ORACLE_HOME= /opt/app/oracle/product/8.0.5)
(SID_NAME = TXOPS)
)?
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
I've searched online, on metalink, and cannot find a down to earth
example. Can someone please help me set this up ?
Cheers
GJC
==================================================================
This e-mail and its contents are subject to the Telkom SA Limited
e-mail legal notice available at
http://www.telkom.co.za/TelkomEMailLegalNotice.PDF
Oracle LazyDBA home page