Schedule Oracle Data collection scans

You can run fixlets to schedule Oracle measurement scans. Use Get Oracle Hardware Auditing Data to collect hardware information for all endpoints with any Oracle software. This task embeds Oracle Measurements script that gathers information such as, operating system, processor, and computer name. By default, Get Oracle Hardware Auditing Data runs only once for the applicable endpoint. Once you perform the task, Oracle Measurements data related to hardware is collected from the endpoints and uploaded to the BigFix server. The data transfer to BigFix Inventory server is triggered only on user demand, not during data imports.

The following are the supported operating systems for versions that are supported by BigFix Inventory as BigFix endpoints:
  • Windows (WMI is required)
  • Linux
  • AIX
  • Solaris

To collect Oracle hardware information, run Collect Detailed Hardware Information fixlet for all endpoints with any Oracle database to gather more data required to generate the package. The task by default runs once a week. The data is transferred to BigFix Inventory during the next data import.

To collect Oracle database usage information, run Get Oracle Database Auditing Data fixlet for all endpoints with any Oracle database where the data can be collected automatically. This task embeds Oracle Measurements script that gathers required information, such as database instance information, database edition, features and options. You can run the Get Oracle Database Auditing Data fixlet only once for a selected endpoint. This fixlet is relevant in BigFix Console on all endpoints which has a running process with the name ‘oracle’ or ‘oracle.exe’.

When the fixlet is executed, the endpoint:
  • searches all running instances of the Oracle database.
  • switches to the database instance owner OS accounts (on Unix platform).
  • connects to every discovered oracle database without password by executing the sqlplus / as SYSDBA command.
  • identifies all Oracle database containers and switches to them, if applicable.
  • executes an Oracle Measurements SQL script that collects Oracle database inventory data.

Note: You must collect Oracle data with the same version of the fixlet and the BigFix Inventory server. Different versions may be incompatible. The OS version must be supported by BigFix Inventory as the BigFix endpoint.

If the endpoint is not able to collect the Oracle database inventory data automatically, you can manually collect it. For more information, refer to Manually collecting data from the database.