Guenadi N Jilevski's Oracle BLOG


Upgrade Oracle RAC to from on Linux

Upgrade Oracle RAC to from on Linux

In the article you will have a look at the steps to upgrade two node Oracle RAC cluster on Linux to Oracle You will check the prerequisites to upgrade the cluster, upgrade GI software, upgrade RDBMS software and last but not least upgrade the database. The setup consists of two node Oracle cluster running on Linux as configured here.

I expected Oracle patch set that is distributed as capable of a complete installation, see here for complete installation, to perform an upgrade without asking for prerequisite patches that is, to include all prerequisite patches and upgrade straight away from a previous patch set However, during the upgrade of GI I was stopped by OUI asking for Oracle patch 12539000.
Continue reading

November 13, 2011 Posted by | oracle | 8 Comments

Build HA for third party application with Oracle GI

Build HA for third party application with Oracle GI

In the article you will have a look at how to protect an Apache from node failure by registering it with Oracle Clusterware (OC) for monitoring, restart, failover and high availability.

Overview of using Oracle Clusterware for protecting third party application

Starting with Oracle release 10.2 Oracle Clusterware provided high availability for third party applications. An application should be associated with a profile that contain a set of attributes for the Oracle Clusterware(OC) to manage (stop, start, monitor, restart, failover) it. OCR stores the application profile. Prior to Oracle 11.2 crs_* utilities ( crs_profile, crs_register, crs_setprm, crs_start, crs_relocate, crs_stop, crs_unregister) were used for management of third party applications brought under control of OC. In Oracle 11.2 management of third party applications is standardized and has a common management interface using crsctl. Oracle 11.2 also introduces appvipcfg utility for creating VIPs. Upon node failure application VIP fails over to a surviving node along with the protected application. It is the Application VIP that is used for accessing the application, thus in case of failure the application will be highly.

In this article you will look at how to register Apache for management with OC The process comprises several ordered steps as listed below.

  1. Create an Application VIP MyTestVIP on
  2. Modify Apache configuration to start on the newly create Application VIP.
  3. Create an action perl script for monitoring, start, stop and clean Apache.
  4. Create a MyTest resource
  5. Test the implementation.

Continue reading

November 13, 2011 Posted by | oracle | 7 Comments