Fusion Applications bare metal provisioning series Part III: Provisioning Identity and Access Management

This is my favourite part of the process, because from hardest one it has now became the easiest. While it was a huge struggle and the most important stage of Fusion Applications provisioning in earlier versions, with release of 11.1.7 Oracle developers did a great job to automate the whole burden of Identity and Access management components manual setup. Frankly speaking it was very easy to misinterpret some parts of documentation when doing it all manually and therefore make a mistake in crucial setup parts which then lead to unexpected errors during Fusion Apps provisioning. Now it all gone! As a result you get a fully working and integrated Identity and Access Management environment which is ready for Fusion Applications. Continue reading

Fusion Applications bare metal provisioning series Part II: Preparing servers and databases for Identity Management

As it was mentioned in my previous post, Identity and Access Management is the main prerequisite of Fusion Applications provisioning – therefore it is the first thing to start with in overall process. Prepare at least two servers, one for Identity and Access Management and second for Fusion Applications as currently it is not supported to have both products sharing the same machine. However, my recommendation is to split components between four servers in order to gain more performance and manageability. The easiest way of course is to leverage virtualisation for that purpose, but please be ready for large amounts of RAM and disk space. Here is what official documentation states for typical HW requirements (or minimum, meant not for a production case):

Screen Shot 2013-11-06 at 10.26.15 AM

Continue reading

Fusion Applications bare metal provisioning series Part I: Obtaining the right software and documentation

I’ve decided to release a series of blog posts related to Fusion Applications bare metal provisioning. Get ready! The provisioning process (the replacement for “installation” term in Fusion Apps) is not so fast and straight forward as you would see it in Oracle Applications (e-Business Suite), for example. So expect to see a lot of blog posts broken in multiple parts with several sections. I will try to document the deployment as clear and detailed as I can to help others with the same.

Continue reading

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

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