ORA-00101: invalid specification for system parameter MTS_DISPATCHERS - MTS prob 2004-11-19 - By arul.kumar@(protected)
Hi DBAs,
I am trying to configure MTS (8.1.7.4 on HP Unix) on one of my test instances, getting the following errors. Any suggestions please.
Thanks,
Arul.
SQL >startup
ORA-00101 (See ORA-00101.ora-code.com): invalid specification for system parameter MTS_DISPATCHERS
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ----
alert.log
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Syntax error in listener string (DESCRIPTION =
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ----
init.ora:
mts_dispatchers= "ipc,1 "
mts_dispatchers= "tcp,1 "
mts_max_dispatchers=10
mts_servers=1
mts_max_servers=10
mts_service=sidb_ri1
mts_listener_address= "(ADDRESS=(PROTOCOL=ipc)(KEY=sidb_ri1)) "
mts_listener_address= "(ADDRESS=(PROTOCOL=tcp)(KEY=sidb_ri1)) "
local_listener=LISTENER_MTS
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ----
listener.ora :
LISTENER_MTS =
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL=TCP) (HOST=147.150.108.130) (PORT=1600))
)
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ----
sqlnet.ora:
NAMES.DIRECTORY_PATH= (TNSNAMES)
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ----
tnsnames.ora:
LISTENER_MTS =
(DESCRIPTION =
(ADDRESS=(PROTOCOL=TCP)(HOST=147.150.108.130)(PORT=1600))
)
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ----
--
http://www.freelists.org/webpage/oracle-l
|
|
