Configure Data Staging

FlexNet Manager Suite 2020 R2 (On-Premises)

Modify the name and location of the file of Oracle connection information.

The OEM adapter collects information about connections to Oracle systems from which you need to gather inventory information. This file is in a standard Oracle format, used for their TNSNames.ora file. It is saved by default where the OEM adapter is executing; but the default location for the OEM adapter does not support automated processing of the TNSNames.ora file when the inventory beacon applies rules for gathering Oracle inventory. For the OEM adapter to function seamlessly, you must customize the location as you edit the OEMAdapter.exe.config file.

Another reason to customize the file name is if you have multiple instances of the OEM adapter running from the same computer (or if anyone manually adds TNSNames.ora files to the processing directory). Each instance must write to a unique file name, so that one output does not over-write the other.

These settings live in an add element with the key attribute of ConnectionInfoFile.

To configure data staging:

1. In the OEMAdapter.exe.config file, locate the appropriate element. Its default values are similar to the following:

   <add key="ConnectionInfoFile" 
        value="C:\Program Files\Flexera\Oracle Enterprise Manager Adapter\TNSNames.ora"></add>

   This reflects the default location of the OEM adapter, and must be modified.
2. Replace the value string with the new file path and name.
   Important: The file name must use the extension .ora.

   You may use a mapped drive on the local computer to specify a network path. This example shows the file in the recommended 'magic path' on the inventory beacon where the .ora file is automatically processed to 'filter' the target supplied from the central application server. Also notice the customized file name to avoid naïve overwriting of the TNSNames.ora file name by other copies saved here:

   <add key="ConnectionInfoFile" 
        value="C:\ProgramData\Flexera Software\Repository\TNSNames\TNSNames-01.ora"></add>

3. Save the amended configuration file.
   The Password Store: Password Filter dialog displays.
4. Use the Windows schedule task interface to run a test of the OEM adapter to confirm that the staging file is saved according to your revised specifications. Check the location (recommended: C:\ProgramData\Flexera Software\Repository\TNSNames\) for the presence of a saved file immediately after the test run (if you wait too long, the resulting file may be automatically uploaded and removed from this staging location).