Re: MTS configuration

The following note boils it down real well:

Note:126078.1

4. Configuring the Multi Threaded Server:

   Initialization parameters to be set:

• LOCAL_LISTENER=<listenername>: This parameter is set in the INIT.ORA file. This specifies a single address or an address list of net8 listeners defined in the tnsnames.ora.
  • MTS_SERVICE=<Servicename>: Specifies the name of the service you want to associate with the dispatcher. The parameter is specified in the init.ora file. The service name specified can be used in the connect string.
  • MTS_DISPATCHERS="(PROTOCOL=TCP)(DISPATCHERS=2)": To enable various attributes for each dispatcher. The parameter is specified in the init.ora file. Changes can be made by specifying following values in the parameter: PROTOCOL: The protocol for which the dispatchers will generate a listing ADDRESS: The network address of the end point dispatchers to start DESCRIPTION: The network description DISPATCHERS: The initial number of dispatchers to start SESSIONS: The maximum number of network sessions per dispatchers LISTENER: The network name of an address or address list of the listeners SERVICE: The service name that the dispatchers register with the listeners POOL: To enable connection pooling MULTIPLEX: to enable connection concentration CONNECTIONS: Maximum number of network connections to allow for each dispatcher
    • MTS_MAX_DISPATCHERS= <number>: Specified in the init.ora file. This parameter gives the maximum number of dispatcher processes allowed to run simultaneously. This equal to maximum number of concurrent sessions divided by connections per dispatcher.
  • MTS_SERVERS= <number>: Specifies the number of (shared) server processes that you want to create when an instance is started up.
  • MTS_MAX_SERVERS=<number>: specifies the maximum number of (shared) server processes that may run simultaneously.

