Sunday, May 8, 2016

Creating OCM response File to Apply patch : RAC

How to Create an OCM Response file to Apply a Patch in Silent Mode - opatch silent (Doc ID 966023.1)
[oracle@tnc1 ocm]$ pwd
/u01/app/11.2.0/grid/OPatch/ocm
[oracle@tnc1 ocm]$ cd bin
[oracle@tnc1 bin]$ ls -ltr emocmrsp 
ls: emocmrsp: No such file or directory
If You find There is no "emocmrsp" in GRID_HOME/OPatch/ocm/bin
DownLoad Recent OPatch to upgrade OPATCH version  # 


-rwxrwxr-x  1 oracle oinstall 52733900 May  8 01:02 p6880880_112000_Linux-x86-64.zip
drwxrwxr-x  2 oracle oinstall     4096 May  8 01:10 OPatch
[root@tnc2 grid]# pwd
/u01/app/11.2.0/grid


[oracle@tnc2 grid]$ unzip p6880880_112000_Linux-x86-64.zip 
Archive:  p6880880_112000_Linux-x86-64.zip
  inflating: OPatch/opatchdiag       
  inflating: OPatch/opatch.pl        
   creating: OPatch/jlib/
  inflating: OPatch/jlib/oracle.opatchcore.classpath.jar  
  inflating: OPatch/jlib/opatch.jar  
  inflating: OPatch/jlib/oracle.opatch.classpath.jar  
  inflating: OPatch/jlib/oracle.opatch.classpath.unix.jar  
  inflating: OPatch/jlib/oracle.opatch.classpath.windows.jar  
  inflating: OPatch/jlib/opatchsdk.jar  
  inflating: OPatch/jlib/oracle.opatchcore.classpath.unix.jar  
  inflating: OPatch/jlib/oracle.opatchcore.classpath.windows.jar  
   creating: OPatch/crs/
  inflating: OPatch/crs/patch11203.pl  
  inflating: OPatch/crs/installPatch.excl  
  inflating: OPatch/crs/patch11202.pl  
  inflating: OPatch/crs/auto_patch.pl  
   creating: OPatch/crs/log/
  inflating: OPatch/crs/patch112.pl  
  inflating: OPatch/crs/patchDB.pl   
  inflating: OPatch/crs/opatchauto   
  inflating: OPatch/crs/CRSProductDriver.jar  
  inflating: OPatch/crs/driver.jar   
   creating: OPatch/ocm/
   creating: OPatch/ocm/doc/
 extracting: OPatch/ocm/ocm.zip      
  inflating: OPatch/ocm/ocm_platforms.txt  
   creating: OPatch/ocm/lib/
  inflating: OPatch/ocm/lib/emocmclnt.jar  
  inflating: OPatch/ocm/lib/xmlparserv2.jar  
  inflating: OPatch/ocm/lib/http_client.jar  
  inflating: OPatch/ocm/lib/emocmclnt-14.jar  
  inflating: OPatch/ocm/lib/regexp.jar  
  inflating: OPatch/ocm/lib/jnet.jar  
  inflating: OPatch/ocm/lib/jsse.jar  
  inflating: OPatch/ocm/lib/osdt_core3.jar  
  inflating: OPatch/ocm/lib/osdt_jce.jar  
  inflating: OPatch/ocm/lib/emocmcommon.jar  
  inflating: OPatch/ocm/lib/log4j-core.jar  
  inflating: OPatch/ocm/lib/jcert.jar  
   creating: OPatch/ocm/bin/
  inflating: OPatch/ocm/bin/emocmrsp  
  inflating: OPatch/opatch           
   creating: OPatch/opatchauto-dir/
   creating: OPatch/opatchauto-dir/opatchautocore/
  inflating: OPatch/opatchauto-dir/opatchautocore/oplan  
  inflating: OPatch/opatchauto-dir/opatchautocore/opatchautobinary  
   creating: OPatch/opatchauto-dir/opatchautocore/jlib/
  inflating: OPatch/opatchauto-dir/opatchautocore/jlib/ValidationRules.jar  
  inflating: OPatch/opatchauto-dir/opatchautocore/jlib/patchsdk.jar  
  inflating: OPatch/opatchauto-dir/opatchautocore/jlib/ProductDriver.jar  
  inflating: OPatch/opatchauto-dir/opatchautocore/jlib/osysmodel-utils.jar  
  inflating: OPatch/opatchauto-dir/opatchautocore/jlib/OsysModel.jar  
   creating: OPatch/opatchauto-dir/opatchautocore/jlib/apache-commons/
  inflating: OPatch/opatchauto-dir/opatchautocore/jlib/apache-commons/commons-compress-1.4.jar  
  inflating: OPatch/opatchauto-dir/opatchautocore/jlib/apache-commons/commons-cli-1.0.jar  
  inflating: OPatch/opatchauto-dir/opatchautocore/jlib/oplan_core.jar  
  inflating: OPatch/opatchauto-dir/opatchautocore/jlib/oracle.oplan.classpath.jar  
  inflating: OPatch/opatchauto-dir/opatchautocore/jlib/bundle.jar  
  inflating: OPatch/opatchauto-dir/opatchautocore/jlib/oplan_sample.jar  
  inflating: OPatch/opatchauto-dir/opatchautocore/jlib/Validation.jar  
   creating: OPatch/opatchauto-dir/opatchautocore/jlib/jaxb/
  inflating: OPatch/opatchauto-dir/opatchautocore/jlib/jaxb/activation.jar  
  inflating: OPatch/opatchauto-dir/opatchautocore/jlib/jaxb/jsr173_1.0_api.jar  
  inflating: OPatch/opatchauto-dir/opatchautocore/jlib/jaxb/jaxb-api.jar  
  inflating: OPatch/opatchauto-dir/opatchautocore/jlib/jaxb/jaxb-impl.jar  
  inflating: OPatch/opatchauto-dir/opatchautocore/jlib/automation.jar  
  inflating: OPatch/opatchauto-dir/opatchautocore/oplan.bat  
  inflating: OPatch/opatchauto-dir/opatchautocore/README.txt  
  inflating: OPatch/opatchauto-dir/opatchautocore/README.html  
   creating: OPatch/opatchauto-dir/opatchautodb/
   creating: OPatch/opatchauto-dir/opatchautodb/jlib/
  inflating: OPatch/opatchauto-dir/opatchautodb/jlib/oracle.oplan.db.classpath.jar  
  inflating: OPatch/opatchauto-dir/opatchautodb/jlib/oplan_db.jar  
  inflating: OPatch/emdpatch.pl      
   creating: OPatch/scripts/
  inflating: OPatch/scripts/opatch_wls.bat  
  inflating: OPatch/scripts/opatch_jvm_discovery.bat  
  inflating: OPatch/scripts/opatch_wls  
  inflating: OPatch/scripts/opatch_jvm_discovery  
  inflating: OPatch/operr            
  inflating: OPatch/operr_readme.txt  
  inflating: OPatch/operr.bat        
   creating: OPatch/opatchprereqs/
  inflating: OPatch/opatchprereqs/prerequisite.properties  
   creating: OPatch/opatchprereqs/oui/
  inflating: OPatch/opatchprereqs/oui/knowledgesrc.xml  
   creating: OPatch/opatchprereqs/opatch/
  inflating: OPatch/opatchprereqs/opatch/runtime_prereq.xml  
  inflating: OPatch/opatchprereqs/opatch/rulemap.xml  
  inflating: OPatch/opatchprereqs/opatch/opatch_prereq.xml  
  inflating: OPatch/opatch.bat       
   creating: OPatch/oplan/
   creating: OPatch/oplan/jlib/
   creating: OPatch/oplan/jlib/apache-commons/
  inflating: OPatch/oplan/jlib/apache-commons/commons-cli-1.0.jar  
   creating: OPatch/oplan/jlib/jaxb/
  inflating: OPatch/oplan/jlib/jaxb/jsr173_1.0_api.jar  
  inflating: OPatch/oplan/jlib/jaxb/jaxb-impl.jar  
  inflating: OPatch/oplan/jlib/jaxb/activation.jar  
  inflating: OPatch/oplan/jlib/jaxb/jaxb-api.jar  
  inflating: OPatch/oplan/jlib/Validation.jar  
  inflating: OPatch/oplan/jlib/oracle.oplan.classpath.jar  
  inflating: OPatch/oplan/jlib/OuiDriver.jar  
  inflating: OPatch/oplan/jlib/EMrepoDrivers.jar  
  inflating: OPatch/oplan/jlib/JMXDrivers.jar  
  inflating: OPatch/oplan/jlib/bundle.jar  
  inflating: OPatch/oplan/jlib/CRSProductDriver.jar  
  inflating: OPatch/oplan/jlib/oplan.jar  
  inflating: OPatch/oplan/jlib/ValidationRules.jar  
  inflating: OPatch/oplan/jlib/osysmodel-utils.jar  
  inflating: OPatch/oplan/jlib/automation.jar  
  inflating: OPatch/oplan/README.html  
  inflating: OPatch/oplan/README.txt  
  inflating: OPatch/oplan/oplan.bat  
  inflating: OPatch/oplan/oplan      
  inflating: OPatch/opatchdiag.bat   
  inflating: OPatch/README.txt       
 extracting: OPatch/version.txt      
   creating: OPatch/docs/
  inflating: OPatch/docs/cversion.txt  
  inflating: OPatch/docs/Prereq_Users_Guide.txt  
  inflating: OPatch/docs/FAQ         
  inflating: OPatch/docs/Users_Guide.txt  
