I created test oracle server 11.2.0.1.0 on virtualbox.
I enable shared_server configuration as per the document.
With the tnsnames entry "(SERVER = SHARED)", I can connect to the server using the service name. The v$session shows the 'server' column as shared. Everything works fine so far.
I have client server application which connects to database server. Itermittently i see error in application log
ORA-28547: connection to server failed, probable Oracle Net admin error
So i manually tested launching sqlplus connections. I can see 20 shared server connections can be created(V$session.server column). When I launch 21st sqlplus connection it gives ORA-28547.
Parameters are set as below:
sessions is set to 400
shared_server_sessions is set to 300
circuits is default i.e not set (as suggested in the docs to avoid limiting virtual circuits)
I can see the shared server configuration working but unable to figure out why there is a limit of 20 shared server connections. Any tips will be helpful.
Thanks