Posts

Showing posts from July 29, 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