Oracle8i---MTS Not working

From: Sean Zhang <sean_at_cnfei.com>
Date: Thu, 29 Apr 1999 18:56:05 GMT
Message-ID: <9X1W2.2226$p17.5906383@firenze.visi.net>

Hello, Everyone,

Our Oracle 8i Multi-Thread Server is not working, Please give me suggestions and advices.

Envrioment: Oracle 8i EE server in Sun Enterpirses 3000 with Solaris 2.6.

                      Clients: Windows95 PCs running Devepoper 2K version
2.0
                      ( SQL net 2.3.4, using a local TNSNAMES.ORA file for

connection)
Problems: Even I configured Oracle Server for MTS, it's not working because

                    when each user connects to Oracle , I can see an
additional process
                     is created for that session. Consequently when I try to
list Oracle
                     processes on the server, I got something like the
following: (sid is cnf)


                   > ps -ef |grep oracle



  oracle 13161     1  0 04:07:34 ?        0:00 ora_d000_cnf
  oracle 13163     1  0 04:07:34 ?        0:00 ora_d001_cnf
  oracle 13159     1  0 04:07:34 ?        0:00 ora_s000_cnf
  oracle 13149     1  0 04:07:33 ?        0:06 ora_dbw0_cnf
  oracle 13157     1  0 04:07:34 ?        0:00 ora_reco_cnf
  oracle 13153     1  0 04:07:34 ?        0:14 ora_ckpt_cnf
  oracle 13151     1  0 04:07:33 ?        0:13 ora_lgwr_cnf
  oracle 13147     1  0 04:07:33 ?        0:51 ora_pmon_cnf
  oracle 13155     1  0 04:07:34 ?        0:15 ora_smon_cnf
  oracle 13858     1  0 10:56:38 ?        0:00 oraclecnf (LOCAL=NO)
  oracle 13756     1  0 10:39:52 ?        0:01 oraclecnf (LOCAL=NO)
  oracle 14279     1  0 13:08:28 ?        0:01 oraclecnf (LOCAL=NO)
  oracle 14264     1  0 13:02:17 ?        0:06 oraclecnf (LOCAL=NO)
  oracle 14158     1  0 12:08:39 ?        0:00 oraclecnf (LOCAL=NO)
  oracle 14262     1  0 13:02:17 ?        0:01 oraclecnf (LOCAL=NO)
  oracle 14288     1  0 13:10:37 ?        0:01 oraclecnf (LOCAL=NO)
  oracle 14394     1  0 13:37:05 ?        0:00 oraclecnf (LOCAL=NO)
  ------------------------( a lot more oraclecnf processes)

 My configuration file <initcnf.ora> has the follwing parameters related to MTS:

       mts_dispatchers="(protocol=TCP)(disp=1)(mul=OFF)(pool=OFF)"
       mts_max_dispatchers=5
       mts_serves=1
       mts_max_servers=20

 And the listener name is : LISTENER the PORT is 1522 ( the only parameter NOT Default).

Suggestions sought: Becuase Oracle started with dispatchers, I guess the problem

    is that the dispatchers not registered with Oracle. But when I tried     to change the parameter mts_dispatchers to:

mts_dispatchers="(protocol=TCP)(disp=1)(list=LISTENER)(mul=OFF)(pool=OFF)"   The database can't start saying" Invalid initializaition specifications for MTS".

Any advices and suggestions are greatly appreciated.

Sean Zhang
mailto:sean_at_cnfei.com Received on Thu Apr 29 1999 - 13:56:05 CDT