Re: MTS not workin ??

On 18 Aug 2003 14:10:45 -0700, ibrahim.dogan_at_lowes.com (Ibrahim DOGAN) wrote:

>I configured the MTS by changing the following init.ora params:
>
>NAME NEW VALUE VALUE
>======== ==================
>mts_dispatchers (PROTOCOL=TCP)(DISPATCHERS=3)(CONNECTIONS=100)
> (LISTENER= (ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)
> (PORT=1521) (HOST=testhost))))
>mts_servers 5
>mts_max_servers 10
>mts_max_dispatchers 10
>mts_sessions 33
>mts_circuits 38
>mts_service PRACTICE
>
>Server starts up fine and i see ora_s00x_PRACTICE processes but i
>can't get a shared connection in v$sessions no matter what i do..
>when i connect to server, the connections show up as 'dedicated' in
>v$session.server column...
>
>when i add 'SERVER=SHARED' to tnsnames.ora of client box and try to
>connect, it gives error like 'server type not found'...
>
>so it seems oracle is still cofigured as dedicated server..
>
>where do i go wrong?
>
>thanks in advance
>i.d.

You did bounce the listener? What does lsnrctl services tell you? You should have the dispatchers listed!

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Aug 18 2003 - 16:22:28 CDT