Introducing the puppet modules for Oracle databases

This module allows you to manage averything there is to manage in an Oracle database. For example you can manage: users, tablespaces and schemas and much more.

You don’t want to read about it, but really want to try it? You can! You can explore our Puppet modules for Oracle by checking out our playgrounds. Here we guide you around in some of the functionality of our Oracle modules.

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_profile
• ora_record
• ora_role
• 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.

To install the Oracle software on your system, check out ora_install

Our modules are based on an annual subscription(an entitlement). When you purchase an entitlement:

• you are allowed to use the module on the named nodes you purchased the subscription for;
• you get full support on usage and any issues you have;
• we will guide you towards a working setup;
• Are allowed to use the latest and greatest version without any extra charge.

We will make sure the modules keep working with the latest versions of Puppet en the supporting products like Oracle IBM MQ or WebLogic.

We currently have the following licensing methods for you:

1) Free when used on VirtualBox
2) Per node per year subscription
3) Custom licensing

1. Free when used on VirtualBox

This module is Free when used on a VirtualBox testing machine. The software checks if you are using VirtualBox and allows usage. No need to get any licenses from us to get going. Just download the module from our own forge and get going. To download the module use:

puppet module install
    --module_repository=http://forge.enterprisemodules.com
    enterprisemodules-modulename

2. Per node per year subscription

Our basic licensing model requires a subscription per node. The subscription is valid for a year. To make this work, we need you to send us the node name of the system you want to use the module on. (Not the puppetmaster, but the system where the agent is running.). Based on this information we will send you a file containing the entitlement for your node(s). You can purchase the entitlement in the shop or you can contact us. After you have ordered this module, you will receive an entitlement file. This file contains the information needed to run the software on your Puppet machine (agents).

3. Custom licensing

Our license manager is very flexible. If you have special requirements, please contact us so we can discuss other options.

When you have questions about licensing, please contact us or check our licensing FAQ

The ora_config module requires:

• Puppet version 4.0 or higher. Can be Puppet Enterprise or Puppet Open Source
• Oracle 11 higher
• A valid Oracle license
• A valid entitlement for usage.
• Runs on most Linux systems, Windows, AIX and Solaris.

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

Some example code:

• Simple DB demo

Also check out the Oracle database playgrounds here, where you can experiment with these modules without downloading or installing any software.