Table of Contents

1. Overview
2. Experience the Power of Puppet for Oracle databases
3. License
4. Description - What the module does and why it is useful
5. Setup
   • Requirements
   • Installing the ora_config module
6. Usage - Configuration options and additional functionality
7. Reference - An under-the-hood peek at what the module is doing and how
8. Limitations - OS compatibility, etc.

Overview

This module allows you to configure and manage Oracle databases and Oracle ASM instances. It is part of our family of Puppet modules to install, manage and secure Oracle databases with Puppet. Besides the ora_config module, this family also contains:

• ora_install For installing an Oracle database and other database related Oracle products
• ora_cis To secure your databases according to the CIS benchmarks.
• ora_profile The ora_profile module allows an easy path from first simple installation to a fully customized Enterprise setup.

All of these modules support Oracle versions 11, 12, 18, 19 and 21.

Experience the Power of Puppet for Oracle databases

Managing the configuration of your Oracle databases can be hard. With Puppet at your side, you get super-powers when installing and managing Oracle Databases. If you want to play and experiment with this please take a look at our playgrounds.

Experience the Power of Puppet for IBM MQ

Installing IBM MQ software and managing your IBM MQ configuration can be hard. With Puppet at your side, you get super-powers when installing and managing IBM MQ. If you want to play and experiment with this please take a look at our playgrounds.

License

This is a commercially licensed module. But you can use the module on VirtualBox based development systems for FREE. You can request a FREE trial license here

Check the License for details.

Description

This module allows you to manage everything there is to manage in an Oracle database. For example you can manage: users, tablespaces and schemas and much more. The module contains the following types:

• ora_asm_directory
• ora_asm_diskgroup
• ora_asm_volume
• ora_database
• ora_directory
• ora_exec
• ora_init_param
• ora_listener
• ora_object_audit
• ora_object_grant
• ora_package
• ora_procedure
• ora_profile
• ora_record
• ora_role
• ora_scheduler_job
• ora_schema_definition
• ora_service
• ora_setting
• ora_statement_audit
• ora_synonym
• ora_tablespace
• ora_thread
• ora_trigger
• ora_user

Check here to see the full documentation for this module.

Setup

Requirements

The ora_config module requires:

• Puppet module enterprisemodules-easy_type installed.
• Puppet version 3.0 or higher. Can be Puppet Enterprise or Puppet Open Source
• Oracle 11 higher
• A valid Oracle license
• A valid Enterprise Modules license for usage.
• Runs on most Linux systems.
• Runs on Solaris
• Runs on Windows systems

Installing the ora_config module

To install these modules, you can use a Puppetfile

mod 'enterprisemodules/ora_config'               ,'3.7.x'

Then use ther10K to install the software.

You can also install the software using the puppet module command:

puppet module install enterprisemodules-ora_config

Usage

Building a total Oracle setup requires quite some work. To help you, we have built some examples. The repo contains a demonstration of a simple database installation.

Reference

Here you can find some more information regarding this puppet module:

• The ora_config documentation

Here are a related blog posts:

• How to ensure you only use Oracle features you paid for
• Oracle 12.2 support added to our Oracle modules
• Secure your Oracle Database
• Manage Oracle containers with Puppet
• Manage your oracle users with Puppet
• Reaching into your Oracle Database with Puppet
• Manage your Oracle database schemas with Puppet
• Managing your Oracle database size with Puppet
• Using Puppet to manage Oracle

Limitations

This module runs on Solaris, AIX, Windows and most Linux versions. It requires a puppet version higher than 4. Other configurations are no supported.