[oracle@tnc2 grid]$ 
[oracle@tnc2 grid]$ 
[oracle@tnc2 grid]$ pwd
/u01/app/11.2.0/grid

[oracle@tnc2 grid]$ cd OPatch
[oracle@tnc2 OPatch]$ ls -ltr
total 156
-rwxr-x--- 1 oracle oinstall 31056 Aug 18  2015 opatch
-rw-r----- 1 oracle oinstall    27 Aug 18  2015 version.txt
drwxr-x--- 2 oracle oinstall  4096 Aug 18  2015 scripts
-rw-r----- 1 oracle oinstall  2915 Aug 18  2015 README.txt
drwxr-x--- 3 oracle oinstall  4096 Aug 18  2015 oplan
-rw-r----- 1 oracle oinstall  3177 Aug 18  2015 operr_readme.txt
-rwxr-x--- 1 oracle oinstall  4220 Aug 18  2015 operr.bat
-rwxr-x--- 1 oracle oinstall  3161 Aug 18  2015 operr
-rwxr-x--- 1 oracle oinstall  2576 Aug 18  2015 opatch.pl
-rwxr-x--- 1 oracle oinstall  9352 Aug 18  2015 opatchdiag.bat
-rwxr-x--- 1 oracle oinstall 10056 Aug 18  2015 opatchdiag
-rwxr-x--- 1 oracle oinstall 15184 Aug 18  2015 opatch.bat
drwxr-x--- 2 oracle oinstall  4096 Aug 18  2015 jlib
-rwxr-x--- 1 oracle oinstall 23695 Aug 18  2015 emdpatch.pl
drwxr-x--- 4 oracle oinstall  4096 Aug 18  2015 opatchprereqs
drwxr-x--- 3 oracle oinstall  4096 Aug 18  2015 crs
drwxr-x--- 5 oracle oinstall  4096 Aug 18  2015 ocm
drwxr-x--- 4 oracle oinstall  4096 Aug 18  2015 opatchauto-dir
drwxr-x--- 2 oracle oinstall  4096 Aug 18  2015 docs
[oracle@tnc2 OPatch]$ cd ocm
[oracle@tnc2 ocm]$ ls -ltr
total 41628
-rw-r----- 1 oracle oinstall      638 Aug 18  2015 ocm_platforms.txt
drwxr-x--- 2 oracle oinstall     4096 Aug 18  2015 doc
-rwxr-x--- 1 oracle oinstall 42560960 Aug 18  2015 ocm.zip
drwxr-x--- 2 oracle oinstall     4096 Aug 18  2015 lib
drwxr-x--- 2 oracle oinstall     4096 Aug 18  2015 bin
[oracle@tnc2 ocm]$ cd bin
[oracle@tnc2 bin]$ ls -ltr
total 12
-rwxr-x--- 1 oracle oinstall 9063 Nov 27  2009 emocmrsp
[oracle@tnc2 bin]$ 
[oracle@tnc2 bin]$ pwd
/u01/app/11.2.0/grid/OPatch/ocm/bin

Creating ocm.rsp file as follows # 
[oracle@tnc1 bin]$ ./emocmrsp -no_banner -output /u01/stage/file.rsp
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name: 

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  Y
The OCM configuration response file (/u01/app/oracle/file.rsp) was successfully created.

--Nikhil Tatineni--

--12C RAC -- 

Querys to monitor RAC

following few  Query's will help to find out culprits-  Query to check long running transaction from last 8 hours  Col Sid Fo...