3 Replies Latest reply: Mar 30, 2013 7:47 AM by Srini Chavali-Oracle RSS

    Upgrade: Oracle 11.2.0.1.0 to 11.2.0.2.0 Steps.

    Prashant Dixit
      Hi,

      Require steps to upgrade Oracle 11.2.0.1.0 to 11.2.0.2.0
      Patch Number ?

      [oracle@prashant tmp]$ uname -a
      Linux prashant 2.6.18-164.el5 #1 SMP Tue Aug 18 15:51:54 EDT 2009 i686 i686 i386 GNU/Linux


      SQL> select banner from v$version;

      BANNER
      --------------------------------------------------------------------------------
      Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
      PL/SQL Release 11.2.0.1.0 - Production
      CORE 11.2.0.1.0 Production
      TNS for Linux: Version 11.2.0.1.0 - Production
      NLSRTL Version 11.2.0.1.0 - Production


      Pre-Upgrade Utility results:
      =========================

      SQL> @/u01/app/oracle/product/11.2.0/db_1/rdbms/admin/utlu112i.sql
      Oracle Database 11.2 Pre-Upgrade Information Tool 03-30-2013 15:16:39
      .
      **********************************************************************
      Database:
      **********************************************************************
      --> name: DMON
      --> version: 11.2.0.1.0
      --> compatible: 11.2.0.0.0
      --> blocksize: 8192
      --> timezone file: V11
      .
      Database already upgraded; to rerun upgrade use rdbms/admin/catupgrd.sql.

      PL/SQL procedure successfully completed.


      Thanks
      DMON

      Edited by: DMON on Mar 30, 2013 3:33 PM