3 Replies Latest reply: Nov 28, 2012 11:42 PM by 966638 RSS

    Upgrade EBS database to 11.2.0.3

    966638
      Hi All,

      I am in stage of upgrading EBS database to 11.2.0.3 from 10.2.0.4

      Additional Patches : 4247037

      Blow is the readme of this patch

      % opatch apply
      #
      # Once applied with opatch, the files are located in $ORACLE_HOME/md/admin
      # and $ORACLE_HOME/md/support for patchset_mgdsys_validity.sql
      #
      # Patch Special Instructions:
      # ---------------------------
      # To install:
      #
      # connect to the database using sqlplus / as sysdba
      #
      # sqlplus> @catmgdidcode
      #
      # If checking with patchset_mgdapp_validity.sql you find invalid objects
      # please run $ORACLE_HOME/rdbms/admin/utlrp.sql which should resolve any issues.
      #


      Please clarify me on this

      1 - I just need to do "opatch apply" in 11.2.0.3 home or I hv to do the install step "sqlplus'/as sysdba' SQL>@11gR2Home/md/admin/catmgdidcode.sql before upgrading Database to 11.2.0.3 ?

      2 - install step "sqlplus'/as sysdba' SQL>@11gR2Home/md/admin/catmgdidcode.sql after DB upgrade ?



      Thanks,
      Sal