While installing an Enforce server in a two-tier / tree-tier environment. You have a working connection to a compatible Oracle database server and Oracle Client installed in Enforce server. However, when you run the Enforce.msi installation, you receive an error.
in installation logs:
Product: Symantec Data Loss Prevention 15.5 Enforce Server -- Error 1723. There is a problem with this Windows Installer package. A DLL required for this install to complete could not be run. Contact your support personnel or package vendor. Action validateOracleConfiguration, entry: validateOracleConfiguration, library: C:\Windows\Installer\MSI9973.tmp
Oracle 12c Standard Edition
Oracle Client 12c is installed on Enforce server
This solution assumes that Oracle Client has been installed by the Administrator and proper bit version was chosen.
Window Environmental variables to support the Oracle platform needs to be configured.
The following instructions describe how to configure MS Windows environmental variables to support the Oracle platform:
Set ORACLE_HOME environmental variable
1. Open Windows Explorer and navigate to the following path:
Highlight the entire path, right mouse button click and select the option to copy.
2. RIGHT mouse button click on the start button in the bottom left corner
3. Click on the System menu option.
4. When the basic system information is displayed, click on the Advanced system settings option
5. Then click on the Environment Variables Button
6. Click on the “New…” button for System variables
7. Set the Variable name to be ORACLE_HOME Paste the path copied earlier into the variable value: Field
8. Click on the OK button, and you will now observe that a new system variable called ORACLE_HOME has been added
Create/Update Path for System variable to include Oracle Directories
1. If there is no System variable called “Path” click on the “New…” button. Otherwise, click on the “Edit…” button to modify the existing entry.
2. Ensure the Path variable starts with the following: %ORACLE_HOME%;%ORACLE_HOME%\bin;%ORACLE_HOME%\OPatch;%ORACLE_HOME%\perl\bin;
3. The Path system variable should now be displayed with the newly added entries at the beginning.
Note screen may show %ORACLE_HOME%, or the full path as defined by the %ORACLE_HOME% variable.
Click on the OK buttons and close the system information window