---
title: Oracle product inventory
description: Block 64 Support Center
---

[Skip to content](https://support.block64.com/oracle-product-inventory#main-content)

<https://support.block64.com/kb-tickets/new?hsLang=en> [Customer Portal](https://customerportal.block64.com/tickets-view?hsLang=en)

[![Logo - dark](https://support.block64.com/hs-fs/hubfs/Logo%20-%20dark.png?width=350&height=86&name=Logo%20-%20dark.png)](https://support.block64.com/?hsLang=en)

- [Home](https://support.block64.com/)
- [Insights Portal](https://insights.block64.com/login)
- Platform
  
  Show submenu for Platform

    - [Block 64](https://www.block64.com/)
    - [Why Block 64?](https://www.block64.com/#:~:text=What%20makes%2CBlock%2064%20different)
- Solutions
  
  Show submenu for Solutions

    - [Unified Visibility](https://www.block64.com/solutions/unified-visibility)
    - [Cost Optimization](https://www.block64.com/solutions/cost-optimization)
    - [Proactive Security](https://www.block64.com/solutions/proactive-security)
    - [Compliance](https://www.block64.com/solutions/continuous-compliance)
- Learn
  
  Show submenu for Learn

    - [Quick Start Guides](https://support.block64.com/getting-started)
    - [Integrations](https://support.block64.com/documentation#integrations)
    - [Blog](https://www.block64.com/blog)
- Support
  
  Show submenu for Support

    - [Trust Center](https://trust.block64.com/)
    - [Service Health](https://status.block64.com/)
    - [Partners](https://www.block64.com/partners)
    - [Contact Us](https://www.block64.com/contact)
- [Pricing](https://www.block64.com/pricing)
- [Get Started Free](https://www.block64.com/free-trial)

Open main navigation

Close main navigation

- [Home](https://support.block64.com/)
- [Insights Portal](https://insights.block64.com/login)
- Platform
  
  Show submenu for Platform

    - [Block 64](https://www.block64.com/)
    - [Why Block 64?](https://www.block64.com/#:~:text=What%20makes%2CBlock%2064%20different)
- Solutions
  
  Show submenu for Solutions

    - [Unified Visibility](https://www.block64.com/solutions/unified-visibility)
    - [Cost Optimization](https://www.block64.com/solutions/cost-optimization)
    - [Proactive Security](https://www.block64.com/solutions/proactive-security)
    - [Compliance](https://www.block64.com/solutions/continuous-compliance)
- Learn
  
  Show submenu for Learn

    - [Quick Start Guides](https://support.block64.com/getting-started)
    - [Integrations](https://support.block64.com/documentation#integrations)
    - [Blog](https://www.block64.com/blog)
- Support
  
  Show submenu for Support

    - [Trust Center](https://trust.block64.com/)
    - [Service Health](https://status.block64.com/)
    - [Partners](https://www.block64.com/partners)
    - [Contact Us](https://www.block64.com/contact)
- [Pricing](https://www.block64.com/pricing)
- [Get Started Free](https://www.block64.com/free-trial)
- <https://support.block64.com/kb-tickets/new>
- [Customer Portal](https://customerportal.block64.com/tickets-view)
- [Submit a Support Request](https://support.block64.com/kb-tickets/new)

[Submit a Support Request](https://support.block64.com/kb-tickets/new?hsLang=en)

 How can we assist you today?

- There are no suggestions because the search field is empty.

1. [Block 64 Support Center](https://support.block64.com/?hsLang=en)
2. [Documentation](https://support.block64.com/documentation?hsLang=en)
3. [Discovery: General Knowledge](https://support.block64.com/documentation?hsLang=en#discovery-general-knowledge)

# Oracle product inventory

Block 64's tooling is capable of gathering key Oracle components, but not Oracle's complete catalog of products (which contains 4000+ products - and counting!). The majority of Oracle discoveries are focused on Databases and Options, and the good news is that you can use Block 64's tooling for gathering this data with confidence. However, in scenarios where 'pluggable' databases have been deployed, and in AIX deployments that leverage Logical Partitions (LPARs) we have observed issues, and you may require our assistance in these scenarios.

For discoveries of less common Oracle products,  or products outside of the database / database options catalog, we would recommend the use of Oracle's own scripts for data gathering currently. 

Oracle products are wide-ranging - from Java runtime packages to database servers and everything in between - and each package is unique in how they are discovered during inventory processes.

> **Privileges required**
> 
> In order to collect Oracle Database or Oracle Middleware, we use similar processes to those that Oracle use during a software audit. Those processes require us to search a system for any and all potential instances of Oracle-related files and folders, and to have read access to all of those potential locations.
> 
> In short, that kind of access is best provisioned by providing an account with administrative rights or, in other words, root access.

### Java SE / JRE

- Java SE / JRE collection requires access on Windows computers to the following registry keys: 
    - `HKLM\SOFTWARE\JavaSoft\Java Runtime Environment`
    - `HKLM\SOFTWARE\JavaSoft\Java Update`

### Oracle Database

- Oracle database inventory requires a credential set that can access the following views and tables: 
    - `V$Version`
    - `V$Database`
    - `V$Session`
    - `V$Parameter`
    - `V$Option`
    - `DBA_FEATURE_USAGE_STATISTICS`
- Oracle database inventory first tries to connect via a remote connection over TCP port 1521, then via a local call to `sql*plus` over an SSH tunnel.

### Oracle "middleware"

"Middleware" includes a huge swath of products, including Oracle Application Server, Tuxedo, WebLogic and many more. More info can be found on [Oracle's documentation site](https://docs.oracle.com/en/middleware/). We are progressively gathering more and more of the necessary "metadata" to understand your Oracle product footprint. The first step in gathering this data, is that we require access to the following default file locations (or registry keys in the case of Windows):

> Note
> 
> While these are the default file locations, Oracle instances can be installed in any location on a system, so our tool does need privileges to search for **and read** any and all related Oracle files and folders, not only the default ones below.

**and read**

#### \*nix:

- `/etc/oraInst.loc`
- `/etc/oratab`

#### Solaris:

- `/var/opt/oracle/oraInst.loc`
- `/var/opt/oracle/oratab`

#### Windows:

- `HKLM\Software\Oracle\inst_loc`

In those locations is information on where to find various XML or TXT files (including `inventory.xml`) and other resources that will further give us information about your Oracle installation footprint.

From there, we need to be able to parse those files for further details, including potentially searching deeper for other resources. This is why the note above regarding privileges is relevant.

- [Getting Started](https://support.block64.com/getting-started?hsLang=en#main-content)

    - [Free Trial Onboarding](https://support.block64.com/getting-started?hsLang=en#free-trial-onboarding)
    - [Start Your Subscription](https://support.block64.com/getting-started?hsLang=en#start-your-subscription)
    - [Discovery Application Installation](https://support.block64.com/getting-started?hsLang=en#discovery-application-installation)
    - [Discovery Appliance Setup](https://support.block64.com/getting-started?hsLang=en#discovery-appliance-setup)
    - [Discovery Agent Deployment](https://support.block64.com/getting-started?hsLang=en#discovery-agent-deployment)
- [Insights Reports](https://support.block64.com/insights-reports?hsLang=en#main-content)

    - [IT Asset Management](https://support.block64.com/insights-reports?hsLang=en#it-asset-management)
    - [Security](https://support.block64.com/insights-reports?hsLang=en#security)
    - [Cloud & Infrastructure](https://support.block64.com/insights-reports?hsLang=en#cloud-infrastructure)
    - [Legacy Combine User Guide](https://support.block64.com/insights-reports?hsLang=en#legacy-combine-user-guide)
- [Troubleshooting](https://support.block64.com/troubleshooting?hsLang=en#main-content)

    - [Discovery: Insights Portal](https://support.block64.com/troubleshooting?hsLang=en#discovery-insights-portal)
    - [Insights Calculations](https://support.block64.com/troubleshooting?hsLang=en#insights-calculations)
    - [Discovery: Block 64 Windows Application](https://support.block64.com/troubleshooting?hsLang=en#discovery-block-64-windows-application)
    - [Discovery: BlockBox Appliance](https://support.block64.com/troubleshooting?hsLang=en#discovery-blockbox-appliance)
    - [Block 64 Discovery Agent](https://support.block64.com/troubleshooting?hsLang=en#block-64-discovery-agent)
- [Documentation](https://support.block64.com/documentation?hsLang=en#main-content)

    - [Insights: Integrations](https://support.block64.com/documentation?hsLang=en#insights-integrations)
    - [Privacy and Security](https://support.block64.com/documentation?hsLang=en#privacy-and-security)
    - [Block 64 API](https://support.block64.com/documentation?hsLang=en#block-64-api)
    - [Discovery: General Knowledge](https://support.block64.com/documentation?hsLang=en#discovery-general-knowledge)
- [FAQs](https://support.block64.com/faqs?hsLang=en#main-content)

    - [Security](https://support.block64.com/faqs?hsLang=en#security)
    - [Block 64 Discovery](https://support.block64.com/faqs?hsLang=en#block-64-discovery)
- [New Features & Updates](https://support.block64.com/new-features-updates?hsLang=en#main-content)

    - [New Features & Updates](https://support.block64.com/new-features-updates?hsLang=en#new-features-updates)
    - [Combine](https://support.block64.com/new-features-updates?hsLang=en#combine)
    - [Block 64 Discovery](https://support.block64.com/new-features-updates?hsLang=en#block-64-discovery)
    - [Remote Discovery Agent](https://support.block64.com/new-features-updates?hsLang=en#remote-discovery-agent)
    - [Combine API](https://support.block64.com/new-features-updates?hsLang=en#combine-api)
    - [BlockBox Virtual Appliance](https://support.block64.com/new-features-updates?hsLang=en#blockbox-virtual-appliance)

[![Logomark - dark](https://support.block64.com/hs-fs/hubfs/Logomark%20-%20dark.png?width=60&height=96&name=Logomark%20-%20dark.png "Logomark - dark")](http://block64.com)

300 Geary Ave, Toronto, ON M6H 2C5, Canada  
+1 800-875-5260  
[www.block64.com](https://www.block64.com/)

<https://www.linkedin.com/company/block-64/> <https://www.reddit.com/r/Block64/> <https://www.youtube.com/@block64corp> <https://www.block64.com/contact>