Skip to main content

oracledb_conf resource

[edit on GitHub]

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


This resource is distributed along with Chef InSpec itself. You can use it automatically.


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, please visit our matchers page.

Was this page helpful?


Search Results