Oracle-L: MTS configuration

From: David Jones <djones1688_at_hotmail.com>
Date: Mon, 05 Aug 2002 14:58:24 -0800
Message-ID: <F001.004ABC18.20020805145824@fatcity.com>

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).

Received on Mon Aug 05 2002 - 17:58:24 CDT