Beware of the bug 16299065 when doing RMAN duplicate – you might end up with restoring on SOURCE database

This issue has happened on one of our customers environments where RMAN duplicate is a common practice for cloning databases. Later on I have successfully reproduced the same scenario on my virtual machine.

Background

A delivery had been applied to database, including some structural changes like creation of new tablespace with multiple datafiles. During testing someone had put one of the new datafiles offline. After some time customer did a request of additional database with the same release applied and RMAN duplicate from backup approach was used for that purpose.

Database version: 11.2.0.3 with 11.2.0.3.6 PSU applied on top

Continue reading

Advertisements

I am Oracle Database 11g Administrator Certified Master

It has been quiet on my blog lately, because for the last four months or so I was preparing for Oracle 11g OCM exam. I have received the good news yesterday (much more quicker than I expected this to happen) that I have passed the practicum successfully. I am very happy with such result as it was the most challenging goal I’ve set to myself during this year.

There are couple of good blogs from experienced OCM DBA’s with advices on how to prepare for the exam, like, for example, the latest one from Kamran Agayev. I decided to shortly come up with three things or suggestions which helped me most (but not necessarily you will consider them as best for you).  Continue reading

Oracle E-Business Suite Pre-install Patches Report – Obtaining patches easy way!

This post should be useful for Apps DBAs who are planning to upgrade their customer’s E-Business Suite environments from 11i to R12. As we all know, a long time passed since such projects have started and since then, the Upgrade exercise has improved a lot, mostly because of new patches and tools that Oracle has provided to avoid certain errors and bugs during the Upgrade driver. One of such tools is a Pre-install patches report for R12.1 upgrade which contains a list of essential patches that you must apply in pre-install mode before upgrading. If you haven’t met this report before, do visit a following MoS note – Oracle E-Business Suite Pre-install Patches Report [Video] [ID 1448102.1] and watch the video as well. It is worth to mention that the report is being constantly updated  (approximately once a month) based on Oracle and the customers experience and new patches are being added (if any). As it is stated in the topic – I am going to cover the easy way of downloading the patches listed in the report (please let me know if you have a better way of doing the same). Continue reading

Patching Fusion Applications – the look and feel

Recently, I had a chance to apply some patches to Fusion Applications environment. I must admit that the patching itself is a bit different here from what we have been used to in E-Business Suite Applications and seems to be more advanced and user friendly which is a good thing. First of all, we have now a choice of three different tools for specific patching requirements:

  1. Oracle Fusion Applications Patch Manager (fapmgr)
  2. Oracle Fusion Applications Release Update Patch Installer
  3. Oracle Fusion Applications Language Pack Installer

All three names are self explanatory, but compared to eBS where we would be using one tool for any patching (adpatch) – it is distinguished in Fusion Apps. In this blog post, I will be describing the option 1 only on the real world example case. Continue reading

Webgate 11g issues with Fusion Applications and unprotected URL’s

Hello everyone. I have not been blogging for quite a while due to time pressure but it seems that now I’ve forced myself to start doing it again and honestly, more often than it was before. Six months ago I have been involved in Fusion Applications (next generation of Oracle Applications) POC internal setup in our company premises. That made me learn and investigate a lot of new things and products including Identity and Access Management, which is now playing a huge role in Fusion Applications setup (or provisioning – the correct word and replacement for installation when it comes to Fusion Apps). In fact, it is not even possible to install Fusion Apps itself, before the IdM part if fully and correctly configured. That’s why I have introduced two new categories on my blog, IdM and FA respectively. This year I had also presented the topic of IdM importance in Fusion Apps on UKOUG 2012 conference in Birmingham. So if someone is interested in that area, feel free to contact me and request the presentation slides or ask some questions on the subject. Continue reading

Grid Infrastructure on RHEL5 x86 story / OOM explained

Have you ever installed and used Oracle Grid Infrastructure on RHEL 5x 32 bit server? Have you ever heard such an abbreviation as OOM?
Let me answer these questions first. Well, no I didn’t. Before a while ago.
The background is following – we had some Oracle Applications running on RHEL 4 32 bit with 32 GB RAM, when it was decided to upgrade and migrate to RHEL 5 32 bit with same memory amount. As a part of it, we also wanted to try out ACFS (ASM Cluster File System) (actually a part of an Oracle Cloud File System now after rebranding in January 2011) as a shared storage for application filesystem, which comes up together with Grid Infrastructure 11gR2 installation. So far, so good. Servers were delivered, it was time get the job done …

Continue reading

Using resource custom attributes in Grid Infrastructure 11gR2

Recently, in one of the ongoing projects, I had to install and configure multiple Oracle Grid Infrastructure 11gR2 clusters for ensuring Database and applications high availability using Cold Failover solution. As you have probably guessed – databases were Single Instances (not RAC’s).  When the cluster setup was done, I had to add databases as resources and create action scripts for controlling them (start, stop, relocate).  So, as I started thinking about the scripts, I have pointed out some main requirements for them:

1) Scripts should be unified, simple and flexible – no hardcoded environment values there – as I have multiple databases running on some clusters, I want to use one script to maintain them all rather then allocate separate script per each db;

2) Database resources are controlled by root – that means only root will be allowed to start, stop and relocate them.
Continue reading