hi,
i am enabling used_shared_socket parameter for oracle 11g r2 database on windows 2003 machine.
i am following the doc id ID 124140.1, which states
From 10.2 onwards, The same listener port is used for communication between
server process/dispatcher and client.
Both methods require a shutdown/startup of the server.
EXAMPLE of configuration
-------------------------
Tnsnames.ora
Example_shared_socket =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =<nodename>)(PORT = 1500))
)
(CONNECT_DATA =
(SERVICE_NAME =<sid>)
)
)
Listener.ora
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <nodename>)(PORT = 1500))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = <global db name if used>)
(SID_NAME = <sid>)
)
)
i have made changes in the registry and added use_shared_socket value as true.
Do i have to make changes to my tnsnames and listener.ora files?
regards,