| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: MTS configuration
In your init.ora change the following parameter:
mts_dispatchers =
"(PROTOCOL=TCP)(DISPATCHERS=3)"
In your listener.ora change the following parameter:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = EXTPROC)
)
(ADDRESS =
(PROTOCOL = TCP)
(HOST = bluejay)
(PORT = 1523)
)
)
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = bluejay)(PORT = 2481))
)
I don't think you need LISTENER_MTS and SID_LIST_LISTENER_MTS in listener.ora.
In your tnsnames.ora BDB1 entry should be:
BDB1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bluejay)(PORT = 1523)
)
)
(CONNECT_DATA =
(SID = BDB1)
)
)
and your EXTPROC_CONNECTION_DATA entry should be:
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)
)
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
Be careful with parentheses. For every "open paren," there should be a corresponding "close paren."
HTH,
Gerardo
-----Original Message-----
Sent: Monday, August 05, 2002 3:58 PM
To: Multiple recipients of list ORACLE-L
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
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 addressafter
# 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
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 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = bluejay)(PORT = 1523))
)
(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)
)
)
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
-- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Molina, Gerardo INET: Gerardo.Molina_at_schwab.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 - 19:58:20 CDT
 |
 |