Posts

Showing posts from July, 2014

Oracle 11g:Upgrade 11.2.0.x version to latest 11.2.0.4.1 patchset:Upgrade

Image
Oracle 11g:Upgrade 11.2.0.x version  to latest 11.2.0.4.1 patchset:Upgrade  Once We finish the installation of 11.2.0.4 on different then we will go further for upgrade database. For Installation, http://oracle-mssql-dba.blogspot.in/2014/07/oracle-11gupgrade-1120x-version-to.html Step 2.Run Pre-upgrade Information Tool  SQL>spool /utlu112i.log SQL>@ORACLE_HOME/rdbms/admin/utlu112i.sql Check timezone .Need to upgrade if it is require by tool. Step 3.Run dbupgdiag.sql.Check any invalid objects in dba_registry. Valid all Dba_registry object by running utlrp.sql sql>sqlplus / as sysdba sql>@?/rdbms/admin/utlrp.sql Step 4.Backup database. a)take rman backup with latest spfile & controlfile. b)take cold backup by mount the database after shutdown normal db. Step 5.Shut down database normal. SQL>shutdown normal. Step 6.Set New Oracle_HOME,PATH,LIBRARY_PATH.Copy tnsnames.ora,listener.ora,spfile,pfile & password to new oracle_home

Oracle 11g:Upgrade 11.2.0.x version to latest 11.2.0.4.1 patchset:Installation

Image
Oracle 11g:Upgrade 11.2.0.x version  to latest 11.2.0.4.1 patchset For Applying patchset on oracle 11.2.0.1 database.We need to 1st download all the requiesite downloads from support.oracle.com. Before upgrade start,Download the below files from oracle.com 1.p18139609_112040_Linux-x86-64 2.p13390677_112040_Linux-x86-64_1of7 3.p13390677_112040_Linux-x86-64_2of7 4.p13390677_112040_Linux-x86-64_3of7 5.p13390677_112040_Linux-x86-64_4of7 6.p13390677_112040_Linux-x86-64_5of7 7.p13390677_112040_Linux-x86-64_6of7 8.p13390677_112040_Linux-x86-64_7of7 Now, follow below steps to complete the task of upgradation of 11.2.0.1 to 11.2.0.4 patchset. Estimated time for downtime is around 10hours. Step1.Install Oracle 11.2.0.4 yo different home. a) Create directory inside current home mkdir /u01/oracle/product/11.2.0.4 chown -R oracle:dba /u01/oracle/product/11.2.0.4 b)unzip the above all .zip files to particular loc