Guenadi N Jilevski's Oracle BLOG

Oracle RAC, DG, EBS, DR and HA DBA BLOG

Upgrade Oracle RAC to 11.2.0.3 from 11.2.0.2 on Linux

Upgrade Oracle RAC to 11.2.0.3 from 11.2.0.2 on Linux

In the article you will have a look at the steps to upgrade two node Oracle 11.2.0.2 RAC cluster on Linux to Oracle 11.2.0.3. 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 11.2.0.2 on Linux as configured here.

I expected Oracle patch set 11.2.0.3 that is distributed as capable of a complete installation, see here for complete 11.2.0.3 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 11.2.0.2. 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 11.2.0.3

Build HA for third party application with Oracle GI 11.2.0.3

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 11.2.0.3. The process comprises several ordered steps as listed below.

  1. Create an Application VIP MyTestVIP on 192.168.20.111.
  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