Friday, August 22, 2014

CHEF: New dev progress on oracle cookbook

Greetings,

After the summer holidays, the oracle cookbook will undergo some major changes. With Dominique (THE co-author), we'll be streamlining the cookbook to more LWRP/HRWP style. v1.3.0 will include some tidy-up on the cookbook, but v2.0.0 will bust the bank. My personal goal is to get the grid infrastructure install and ASM disk usage incorporated to the cookbook (v1.3.0). It's one of the steps closer to the RAC. Also going to glance the patching of existing Oracle installations through (amazing) Chef installations, is on the queue. I'm also working to convert my simple ksh Oracle backup script to Ruby. This will be a circle end of the DBA work I've been doing for the past years. So, stay tuned for more from the oracle cookbook! Check the Road map on README.md.

We'll also change the documentation structure of the cookbook. The README.md is getting way too big for the getting the relevant information for the audience, so we'll be splitting it to smaller doc files.

Br, Ari aka @dmoarir or arir on IRC

Friday, May 23, 2014

CHEF: oracle cookbook v1.2.0 now released!

New version 1.2.0 of the oracle cookbook now available at:

http://community.opscode.com/cookbooks/oracle
and
https://github.com/aririikonen/oracle

New in v1.2.0

  • Support for Oracle 12c databases with DBEXPRESS configured out of the box
  • Fixed few issues on recording oracle version and timestamp of the installation (get_version.rb)

Try it out and please report any issues to GitHub.
https://github.com/aririikonen/oracle/issues

Next I'll start to bake the Oracle 12c Grid Infrastructure installation.

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.

Monday, March 10, 2014

CHEF: echa-oracle cookbook update coming out soon (v1.1.0)

Update 4/8/2014: v1.1.1 is out! https://github.com/aririikonen/oracle

Just wanted to post an announcement about the echa-oracle cookbook. There's going to be an update to version 1.1.0 soon. I've added a possibility to install Oracle Client 11.2 as well. Please, stay tuned.