using MTS in Oracle 817 1

[markco]

If I need to use MTS for Oracle817, seem I need to do the following, pls comment and correct me.

1) add the following parameter into initSID.ora
INSTACNE_NAME=db_instance_name
SERVICE_NAMES=db_service_name
.......
MTS_DISPATCHERS="(ADDRESS=(PRCOTCOL=TCP)(HOST=XX.XX.XX.XX))(DISPATCHERS=2)"
LOCAL_LISTENER=listener_name, e.g. LISTENER

Beside, add other MTS related parameter if required.

2) Config LISTENER.ORA
Remove sid_list_listener=......... from listener.ora, such that no SID information for LISTENER.

Make LISTENER to use DB self-registry mode.

3) Config TNSNAMES.ora
Add a Net8 Config. alias "listener_name", which MUST match your LISTENER.

4) Start your listener FIRST, then start your instance and open DB, make DB self-registry.

Pls correct me. Thanks.

 

[karluk]

I had an extremely unpleasant experience with MTS on Oracle 8.0.5 about two years ago, and haven't used it since. As a result my experience probably won't be too useful. As usual, I would recommend researching the issue on Metalink. I found document 76981.996 to be quite illuminating. In it someone named Graham Hills posts his personal experience with MTS on 8.1.7. He says that all the configuration for MTS can be done in the init.ora file. If that's right, your steps 2, 3, and 4 are superfluous.