We have a problem setting up the shared server it seems. The initialization parameters as queried from 'show parameter' are as follows:
This, as per theory enables the shared server. But all the users are getting connected only as dedicated. We use localnaming method and the TNSNAMES.ORA file contents are as follows :
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 10.10.10.1)
(Port = 1521)
(CONNECT_DATA = (SERVICE_NAME = MYDS)
When v$session is queried, we see that 'server' column shows DEDICATED.