i am trying to configure a database into shared server from dedicated server architecture,i had done that by using DBCA
shared_servers=3
and dispatchers=3;
and after configuration i have restarted the database
but i have observed that sys as sysdba then this user is connected as shared and all other users are connected as None SQL> select username,server
2 from v$session;
but when i chaged the tnsnames.ora file
From
NCL.NCTEX.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = shakeel)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = nishat)
)
)
To
NCL.NCTEX.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = shakeel)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = nishat)(SERVER=DEDICATED) )
)
And i observed that all user are connected as DEDICATED
Bookmarks