Monday, January 25, 2016

Upgrading Opatch from 10.2.0.5.3 to 10.2.0.5.11 Version

Upgrading Opatch to Latest Version :

It is so simple to upgrade th Opatch version for your database.

I will check my current version of Opatch
[oracle@linux5 OPatch]$ opatch version
Invoking OPatch 10.2.0.5.3

OPatch Version: 10.2.0.5.3

OPatch succeeded.

Now download the latest Opatch version from oracle support site.
in this case I have downloaded p6880880_101000 & moved it to the database server
Move the patch file to your oracle home

[oracle@linux5 OPatch] mv p6880880_101000_SOLARIS64.zip $ORACLE_HOME
[oracle@linux5 OPatch] cd $ORACLE_HOME
(If a former OPatch directory already exist, then rename it)

Make sure you backup your current Opatch home
                                                                   
[oracle@linux5 OPatch] mv Opatch OPatch_100057_OLD  

Now unzip the patch file
[oracle@linux5 OPatch] unzip p6880880_101000_SOLARIS64.zip
Archive:  p6880880_101000_SOLARIS64.zip
   creating: OPatch/
   creating: OPatch/docs/
  inflating: OPatch/docs/FAQ    
  inflating: OPatch/docs/README.txt
  inflating: OPatch/docs/Users_Guide.txt
  inflating: OPatch/docs/bt1.txt
  inflating: OPatch/docs/bt2.txt
  inflating: OPatch/docs/tmp    
  inflating: OPatch/emdpatch.pl
   creating: OPatch/jlib/
  inflating: OPatch/jlib/opatch.jar
  inflating: OPatch/opatch      
  inflating: OPatch/opatch.bat  
  inflating: OPatch/opatch.pl  
   creating: OPatch/perl_modules/
  inflating: OPatch/perl_modules/Apply.pm
  inflating: OPatch/perl_modules/AttachHome.pm
  inflating: OPatch/perl_modules/Command.pm
  inflating: OPatch/perl_modules/LsInventory.pm
  inflating: OPatch/perl_modules/Query.pm
  inflating: OPatch/perl_modules/RollBack.pm
  inflating: OPatch/perl_modules/Version.pm
  inflating: OPatch/perl_modules/XML.pm
  inflating: OPatch/perl_modules/opatchIO.pm
  inflating: OPatch/README.txt  
   creating: OPatch/ocm/
 extracting: OPatch/ocm/ocm.zip
   creating: OPatch/ocm/doc/
  inflating: OPatch/ocm/doc/license.txt
   creating: OPatch/ocm/lib/
  inflating: OPatch/ocm/lib/emocmutl.jar
   creating: OPatch/ocm/bin/
  inflating: OPatch/ocm/bin/emocmrsp




thats it your patching is done.

check the Optach version :
[oracle@linux5 bin]$ cd $ORACLE_HOME/OPatch

export the path for Opatch
[oracle@linux5 OPatch]$ export PATH=$PATH:$ORACLE_HOME/OPatch

[oracle@linux5 OPatch]$ opatch version
Invoking OPatch 10.2.0.5.11

OPatch Version: 10.2.0.5.11

OPatch succeeded.

Wednesday, January 20, 2016

OPEN STANDBY DATABASE IN READ ONLY

SQL> select PROTECTION_MODE,PROTECTION_LEVEL FROM V$DATABASE;

PROTECTION_MODE      PROTECTION_LEVEL
-------------------- --------------------
MAXIMUM PERFORMANCE  MAXIMUM PERFORMANCE

SQL> select name,db_unique_name,open_mode,DATABASE_ROLE from v$database;

NAME  DB_UNIQUE_NAME OPEN_MODE      DATABASE_ROLE
--------- ------------------------------ -------------------- ----------------
ORCL  ORCLSTB1 MOUNTED      PHYSICAL STANDBY

 SQL> alter database open read only;

Database altered.

SQL> select name,db_unique_name,open_mode,DATABASE_ROLE from v$database;

NAME  DB_UNIQUE_NAME OPEN_MODE      DATABASE_ROLE
--------- ------------------------------ -------------------- ----------------
ORCL  ORCLSTB1 READ ONLY      PHYSICAL STANDBY


SQL> select PROTECTION_MODE,PROTECTION_LEVEL FROM V$DATABASE;

PROTECTION_MODE      PROTECTION_LEVEL
-------------------- --------------------
MAXIMUM AVAILABILITY MAXIMUM AVAILABILITY


SQL> SELECT database_role, open_mode FROM v$database;

DATABASE_ROLE OPEN_MODE
---------------- --------------------
PHYSICAL STANDBY READ ONLY WITH APPLY

Thursday, January 14, 2016

The opatch minimum version check for patch failed

atoorpu@LINUXRAC1:[/u01/app/PATCHES] $ /u01/app/11.2/grid_home/OPatch/opatch auto -report -ocmrf /u01/app/11.2/grid_home/OPatch/ocm/bin/ocm.rsp


This is the main log file: /u01/app/11.2/grid_home/cfgtoollogs/opatchauto2016-03-22_09-49-39.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/11.2/grid_home/cfgtoollogs/opatchauto2016-03-22_09-49-39.report.log

2016-03-22 09:49:39: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2/grid_home/crs/install/crsconfig_params

opatchauto is running in analyze/report mode. It will make no change to your system

Enter 'yes' if you have unzipped this patch to an empty directory to proceed  (yes/no):yes
Enter 'yes' if you have unzipped this patch to an empty directory to proceed  (yes/no):yes
The opatch minimum version  check for patch //root/Desktop failed  for /u01/app/oracle/product/11.2/db_1
The opatch minimum version  check for patch //root/Documents failed  for /u01/app/oracle/product/11.2/db_1
The opatch minimum version  check for patch //root/Downloads failed  for /u01/app/oracle/product/11.2/db_1
The opatch minimum version  check for patch //root/Music failed  for /u01/app/oracle/product/11.2/db_1
The opatch minimum version  check for patch //root/Pictures failed  for /u01/app/oracle/product/11.2/db_1
The opatch minimum version  check for patch //root/Public failed  for /u01/app/oracle/product/11.2/db_1
The opatch minimum version  check for patch //root/Templates failed  for /u01/app/oracle/product/11.2/db_1
The opatch minimum version  check for patch //root/Videos failed  for /u01/app/oracle/product/11.2/db_1
Opatch version check failed for oracle home  /u01/app/oracle/product/11.2/db_1
Opatch version  check failed
ERROR: update the opatch version for the failed homes and retry

SOLUTION : CHECK TO SEE WHAT VERSION OF OPTACH UTILITY ARE YOU USING. UPGRADE IT TO MINIMUM REQUIRED VERSION AS PER PATCH README.