In this playground we will show you how you can use Puppet to manage the inside of your database.
The playground system contains a pre-installed puppet agent. There is no server available, so to run Puppet, you have to use the
puppet apply command. The playground text will guide you with this.
On the playground system, you will find an Oracle database with the sid DB01. We have created it using the
ora_profile module. The playground will guide you in your customisations.
Under this text, you see the working area. You can inspect the system and issue any command you like in the terminal. In the editor window, you can see the Puppet production environment. You can edit anything you wish. The documentation tab shows the documentation for the
This system will self destruct in about one hour. So please don’t use it to build or create anything you wish to keep!
Using Puppet for introspection
In this section, we’ll show you how you can use Puppet to introspect your database. In general in Puppet to introspect any resource, you use the command:
Looking at your database with puppet
Standard, however Puppet doesn’t know about Oracle and database. The
So to see what Puppet knows about your database, enter the next command.
If you wanted to, you could also use the output of this command as a starting point for a new Puppet manifest.
Puppet knows about your Oracle profiles too
In the last section, we showed you how you could use Puppet to introspect your database. But Puppet can do much more. We will now show you that Puppet can also introspect other database objects. We will demonstrate that now using Oracle profiles.
TEASER: introspection is the prequel to creating and managing Oracle profiles with puppet.
Introspect available Oracle profiles
Remember the general command for introspecting?
For Oracle profiles, the Puppet type is
Just like with databases, the output of this command can be used as a starting pointfor defining new profiles.
Creating a profile with Puppet from the command line
We have been using Puppet from the command line for introspecting. But you can also use puppet on the command line for creating and changing Oracle resources. To do this we again use the
The general command for making sure a resource exists is:
“Making sure a resource exists” means that when it doesn’t exist, Puppet will create it for us.
Let’s use this to create a new profile with the name
Create the profile
The command to make this happen is:
Modifying a profile with Puppet from the command line