On Mon, Aug 05, 2002 at 02:58:24PM -0800, David Jones wrote:
> Dear Listers:
>
> Does anyone have the configuration example on how to setup MTS server for
> Oracle 8.1.7 ?
> Although I've RTFM but I still confused.
>
> Any insights will be highly appreciated.
>
> The following are my init.ora, listener.ora & tnsnames.ora
> ==========================================================
> init.ora
> ==========================================================
> db_name = BDB1
> instance_name = BDB1
> service_names = BDB1
>
>
> control_files = ("/u01/oradata/BDB1/control01.ctl",
> "/u01/oradata/BDB1/control02.ctl")
>
> # db_file_multiblock_read_count = 8 #
> SMALL
> # db_file_multiblock_read_count = 16 #
> MEDIUM
> # db_file_multiblock_read_count = 32 #
> LARGE
>
> db_block_buffers = 8192 # INITIAL
> # db_block_buffers = 100 #
> SMALL
> # db_block_buffers = 550 #
> MEDIUM
> # db_block_buffers = 3200 #
> LARGE
>
> shared_pool_size = 50000000 # INITIAL
> # shared_pool_size = 3500000 #
> SMALL
> # shared_pool_size = 5000000 #
> MEDIUM
> # shared_pool_size = 9000000 #
> LARGE
>
> java_pool_size = 20971520 # INITIAL
>
> log_checkpoint_interval = 10000
> log_checkpoint_timeout = 1800
>
> processes = 100 # INITIAL
> # processes = 50 #
> SMALL
> # processes = 100 #
> MEDIUM
> # processes = 200 #
> LARGE
>
> log_buffer = 163840 # INITIAL
> # log_buffer = 32768 #
> SMALL
> # log_buffer = 32768 #
> MEDIUM
> # log_buffer = 163840 #
> LARGE
>
> # audit_trail = false # if you want auditing
> # timed_statistics = false # if you want timed statistics
> # max_dump_file_size = 10000 # limit trace file size to 5M each
>
> # Uncommenting the lines below will cause automatic archiving if archiving
> has
> # been enabled using ALTER DATABASE ARCHIVELOG.
> log_archive_start = true
> log_archive_dest_1 = "location=/u01/archive/BDB1"
> log_archive_format = BDB1_%t_%s.arc
>
> # If using private rollback segments, place lines of the following
> # form in each of your instance-specific init.ora files:
> rollback_segments = ( r01, r02, r03, r05, r06, r07, r08 )
>
> # If using public rollback segments, define how many
> # rollback segments each instance will pick up, using the formula
> # of rollback segments = transactions / transactions_per_rollback_segment
> # In this example each instance will grab 40/10 = 4:
> # transactions = 40
> # transactions_per_rollback_segment = 10
>
> # Global Naming -- enforce that a dblink has same name as the db it
> connects to
> global_names = TRUE
>
> # Edit and uncomment the following line to provide the suffix that will be
> # appended to the db_name parameter (separated with a dot) and stored as the
> # global database name when a database is created. If your site uses
> # Internet Domain names for e-mail, then the part of your e-mail address
> after
> # the '@' is a good candidate for this parameter value.
> # db_domain = us.acme.com # global database name is db_name.db_domain
>
> # Uncomment the following line if you wish to enable the Oracle Trace
> product
> # to trace server activity. This enables scheduling of server collections
> # from the Oracle Enterprise Manager Console.
> # Also, if the oracle_trace_collection_name parameter is non-null,
> # every session will write to the named collection, as well as enabling you
> # to schedule future collections from the console.
> # oracle_trace_enable = true
>
> # define directories to store trace and alert files
> background_dump_dest = /opt/oracle/admin/BDB1/bdump
> core_dump_dest = /opt/oracle/admin/BDB1/cdump
> #Uncomment this parameter to enable resource management for your database.
> #The SYSTEM_PLAN is provided by default with the database.
> #Change the plan name if you have created your own resource plan.
> # resource_manager_plan = system_plan
> user_dump_dest = /opt/oracle/admin/BDB1/udump
>
> db_block_size = 8192
> db_file_multiblock_read_count = 32
>
> remote_login_passwordfile = exclusive
>
> os_authent_prefix = ""
>
> # The following parameters are needed for the Advanced Replication Option
> job_queue_processes = 1
> job_queue_interval = 60
>
> mts_servers = 2
> mts_dispatchers =
> "(PROTOCOL=TCP)(DISPATCHERS=3)(LISTENER=(ADDRESS=(PROTOCOL=TCP)(HOST=bluejay)(PORT=1523)))"
> large_pool_size = 20971520
> #mts_dispatchers = "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
> # Uncomment the following line when your listener is configured for SSL
> # (listener.ora and sqlnet.ora)
> # mts_dispatchers = "(PROTOCOL=TCPS)(PRE=oracle.aurora.server.SGiopServer)"
> #mts_dispatchers="(protocol=tcp)(dispatchers=2)"
>
>
> compatible = "8.1.7"
> sort_area_size = 65536
> sort_area_retained_size = 65536
>
> ==========================================================
> listener.ora
> ==========================================================
> # LISTENER.ORA Network Configuration File:
> /opt/oracle/product/8.1.7/network/admin/listener.ora
> # Generated by Oracle configuration tools.
>
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = bluejay)(PORT = 1523))
> )
> )
> (DESCRIPTION =
> (PROTOCOL_STACK =
> (PRESENTATION = GIOP)
> (SESSION = RAW)
> )
> (ADDRESS = (PROTOCOL = TCP)(HOST = bluejay)(PORT = 2481))
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = /opt/oracle/product/8.1.7)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = BDB1)
> (ORACLE_HOME = /opt/oracle/product/8.1.7)
> (SID_NAME = BDB1)
> )
> )
>
>
> LISTENER_MTS =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = bluejay)(PORT = 1523))
> )
> )
> )
>
> SID_LIST_LISTENER_MTS =
> (SID_LIST =
> (SID_DESC =
> (GLOBAL_DBNAME = BDB1)
> (ORACLE_HOME = /opt/oracle/product/8.1.7)
> (SID_NAME = BDB1)
> )
> )
> ==========================================================
> tnsnames.ora
> ==========================================================
> # TNSNAMES.ORA Network Configuration File:
> /opt/oracle/product/8.1.7/network/admin/tnsnames.ora
> # Generated by Oracle configuration tools.
>
> BDB1 =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = bluejay)(PORT = 1523))
> (CONNECT_DATA =
> (SID_NAME = BDB1)
> )
> )
>
> INST1_HTTP =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = bluejay)(PORT = 1523))
> )
> (CONNECT_DATA =
> (SERVER = SHARED)
> (SERVICE_NAME = BDB1)
> (PRESENTATION = http://admin)
> )
> )
>
> EXTPROC_CONNECTION_DATA =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
> )
> (CONNECT_DATA =
> (SID = PLSExtProc)
> (PRESENTATION = RO)
> )
> ============================================================
>
> David Jones
> ITResource
>
>
> _________________________________________________________________
> Send and receive Hotmail on your mobile device: http://mobile.msn.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: David Jones
> INET: djones1688_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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).

-- 
===============================================================
Ray Stell   stellr_at_vt.edu     (540) 231-4109     KE4TJC    28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: stellr_at_cns.vt.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).