|
<< Click to Display Table of Contents >> RayVentory Scan Engine > 12.6 u4 > User Guide > Advanced Topics > Inventory Methods Overview Oracle Inventory |
These inventory methods gather data on enabled options and usage on Oracle database instances.
These methods operate on targets of the type Oracle.
Zero-Touch Oracle remote inventory by ORATRACK.
Use this to generate an inventory of your database instances. This is the least invasive method to create such an inventory. The only requirements are credentials with sufficient privileges on the target database for RayVentory Scan Engine.
•Used credential type:
oOracle DB
•Required capabilities:
oZero-touch
•Prerequisites:
oThe setting Java executable path has to be configured in the Oracle section of the Settings screen
oJava has to be installed on the host machine
o(Optional) The setting Oracle Database Feature Usage Statistics script path must be configured in the Oracle section of the Settings screen to run the DBFUS script together with the inventory
Zero-Touch Oracle remote inventory by ORATRACK. Remote-Execution Oracle inventory for Windows hosts by a temporary local copy of ORATRACK pushed via SMB, executed by a temporary service, and inventory copied via SMB. RayVentory Scan Engine mounts the target's built-in share ADMIN$, copies at least one version of the ORATRACK Java executable and the encrypted queries file to a temporary subdirectory of ADMIN$\Temp\, and starts ORATRACK by one of the local Java runtimes via a temporary service. Eventually, the resulting inventory file is copied to the RayVentory Scan Engine host. Later, the temporary service and the temporary directory are deleted.
Use this as an alternative to the zero-touch ORATRACK inventory. You may need this if remote connections to the DB are blocked by the host firewall and local connections are allowed. This is the most invasive ORATRACK inventory method as ORATRACK is (temporarily) copied to the target and a temporary service is installed.
•Used credential type:
oOracle DB Windows
•Required capabilities:
oAccess to the File System
oRemote execution
oWindows Service Manager
•Prerequisites:
oNone
Remote-Execution Oracle inventory for Linux / Unix hosted by a temporary, local copy of ORATRACK, pushed via SCP, executed via SSH, and inventory copied via SCP. RayVentory Scan Engine copies at least one version of ORATRACK and the encrypted queries file via SCP to a temporary subdirectory of the home directory for the user associated with the username of the SSH credentials. Then it runs ORATRACK via a local Java runtime by issuing a command via SSH. Eventually, the resulting inventory file is copied to the RayVentory Scan Engine host. Later, the temporary directory is deleted.
Use this as an alternative for the zero-touch ORATRACK inventory. You may need this if remote connections to the DB are blocked by the host firewall and local connections are allowed.
•Used credential type:
oOracle DB SSH
•Required capabilities:
oAccess to to File System
oRemote execution
oSSH
•Prerequisites:
oNone
Remote-Execution Oracle inventory for Windows hosts by a temporary, local copy of ORATRACK pushed via SMB, executed via WMI, and inventory copied via SMB. RayVentory Scan Engine mounts the target's built-in share ADMIN$, copies at least one version of the ORATRACK Java executable and the encrypted queries file to a temporary subdirectory of ADMIN$\Temp\, and starts ORATRACK by one of the local Java runtimes via a temporary service. Eventually, the resulting inventory file is copied to the RayVentory Scan Engine host. Later, the temporary directory is deleted.
Use this as an alternative to the zero-touch ORATRACK inventory. You may need this if remote connections to the DB are blocked by the host firewall and local connections are allowed.
•Used credential type:
oOracle DB Windows
•Required capabilities:
oAccess to the File System
oRemote execution
oWMI
•Prerequisites:
oNone
Remote-Execution Oracle inventory for Windows hosts by ORATRACK, loaded via SMB from the UNC path to the RayVentory Scan Engine utilities, executed by a temporary service, and inventory uploaded via HTTP(S). RayVentory Scan Engine starts a temporary service that references the service executable located on the RayVentory Scan Engine utilities share which starts ORATRACK by a Java runtime expected on the target located on the same share. ORATRACK will upload its results to the RayVentory Scan Engine HTTP Service. Later, the temporary service is deleted
Use this as an alternative to the zero-touch ORATRACK inventory. You may need this if remote connections to the DB are blocked by the host firewall and local connections are allowed.
•Used credential type:
oOracle DB Windows
•Required capabilities:
oRemote execution
oWindows Service Manager
•Prerequisites:
oConfigured and reachable RayVentory Scan Engine HTTP Service
Remote-Execution Oracle inventory for Windows hosts by ORATRACK, loaded via SMB from the UNC path to the RayVentory Scan Engine utilities, executed by a temporary service and inventory uploaded via SMB to the UNC path for RayVentory Scan Engine inventories.
RayVentory Scan Engine starts a temporary service that references the service executable located on the RayVentory Scan Engine utilities share which starts ORATRACK, located on the same share by a Java runtime expected on the target. ORATRACK will upload its results to the RayVentory Scan Engine inventories share. Later, the temporary service is deleted.
Use this as an alternative to the zero-touch ORATRACK inventory. You may need this if remote connections to the DB are blocked by the host firewall and local connections are allowed.
•Used credential type:
oOracle DB Windows
•Required capabilities:
oRemote execution
oUpload to the SMB shares
oWindows Service Manager
•Prerequisites:
oSMB share to receive inventory files
oThe setting Save inventory results from target devices on the following UNC share must be configured in the Remote Execution section of the Settings screen
Remote-Execution Oracle inventory for Windows hosts by ORATRACK, loaded via SMB from the UNC path to the RVP utilities, and executed via WMI and inventory uploaded via HTTP(S).
RayVentory Scan Engine starts ORATRACK, located on the RayVentory Scan Engine utilities share by a Java runtime expected on the target via WMI (Win32_Process). ORATRACK will upload its results to the RayVentory Scan Engine HTTP Service.
This is the second least invasive method together with Remote-Execution by WMI upload SMB on Windows to execute an Oracle inventory by ORATRACK. No files are copied to the target, no temporary service is installed. RayVentory Scan Engine will just create a process that starts a local Java runtime to run ORATRACK.
•Used credential type:
oOracle DB Windows
•Required capabilities:
oRemote execution
oWMI
•Prerequisites:
oThe setting Execute RayVentory Scan Engine Utiliites from the follwing UNC shared path on target device must be configured in the Remote Execution section of the Settings screen
oThe scan utilities must be present on the shared location (for example installed via the Install Scan Utilities button in the Remote Execution section of the Settings screen)
Remote-Execution Oracle inventory for Windows hosts by ORATRACK, loaded via SMB from the UNC path to the RayVentory Scan Engine utilities, executed via WMI, and inventory uploaded via SMB to the UNC path for RayVentory Scan Engine inventories.
RayVentory Scan Engine starts ORATRACK, located on the RayVentory Scan Engine utilities share by a Java runtime expected on the target via WMI (Win32_Process). ORATRACK will upload its results to the RayVentory Scan Engine inventories share.
This is the second least invasive method together with Remote-Execution by WMI upload HTTP(S) on Windows to execute an Oracle inventory by ORATRACK. No files are copied to the target, no temporary service is installed. RayVentory Scan Engine will just create a process that starts a local Java runtime to run ORATRACK.
•Used credential type:
oOracle DB Windows
•Required capabilities:
oRemote execution
oUpload to the SMB shares
oWMI
•Prerequisites:
oSMB share to receive inventory files
oThe setting Execute RayVentory Scan Engine Utiliites from the follwing UNC shared path on target device must be configured in the Remote Execution section of the Settings screen
oThe scan utilities must be present on the shared location (for example installed via the Install Scan Utilities button in the Remote Execution section of the Settings screen)
oThe setting Save inventory results from target devices on the following UNC share must be configured in the Remote Execution section of the Settings screen