>From: muhammad.salman.[Email Address Removed] [Email Address Removed] MTS Configuration Problem.
>Date: Fri, 29 Mar 2002 14:18:49 +0500
>
>Bismillah
>
>Hi All !
>
>i am testing MTS on test servers and getting strange result .
>
>i think there is some misconfiguration in init<sid>.ora , so your advise
>will be highly appreciated.
>
>excerpt from init<sid>.ora :
>
>$ tail -10 $ORACLE_HOME/dbs/initv72.ora
>
> mts_dispatchers="ipc,1"
> mts_dispatchers="tcp,1"
> mts_max_dispatchers=10
> mts_servers=1
> mts_max_servers=10
> mts_service=v72
> mts_listener_address="(ADDRESS=(PROTOCOL=ipc)(KEY=v72))"
> mts_listener_address="(ADDRESS= (PROTOCOL= tcp)(Host= 10.95.8.53)(Port=
>1521))"
>
>sun20>select name,network,status,
> 2 (busy /(busy + idle)) * 100 "% of time busy"
> 3 from v$dispatcher ;
>
>NAME NETWORK STATUS % of time
>busy
>----- ---------------------------------------- ----------------
>--------------
>D000 (ADDRESS=(PARTIAL=YES)(PROTOCOL=ipc)) WAIT
>0
>D001 (ADDRESS=(PARTIAL=YES)(PROTOCOL=tcp)) WAIT
>.003054715
>
>sun20>ALTER SYSTEM SET MTS_DISPATCHERS = 'tcp,0';
>
>System altered.
>
>sun20> select name,network,status,
> 2 (busy /(busy + idle)) * 100 "% of time busy"
> 3* from v$dispatcher
>sun20>
>sun20>/
>
>NAME NETWORK STATUS % of time
>busy
>----- ---------------------------------------- ----------------
>--------------
>D000 (ADDRESS=(PARTIAL=YES)(PROTOCOL=ipc))
>0
>D001 (ADDRESS=(PARTIAL=YES)(PROTOCOL=tcp)) WAIT
>.003455722
>
><<<<<<<<<<<< SEE ipc dispatcher vanished instead of tcp ???? why ?
>
>sun20>ALTER SYSTEM SET MTS_DISPATCHERS = 'tcp,2';
>
>System altered.
>
>sun20>select name,network,status,
> 2 (busy /(busy + idle)) * 100 "% of time busy"
> 3 from v$dispatcher ;
>
>NAME NETWORK STATUS % of time
>busy
>----- ---------------------------------------- ----------------
>--------------
>D000 (ADDRESS=(PARTIAL=YES)(PROTOCOL=ipc)) WAIT
>0
>D001 (ADDRESS=(PARTIAL=YES)(PROTOCOL=tcp)) WAIT
>.00549212
>D002 (ADDRESS=(PARTIAL=YES)(PROTOCOL=ipc)) WAIT
>0
>
><<<<<<<<<<<< SEE ipc dispatcher increased instead of tcp ???? why ?
>
>in addition i am unable to disable MTS using :
>
>ALTER SYSTEM SET MTS_DISPATCHERS = 'tcp,0';
>ALTER SYSTEM SET MTS_DISPATCHERS = 'ipc,0';
>WHY ?
>
>Best Regards
>
>Your DBA
>
>Salman Faheem
>---------------------------------------------------------------------------
>This message (including any attachments) is confidential and may be
>privileged. If you have received it by mistake please notify the sender by
>return e-mail and delete this message from your system. Any unauthorised
>use or dissemination of this message in whole or in part is strictly
>prohibited. Please note that e-mails are susceptible to change. ABN AMRO
>Bank N.V. (including its group companies) shall not be liable for the
>improper or incomplete transmission of the information contained in this
>communication nor for any delay in its receipt or damage to your system.
>ABN AMRO Bank N.V. (or its group companies) does not guarantee that the
>integrity of this communication has been maintained nor that this
>communication is free of viruses, interceptions or interference.
>---------------------------------------------------------------------------
>




(sianikuri)


_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com

Oracle LazyDBA home page