Re: Oracle8i---MTS Not working

Hi Sean
A few remarks:
1 please verify there is no line
use_dedicated_server = ON
in your sqlnet.ora on the client
2 please verify mts is running by issuing the lsnrctl services command from the server. It should come back with two services as you can't stop the dedicated server.
3 As far as I know, if you have two different port numbers in your tnsnames.ora or listener.ora, it will use the first one. The problem might be caused by the non default port number. If these suggestions don't help, could you post your tnsnames.ora, listener.ora, sqlnet.ora?

Hth,

Sybrand Bakker, Oracle DBA
Sean Zhang wrote in message <9X1W2.2226$p17.5906383_at_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 - 14:31:34 CDT