How to Discover Oracle Databases
Discover Oracle databases to collect licensing data from Oracle Database instances. You can then review your licenses and view data in reports.
- If you have Oracle databases running on virtual machines, run virtual environment discovery.
- Run Linux/Unix/Mac OS discovery to find machines that have Oracle databases installed on them.
Configure Oracle Database Discovery
After you complete the prerequisites and discover any Linux/Unix/Mac OS or virtual machines with Oracle databases installed on them, configure Oracle Database discovery as follows:
- Select .
- In the Discover Oracle Databases dialog box, select Configure.
- In the Configure Oracle Databases dialog box, select one or more listed instances, then select Configure to open a dialog box where you specify credentials for the machines.
- Provide credentials for the selected configuration(s).
To successfully query an Oracle Database, you must provide valid Oracle Database credentials. The username and password must have select permissions for the following tables:
SYSTEM table: PRODUCT_COMPONENT_VERSION
SYSTEM table: DBA_FEATURE_USAGE_STATISTICS
Recommended: If you selected a single configuration, select Test before proceeding, to make sure a connection can be established.
- Select OK to save your configuration and return to the Configure Oracle Databases dialog box. The checkbox for the configuration(s) you just entered is selected, which means Oracle licensing information will be discovered next time you run discovery or scheduled discovery runs.
- Repeat steps 3 – 5 to add additional discovery configurations.
- Select the check boxes next to configurations on which you want to
- To run discovery on all of your configurations, select
- or -
- Clear all configurations by selecting Uncheck All, then select the check boxes next to the individual configurations on which you want to run discovery.
- To run discovery on all of your configurations, select Check All.
- Select OK to return to the Discover Oracle Databases dialog box. Oracle Database discovery configuration is now complete and available to run, as described next.
Run Oracle Database Discovery
You can run Oracle Database discovery immediately after configuration, or later:
- To immediately run Oracle Database discovery, select Discover.
- To run it later, select Close. You can return to this dialog box any time you want to run Oracle Database discovery by selecting the Tools menu, pointing to Discovery, and selecting Oracle Databases.
The options you specified during configuration remain in effect until you change them, and all selected processes listed in the Configure Oracle Database Discovery dialog box are run when you select Discover.
To clear this option:
- In the Options dialog box, select the Schedule tab.
- Clear the check box.
Change how frequently discovery runs in the Windows Task Scheduler.
To verify Oracle Database discovery successfully gathered the data needed for your Oracle instance analysis, open the Configure Oracle Database Discovery dialog box and view the Last Result column.