Skip to main content

oracledb_conf resource

Use the oracledb_conf Chef InSpec audit resource to test the Oracle system parameters.


This resource is distributed with Chef InSpec and is automatically available for use.


You must have access to a database user with DBA role.


A oracledb_conf resource block declares user and password to use. It fetches system parameters which are defined in the V$SYSTEM_PARAMETER database view, and then compares those parameters to the values stated in the test:

describe oracledb_conf(user: 'USER', password: 'PASSWORD') do
  its("config item") { should cmp "value" }

Optional Parameters

oracledb_conf is based on oracledb_session, and accepts all parameters that oracledb_session accepts.


The following examples show how to use this Chef InSpec audit resource.

Test parameters set within the database view

describe oracledb_conf(user: 'USER', password: 'PASSWORD') do
  its("audit_sys_operations") { should cmp "true" }
  its("sql92_security") { should cmp "true" }


For a full list of available matchers, see our Universal Matchers page.
Edit this page on GitHub

Thank you for your feedback!


Search Results