Re: MTS configuration

Check the following :
a. lsnrctl status listener_name
This should list 1 dedicated and n shared connections. If mts is not enabled, you will see only the dedicated server. Also, check for connections made, refused etc.

b. Log in to sql+ as a DBA.
select sid, username, server from v$session. The sessions with the server column as 'dedicated' have been established using dedicated servers, while session with the shared column in ( NONE, SHARED ) indicate shared connection.

c. select from the mts views ... v$mts, v$shared_server, v$dispatcher, v$queue for details on the shared servers, dispatchers, request and response queues.

d. If connections are all DEDICATED, check in the alertlog for any errors while spawning shared server, dispatche processes.

e. Check whether the client sqlnet.ora string USE_DEDICATED_SERVER=true is not on

This hould certainly cover your problems

Sridhar Subramaniam

Sunny Wong wrote in message
<01bdeac2$5ec70c20$b8ce2aca_at_mis1-184.yas.com.sg>...
>Greetings,
>I am currently trying to configurate a MTS server.
>
>Here is part of mine init.ora file.
>mts_dispatchers="ipc,3"
>mts_dispatchers="tcp,3"
>mts_max_dispatchers=10
>mts_servers=2
>mts_max_servers=10
>mts_service=yas716
>mts_listener_address="(ADDRESS=(PROTOCOL=ipc)(KEY=yas716))"
>mts_listener_address="(ADDRESS=(PROTOCOL=tcp)(PORT=1525))"
>
>How do I know that the MTS is working???
>I tried to run some reports and forms and look at the dispatcher process
>but its seem that the idle time is ticking but not the busy time.
>Thanks a lot.
Received on Tue Sep 29 1998 - 09:45:06 CDT