Thread: MTS
-
Hi Friends,
Greetings.
I am trying to setup the MTS on windows 2000 oracle 8.1.7. In Init.ora i setup the parameters:
MTS_SERVERS=3
MTS_MAX_SERVERS=8
MTS_DISPATCHERS="(PROTOCOL=TCP)(DISPATCHERS=2)"
MTS_MAX_DISPATCHERS=4
MTS_SERVICE="TEST"
MTS_LISTENER_ADDRESS ="(ADDRESS=(PROTOCOL=TCP)(PORT=1521)(HOST=MSFT-MAN)"
I am getting an ERROR:
SVRMGRL>STARTUP
Invalid specification for system parameter MTS_DISPATCHERS.
Please look into the parameters and correct me.
Thanks
Ravi
ravi
-
Can you do a tnsping service_name on the server? Could you give us the complete error message?
Sam
Thanx
Sam
Life is a journey, not a destination!
-
Hi Sam
The error message is :
ORA-00101: invalid specification for system parameter MTS_DISPATCHERS
Thanks
Ravi
ravi
-
tnsping is working fine
TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 09-O
01 15:14:29
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=msft-man)(PORT=1521))
OK (380 msec)
Thanks
Ravi
ravi
-
mts
MTS_SERVERS=3
MTS_MAX_SERVERS=8
MTS_DISPATCHERS="(PROTOCOL=TCP)(DISPATCHERS=2)"
MTS_MAX_DISPATCHERS=4
MTS_SERVICE="TEST"
MTS_LISTENER_ADDRESS ="(ADDRESS=(PROTOCOL=TCP)(PORT=1521)(HOST=msft-man)"
THE ERROR IS:
SVRMGR> startup
ORA-00101: invalid specification for system parameter MTS_DISPATCHERS
tnsping is OK
any suggestions please
Ravi
ravi
-
Could you put the following in the place as in order, and try starting up
Code:
MTS_DISPATCHERS="(ADDRESS=(PROTOCOL=TCP)(HOST=Hostname)(SERVICE=SID))(DISPATCHERS=2)"
MTS_MAX_DISPATCHERS=4
MTS_SERVERS=3
MTS_MAX_SERVERS=8
Sam
Thanx
Sam
Life is a journey, not a destination!
-
do u have this parameter in the init.ora
mts_listener_address="(ADDRESS=(PROTOCOL=ipc)(KEY=XXXXXX))"
if you do not have try with that
sonofsita
http://www.ordba.net
-
HI GUYS
WHEN I TRIED THIS I AM GETTING THE ERROR:
MTS_DISPATCHERS="(ADDRESS=(PROTOCOL=TCP)(HOST=msft-man)(SERVICE=TEST))(DISPATCHERS=2)"
MTS_MAX_DISPATCHERS=4
MTS_SERVERS=3
MTS_MAX_SERVERS=8
MTS_LISTENER_ADDRESS ="(ADDRESS=(PROTOCOL=TCP)(PORT=1521)(HOST=msft-man)"
SVRMGR> STARTUP
ORA-00101: invalid specification for system parameter MTS_DISPATCHERS
ORA-00102: network protocol (ADDRESS=(PROTOCOL=TCP)(HOST=msft-man)(SERVICE=TEST)
) cannot be used by dispatchers
Thanks
Ravi
ravi
-
if you are on unix box and not using sco then this shall help you:
Note:1005046.6
Subject: ORA-00101 AND ORA-00102 USING SQL*NET TCPIP ON A UNIX PLATFORM
Type: PROBLEM
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 09-AUG-1994
Last Revision Date: 09-JUL-2001
Problem Description:
====================
You are trying to start an Oracle7 database using a UNIX platform; using MTS
(multi-threaded server) on SQL*Net V2. You are getting error messages
ORA-00101 and ORA-00102.
Problem Explanation:
====================
ORA-00101: "invalid specification for system parameter mts_dispatchers"
Cause: The syntax for the "mts_dispatchers" parameter is incorrect.
Action: Refer to the manual for correct syntax.
ORA-00102: "network protocol %s cannot be used by dispatchers"
Cause: The network specified in "mts_dispatchers" doesn't have the
functionalities required by the dispatchers.
Action: Refer to the manual on network protocols supported by the
dispatchers.
Search Words:
=============
ORA-101 ORA-102
Solution: DESIRED PROTOCOL MUST BE PROPERLY LINKED
Solution Description:
====================
Verify that the Desired Protocol has been properly linked.
To relink:
1. Login as oracle
2. cd $ORACLE_HOME/rdbms/lib
3. make -f oracle.mk install
Note: You may also have to relink other product executables.
1. cd $ORACLE_HOME//lib
2. make -f .mk install
sonofsita
http://www.ordba.net
-
mts
Thank you very much for the info friends. I will get back to u if i come across any problem again.
Thanks
Ravi
ravi
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|