No there isn't.
This is my TNSNAMES.
PRUE1.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 10.20.81.78)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = PRUE1)
)
)
- dgoulet_at_vicr.com escribió: > What does your
TNSNAMES.ORA file look like? If
> there is a line in there
> '(server=dedicated)' you might as well turn MTS off.
>
> Dick Goulet
>
> ____________________Reply
> Separator____________________
> Subject: RE: How can I tell if MTS is activated
> -- more problems
> Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
> <p_rodri99_at_yahoo.es>
> Date: 11/6/2002 11:39 AM
>
> Dave,
>
> I've seen these processes (ora_S00... and
> ora_d00..) but all connections are being made
> through
> dedicated processes.
>
> Here's my configuration:
>
> mts_listener_address = "(ADDRESS=(PROTOCOL=TCP)
> (HOST=10.20.81.78) (PORT=1521))"
> mts_service = PRUE1
> mts_dispatchers = "tcp,2"
> mts_max_dispatchers = 10
> mts_servers = 6
> mts_max_servers = 100
>
>
> The listener has been started before the RDBMS:
>
> listener.ora
>
> LISTENER =
> (ADDRESS_LIST=
>
>
(ADDRESS=(PROTOCOL=tcp)(HOST=10.20.81.78)(PORT=1521))
> (ADDRESS=(PROTOCOL=ipc)(KEY=PRUE1)))
> SID_LIST_LISTENER=
> (SID_LIST=
> (SID_DESC=
> (GLOBAL_DBNAME=PRUE1)
> (SID_NAME=PRUE1)
>
> (ORACLE_HOME=/u01/app/oracle/product/8.1.7)
> )
> )
>
>
> lsnrctl services
>
> LSNRCTL for Linux: Version 8.1.7.0.0 - Production on
> 06-NOV-2002 16:40:58
>
> (c) Copyright 1998 Oracle Corporation. All rights
> reserved.
>
> Connecting to
>
(ADDRESS=(PROTOCOL=tcp)(HOST=10.20.81.78)(PORT=1521))
> Services Summary...
> PRUE1 has 2 service handler(s)
> DEDICATED SERVER established:0 refused:0
> LOCAL SERVER
> DEDICATED SERVER established:0 refused:0
> LOCAL SERVER
> The command completed successfully
>
>
> BUT the user processes are not using MTS.
>
> Why aren't they using MTS?
> What's wrong in this configuration?
>
>
> thanks for your help.
>
>
>
>
>
>
> To see how many dispatchers/shared servers are
> started
> up with the RDBMS, check the value of
> 'mts_dispatchers' and 'mts_servers' in the init.ora.
>
> You can also tell by looking in the
> alert.log(default
> location is $ORACLE_HOME/rdbms/log).
> Sample:
> PMON started
> DBWR started
> LGWR started
> RECO started
> Thu Sep 14 09:24:15 1995
> starting up 4 shared server(s) ...
> starting up 4 dispatcher(s) for network
> See Note:1012480.6 on Metastink for mor info on MTS
> Processes
>
> Dave
>
> -----Original Message-----
> Sent: Wednesday, November 06, 2002 10:59 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Oracle 8i
>
> How can I tell if MTS is activated?
>
> Which parameters should I look at? (in init.ora and
> listener.ora)
>
>
> thanks
> Pablo
>
>
>
>
> Yahoo! Messenger
> Nueva versión: Webcam, voz, y mucho más ¡Gratis!
> Descárgalo ya desde http://messenger.yahoo.es
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
> INET: p_rodri99_at_yahoo.es
>
> 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: ListGuru_at_fatcity.com (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: Farnsworth, Dave
> INET: DFarnsworth_at_Ashleyfurniture.com
>
> 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: ListGuru_at_fatcity.com (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
>
>
> Yahoo! Messenger
> Nueva versión: Webcam, voz, y mucho más ¡Gratis!
> Descárgalo ya desde http://messenger.yahoo.es
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
> INET: p_rodri99_at_yahoo.es
>
> 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: ListGuru_at_fatcity.com (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).
>
Yahoo! Messenger
Nueva versión: Webcam, voz, y mucho más ¡Gratis!
Descárgalo ya desde
http://messenger.yahoo.es
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Pablo=20Rodriguez?=
INET: p_rodri99_at_yahoo.es
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: ListGuru_at_fatcity.com (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).
Received on Wed Nov 06 2002 - 14:59:52 CST
