To lock Oracle into using a single port for operation, add a USE_SHARED_SOCKET key to the Registry as described in the steps below. This key tells Oracle to use port 1521 instead of using random ports after the initial communication connection (that is, the first time the database link is connected).
-
You do not need to create this key if you are using Workshare within a single network domain (LAN) because you will not have a port availability problem.
-
You must add this USE_SHARED_SOCKET key to the Registry on the Oracle server and on each Oracle client computer.