| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle8i---MTS Not working
Sean
Why have you got MUL=OFF? To turn on MTS, you need this set to ON. Try changing it and see what happens.
HTH. Pete
Sean Zhang wrote:
> 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
--
Regards
Pete
Pete Sharman Email: psharman_at_us.oracle.com Project Manager Phone: +1.650.607.0109 (int'l) Worldwide Internal Services Education (650)607 0109 (local)Oracle Corporation
SQL> select standard_disclaimer, witty_remark 2 from company_requirements;
Opinions are mine and do not necessarily reflect those of Oracle Corporation
"Controlling application developers is like herding cats."
Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!"
Bruce Pihlamae, long term ORACLE DBA
Received on Thu Apr 29 1999 - 15:26:48 CDT
 |
 |