MTS not workin ??

From: Ibrahim DOGAN <ibrahim.dogan_at_lowes.com>
Date: 18 Aug 2003 14:10:45 -0700
Message-ID: <33634314.0308181310.48d16bfd@posting.google.com>

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. Received on Mon Aug 18 2003 - 16:10:45 CDT