On offline suggestion seemd to have corrected the error
Apparently it was a combination of me removing
MTS_LISTENER_ADDRESS= ("1521")
And removing the quotes from the sid
MTS_SERVICE="MYSID"
The db started, I will begin querring the V$
Im wondering if I need MTS_LISTENER_ADDRESS= ("1521") ???
Also what are you huys using for a connection string ;-> ???
This is what the docs showed and what I have rite now althouigh Im
getting a tns error....
[connect.bat]
SQLPLUSW bob/spiderman@\
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(NODE=myserver)\
(OBJECT=mts7)) (CONNECT_DATA=(SID=mysid)))
Pause
Thanks!!
Bob
>
> I cant seem to get the syntax correct on the
> MTS_DISPATCHERS= in the initSID.ora It seems no matter what I
> use I get a
> ORA-00101: invalid specification for system parameter
> MTS_DISPATCHERS (last 2 lines) When I try to restart the db
> from svrmgrl
>
> Ive checkd all online docs and even copied and pasted the
> syntax to no avail
> http://storacle.princeton.edu:9001/oracle8-doc/server.805/a583
97/ch4.htm
#1320
As well as a thouro search of Google...
MTS_SERVICE="MYSID"
MTS_MAX_DISPATCHERS=20
MTS_MAX_SERVERS=20
MTS_LISTENER_ADDRESS= ("1521")
#MTS_SERVERS=5
#MTS_DISPATCHERS = "TCP, 2"
MTS_DISPATCHERS = "(PROTOCOL=TCP)(DISPATCHERS=2)"
If I comment the MTS_DISPATCHERS the db will start, left uncommented I
get the 101 error
Thanks
bob
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bob Metelsky
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from). You may also send the HELP
command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bob Metelsky
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
