If you have not already installed Oracle, use the instructions under Oracle Installation and Configuration in the Smart P&ID Installation and Upgrade Help to install and configure your database, then complete the following steps to configure your Oracle database for Workshare.
-
Create a global name for your database, if it was not created during database installation. See Enable Oracle Global Naming.
-
Add a USE_SHARED_SOCKET registry key to HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 to lock Oracle into using a single port. This key tells Oracle to use port 1521 for all Oracle communications to and from the database in the DMZ or VPN environment instead of using random ports after the initial communication connection (that is, the first time the database link is connected). See Lock Oracle into Using a Static Port.
-
Create the database link from the satellite database server to the host database server. See Create the Database Link.