Monday, April 21, 2014

CHEF: What's new in oracle cookbook v1.1.2?

After discussing with Eric Wolfe (@atomic_penquin) at #ChefConf2014, I added a recipe to handle the OS setup for Oracle databases on CentOS/RedHat. ora_os_setup.rb will perform the following tasks:

  • Create the 'oracle' os user based on the encrypted data bag information
  • Install dependency rpm packages for the Oracle binaries
  • Configure kernel parameters

Basically it is just a reduced default.rb. Tested it, but if you find any issues with it, please create an issue/pull request on GitHub.

or

Friday, April 11, 2014

CHEF: Installing Oracle database with Virtualbox (or vmware workstation, vagrant(vmware plugin)), chef-solo and test kitchen

"As hot as the microwave popcorn after the beep!"

My friend Scott Russell (sc0ttruss) has created a really nifty bash script to install an Oracle 11.2 database without the full and sometimes heavy chef environment solely for testing purposes.

This bash script uses chef-solo, vagrant (virtualbox or vmware ws (vagrant-plugin)), test-kitchen, bento images to pop up an Oracle VM (CentOS) in less than 35 minutes (run time). Of course run time depends heavily on the HW you are running. It works with the latest Oracle v1.1.1 cookbook.

Testkichenscripts:

He also has a nice blog post about it here:

Check it out! Try it out!

Friday, April 4, 2014

CHEF: Announcing relaunched oracle cookbook v1.1.0!

I'm happy to let you know, that the v1.1.0 of the cookbook has been released. I've released under my own user-id on GitHub. Please check it out at:

Oracle chef cookbook v1.1.0

New features in version v1.1.0


  • Configure the EM dbconsole (Enterprise Manager Database Control)
  • Install Oracle Client and patch it to the latest patch

Few notes:

The EM dbconsole is configured for every database. You can turn it off from attributes/default.rb, if you don't want it configured by default. It does extend the install time, but I also modified the default_template.dbt to have less options on by default. The older template is now named as midrange_template.dbt. For v1.1.1 I will make the template file name it as a node attribute, so that you can override it from a role for example.

For the Oracle client, please modify the templates/default/tnsnames.ora to best match your database layout. Currently it is only has an example.

Please try it out, contribute and read the "Roadmap" chapter on the README.md for planned features.