-
Had anyone encountered this before?
I set the MTS parameters in INIT.ORA as in the following:
LOCAL_LISTENER = LISTENER
MTS_SERVICE = ORCL7
MTS_DISPATCHERS ="(protocol=tcp) (dispatchers=2)"
MTS_MAX_DISPATCHERS = 2
MTS_SERVERS = 1
MTS_MAX_SERVERS = 6
When I try to start up the database, I received this error:
SVRMGR> startup
ORA-00101: invalid specification for system parameter MTS_DISPATCHERS.
The only way I can start the database is when I commented out these parameters. But how can I startup with them?
DB running on Win2k and it's version 8.1.7. Thanks in advance!!
-
the mts_dispatchers should be like this:
mts_dispatchers = "(ADDRESS=(protocol=TCP)) (connections=2) (dispatchers=2)"
HTH
-dharma
-
Tks. I did a search in the web and found that this is quite common a problem. If anyone out there had solved this problem before, can u please give me a hand? Thank u!!
-
What dharma had posted would work fine for the dispatchers. Did you try that in your init.ora file. For the time being comment out the LISTENER, if you have only one listener on your server. One other thing is that you might want to have atleast 2 servers when you have 2 dispatchers.
Try them and let us know the result.
Sam
-
Hi Sam,
What if I have more than 1 listeners and 2 databases running in the same system?
I followed your instructions and commentted out the listener, error still persists.
Also, since I am running the database against 1 server, instead of adding another server, I reduce the dispatchers to one like so:
MTS_DISPATCHERS ="(ADDRESS=(protocol=tcp) (connections=2) (dispatchers=1)"
I received ora error msg :
ORA-01078 failure in processing system parameters
Cause: Failure during processing of initialization parameters during system
startup.
Action: Further diagnostic information should be in the error stack. -- there's no error stack
Thanks again for the help!!
-
I dont know if u saw the brackets properly if u dont use them properly u'll definitely end up in an error msg. tell us if you used as this- exactly
mts_dispatchers = "(ADDRESS=(protocol=TCP)) (connections=2) (dispatchers=2)"
-dharma
