Forge Home

ora_profile

Puppet profiles for installing Oracle Database software and creating and managing databases

57,446 downloads

225 latest version

5.0 quality score

We run a couple of automated
scans to help you access a
module's quality. Each module is
given a score based on how well
the author has formatted their
code and documentation and
modules are also checked for
malware using VirusTotal.

Please note, the information below
is for guidance only and neither of
these methods should be considered
an endorsement by Puppet.

Version information

  • 0.46.1 (latest)
  • 0.46.0
  • 0.45.0
  • 0.44.4
  • 0.44.3
  • 0.44.2
  • 0.44.1
  • 0.44.0
  • 0.43.0
  • 0.42.2
  • 0.42.1
  • 0.42.0
  • 0.41.1
  • 0.41.0
  • 0.40.0
  • 0.39.0
  • 0.38.0
  • 0.37.0
  • 0.36.0
  • 0.35.1
  • 0.35.0
  • 0.34.0
  • 0.33.0
  • 0.32.0
  • 0.31.0
  • 0.30.1
  • 0.30.0
  • 0.29.0
  • 0.28.0
  • 0.27.0
  • 0.26.0
  • 0.25.0
  • 0.24.2
  • 0.24.1
  • 0.24.0
  • 0.23.0
  • 0.22.0
  • 0.21.0
  • 0.20.1
  • 0.20.0
  • 0.19.1
  • 0.19.0
  • 0.18.1
  • 0.18.0
  • 0.17.2
  • 0.17.1
  • 0.17.0
  • 0.16.0
  • 0.15.1
  • 0.15.0
  • 0.14.3
  • 0.14.2
  • 0.14.1
  • 0.14.0
  • 0.13.5
  • 0.13.4
  • 0.13.3
  • 0.13.2
  • 0.13.1
  • 0.13.0
  • 0.12.0
  • 0.11.0
  • 0.10.2
  • 0.10.1
  • 0.10.0
  • 0.9.1
  • 0.9.0
  • 0.8.11
  • 0.8.10
  • 0.8.9
  • 0.8.8
  • 0.8.7
  • 0.8.6
  • 0.8.5
  • 0.8.4
  • 0.8.3
  • 0.8.2
  • 0.8.1
  • 0.8.0
  • 0.7.1
  • 0.7.0
  • 0.6.2
  • 0.6.1
  • 0.5.0
  • 0.4.0
  • 0.3.0
  • 0.2.0
  • 0.1.0
released Mar 11th 2024
This version is compatible with:
  • Puppet Enterprise 2023.5.x, 2023.4.x, 2023.3.x, 2023.2.x, 2023.1.x, 2023.0.x, 2021.7.x, 2021.6.x, 2021.5.x, 2021.4.x, 2021.3.x, 2021.2.x, 2021.1.x, 2021.0.x, 2019.8.x, 2019.7.x, 2019.5.x, 2019.4.x, 2019.3.x, 2019.2.x, 2019.1.x, 2019.0.x, 2018.1.x, 2017.3.x, 2017.2.x, 2017.1.x, 2016.5.x, 2016.4.x
  • Puppet >= 4.7.0 < 9.0.0
  • , , , , , ,

Start using this module

  • r10k or Code Manager
  • Bolt
  • Manual installation
  • Direct download

Add this module to your Puppetfile:

mod 'enterprisemodules-ora_profile', '0.46.1'
Learn more about managing modules with a Puppetfile

Add this module to your Bolt project:

bolt module add enterprisemodules-ora_profile
Learn more about using this module with an existing project

Manually install this module globally with Puppet module tool:

puppet module install enterprisemodules-ora_profile --version 0.46.1

Direct download is not typically how you would use a Puppet module to manage your infrastructure, but you may want to download the module in order to inspect the code.

Download

Documentation

enterprisemodules/ora_profile — version 0.46.1 Mar 11th 2024

Enterprise Modules

Table of Contents

Overview

The ora_profile module allows an easy path from first simple installation to a fully customized Enterprise setup. It is part of our family of Puppet modules to install, manage and secure Oracle databases with Puppet. Besides the ora_profile module, this family also contains:

  • ora_install For installing an Oracle database and other database related Oracle products
  • ora_config For configuring every aspect of your Oracle database
  • ora_secured To secure your databases according to the CIS benchmarks or STIG documents.

This module support Oracle 10, 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

License

Most of the Enterprise Modules modules are commercial modules. This one is NOT. It is an Open Source module. You are free to use it any way you like. It, however, is based on our commercial Puppet Oracle modules.

Description

The ora_profile::database class contains all the Puppet code to install, create and populate an Oracle database. This class is an easy way to get started. It contains the following stages (These are not puppet stages):

  • sysctl (Set all required sysctl parameters)
  • limits (Set all required OS limits)
  • packages (Install all required packages)
  • groups_and_users (Create required groups and users)
  • firewall (Open required firewall rules)
  • asm_storage (Setup storage for use with ASM (skipped by default))
  • asm_software (Install Grid Infrastructure/ASM (skipped by default))
  • asm_diskgroup (Define all requires ASM diskgroups (skipped by default))
  • db_software (Install required Oracle database software)
  • db_patches (Install specified Opatch version and install specified patches)
  • db_definition (Define the database)
  • db_listener (Start the Listener)
  • db_services (Define Database Services)
  • db_tablespaces (Define all required tablespaces)
  • db_profiles (Define all required Oracle profiles)
  • db_users (Define all required Oracle users)
  • db_startup (Make sure the database restarts after a reboot)

All these stages have a default implementation. This implementation is suitable to get started with. These classed all have parameters you can customize through hiera values. The defaults are specified in the module's data/default.yaml file.

But sometimes this is not enough and you would like to add some extra definitions, you can, for example, add a Puppet class to be executed after the systctl stage is done and before the limits is done. You can do this by adding the next line to your yaml data:

ora_profile::database::before_sysctl:  my_profile::my_extra_class

or after:

ora_profile::database::after_sysctl:   my_profile::my_extra_class

If you want to, you can also skip this provided class:

ora_profile::database::sysctl:         skip

Or provide your own implementation:

ora_profile::database::sysctl:         my_profile::my_own_implementation

This mechanism can be used for all named stages and makes it easy to move from an easy setup with a running standard database to a fully customized setup using a lot of your own classes plugged in.

Check here to see the full documentation for this module.

Setup

Requirements

The ora_profile module requires:

Installing the ora_profile module

To install these modules, you can use a Puppetfile

mod 'enterprisemodules/ora_profile', '0.1.0'

Then use the librarian-puppet or r10K to install the software.

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

puppet module install enterprisemodules-ora_profile

Usage

To get started, include the ora_profile::database class in your role, make sure you have a module called software that has a folder files and that directory contains the the next files:

  • LINUX.X64_193000_db_home.zip
  • p6880880_190000_Linux-x86-64.zip (OPatch version 12.2.0.1.33)

If you also want to install ASM, the file below also needs to be placed in the files directory:

  • LINUX.X64_193000_grid_home.zip

You can download these files from here or here

Run Puppet and you have a running Oracle 19c database called DB01

Reference

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

Here are related blog posts:

Limitations

This module runs on Solaris, AIX and most Linux versions. It requires a puppet version higher than 4. The module does NOT run on windows systems.