Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

enabling used_shared_socket parameter

user10243788Jun 15 2010 — edited Jun 16 2010
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,
This post has been answered by Girish Sharma on Jun 16 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 14 2010
Added on Jun 15 2010
8 comments
1,190 views