opatchauto failed again, apply of GI+PSU tested on 1 RAC node

The Problem is in the PSU, it was replaced with a fix. But it’s interresting anyway so let’s check it.. I have enough space for the patches and it’s not under root, then it would fill up the filesystem and crash OK. so I have warnings, we know warnings are not Errors. the analyze.debug.log looks…

Most important thing in IT – test system

Today I wanted to patch my Oracle Homes with the new PSU July 2016 (DB+GI without OJVM). I hoped opatchauto will work… well, it worked not.. again. it failed on a napply and relink of isqora. OK. As it’s only my personal test RAC I was not sad, because there was information too how to…

Ansible: Playbooks – Basics

Automation in ansible is about playbooks. A playbook is a simple file in yaml syntax with basically the same commands as in a command line syntax. More info here: Ansible Playbooks and to play this simple playbook you can run: To install/deinstall a webserver with a proxy you can use these playbooks:

Automation with ansible for dba 1.0

I don’t have any knowledge how to automate, I never cared about it, because I was a DBA, now my new colleague is a geeky system administrator and now I see how things are done. Let me introduce: I have created 2 VMs to play with them.. they are copies of a template used for…

pfile or spfile?

In my old work there were strange things on daily business. I don’t know why, but for instance a dataguard configuration was a nonstandard configuration for Oracle Support. We had only shipping configured and scripts took care of switchover/failover and the gap check. Do you know since when this concept exists? ..since 8i, well, that’s…

It’s so bad when there…

It’s so bad when there are more automation tools… puppet, chef, salt and now ansible. You can be either a DBA or a System Administrator.. or a Network admin.. if you do everything, you cannot be really good at all of them, you may understand all the networking stuff, but implementing iptables is not administration…