Connecting to different SPMS Database using different TNS

It is now possible for SPMS Application Client to easily connect to different SPMS Databases using different Database TNS Names by creating a new Database entry in the local OHCSecurity.par file using a different Database TNS Name from the actual Database TNS Name used in the SPMS Database Server. With this, the SPMS Application Client can connect to the SPMS Database using a TNS Name different from the actual Database TNS Name used in the SPMS Database Server.

Adding new Database TNS to the Local OHCSecurity.par

Note:

For each local Windows user that runs SPMS application, you need to perform the below steps to ensure the new entry for the Windows user is added to the local OHCSecurity.par.

1. Using the Windows Administrative privileges, run the command “OHC Tools.exe” /m.

2. On the OHC Tools Main screen, click the Create New Connection button to create a new Database entry in the local OHCSecurity.par file using a different Database TNS Name

3. At the Create New Connection window, enter the following:

   • New Connection: The new DB TNS Name.

   • Current Connection: Existing DB TNS Name.

   • Database Password: Current DB Password.

4. After clicking the Login button, the SPMS User Authorization form appears.

5. You must authorize using the SPMS Login credential to create a new Database entry to the local OHCSecurity.par file using a different Database TNS Name.

6. After the process completes, you can now connect to the same SPMS Database using the new Database TNS Name.