RE: Shared Server
- From: "Nick Yonko" <nyonko@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 5 Apr 2007 19:15:59 -0700
I have solved my own problem and thought the list would like to know.
I am running Oracle 10gR2 rel. 3 on SLES 9. I am unsure why, however, the
default value for the local_listener parameter, which is
"(ADDRESS_LIST=(Address=(Protocol=TCP)(Host=localhost)(Port=1521))
(Address=(Protocol=IPC)(Key=DBname)))" would not register my dispatcher with
my listener. I modified 'localhost' to the FQDN of the machine and voila -
I was getting shared connections in v$session. I am not sure why
'localhost' didn't work, but I will work on that one next.
I also have the value 'NONE' in the SERVER field of the v$session view,
however, that is only for sessions that already have a 'SHARED' value in the
SERVER field and are making multiple connections.
_____
From: Nick Yonko [mailto:nyonko@xxxxxxx]
Sent: Thursday, April 05, 2007 8:50 AM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: Shared Server
In the Oracle documentation, it indicates that the only parameter needed for
enabling share servers is to set the 'SHARED_SERVERS' parameter to a non
zero value. If the 'DISPATCHERS' parameter is neglected, Oracle will
instantiate 1 dispatcher by default to handle shared server traffic.
My SHARED_SERVER parameter is set to '2' and my DISPATCHERS parameter is set
to "(protocol=TCP)". Nonetheless, I cannot connect to the server with
anything but dedicated connections (verified by querying the v$sessions
view).
I have nothing in my sqlnet.ora file or my tnsnames.ora file that would
force a dedicated connection to the server.
Other related posts:
