Prerequisites
- RayVentory Portal (RVP) 11.1 or higher
- Microsoft Visual Studio 2017 Redistributable 64bit (https://support.microsoft.com/en-us/help/2977003/the-latest-supported-visual-c-downloads)
- Oracle Instant Client (https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html)
- Basic Package (Instantclient-basic-windows.x64-{Version}.zip)
- SQL*Plus Package (instantclient-sqlplus-windows.x64-{Version}.zip)
- Oracle Database Options/Management Packs Usage Reporting for Oracle Databases 11gR2, 12c and 12cR2 (KB Artikel: Doc ID 1317265.1)
Installation
- Install Microsoft Visual Studio 2017 Redistributable
- Extract the Instantclient-basic-windows.x64-{Version}.zip and instantclient-sqlplus-windows.x64-{Version}.zip files to the following path: C:\Program Files\Oracle
- Access 'Advanced System Settings > Environment Variables':
- Select the Path system variable and then press the [Edit...] button:
- Press the [New] button:
- Enter the path for the instantclient and then press the [OK] button:
- Press the [New...] to create a new system variable:
- Fill out the variable name and value fields as shown and then press the [OK] button:
Configuration
- Navigate to the Oracle zero-touch tab within the RVP UI:
- Enter the path to the 'sqlplus.exe' file:
- Enter the path to the script that was obtained via article Doc ID 1317265.1. This is where the DBFUS evaluations from Oracle for the databases are also transmitted.
Audits
If you have an audit, you can enter the path to the script that the auditor provides within the Oracle Review Lite script path field, so that RVP can then run those queries against all of your databases.
The results from this audit scan can be found within the following location: "C:\ProgramData\Raynet\RayVentoryPortal\Oracle\Audit\"
Comments