Demo Puppet implementation

Required software

For the box to run it needs Oracle Database software.

• LINUX.X64_193000_db_home.zip (19c oracle home)
• p6880880_190000_Linux-x86-64-12.2.0.1.33.zip (OPatch version 12.2.0.1.33)
• p34416665_190000_Linux-x86-64.zip (19c OCT2022RU)
• p34411846_190000_Linux-x86-64.zip (19c OCT2022RU OJVM)

The software must be placed in modules/software/files. It must contain the next files:

OPatch update file

We have chosen to rename the download of the OPatch updates to contain the version of OPatch in the name. This makes it more clear which version is included in the zipfile. Make sure to also rename the zipfile when using this demo.

Starting the node

To start the node for the first time, run:

vagrant up ml-db01

Running puppet

Although puppet normally is running client-server mode, for simplicity in this demo we will use the masterless approach. That means you have to run puppet manually. The command is:

puppet apply /etc/puppetlabs/code/environments/production/manifests/site.pp

The basic vagrant up will already run puppet for the first time.

Experimenting with Puppet for Oracle

To enter the VM execute the next command:

vagrant ssh ml-db01

This will log you in to the vagrant user. Remember that puppet needs to be run with root privileges. So after gaining access to the vagrant user, you have to execute sudo -i to get root privileges.

• intro
• Ensure Tablespaces
• Change Tablespaces
• More Tablespace-properties
• Manage Profiles
• Manage DB users
• Manage DB parameters
• Secure your database
• Epilogue