3 Replies Latest reply: Feb 4, 2013 2:04 PM by Srini Chavali-Oracle RSS

    OWB considerations  after the db upgrade

    883677
      We did out of place db upgrade (moving to new oracle home) from 11.2.0.3.4 to 11.2.0.3.5. are there any special
      considerations needed for the OWB during or after the db upgrade?
      1225254.1 docs describes steps needed for owb for db upgrade from 11.2.0.2-> 11.2.0.3,
      but I don't see any docs from 11.2.0.3.x to 11.2.0.3.y.


      Thanks for your time.
        • 1. Re: OWB considerations  after the db upgrade
          Srini Chavali-Oracle
          Pl post OS details. 11.2.0.3.5 is a PSU patch and an out-of-place upgrade is not required. What was the reason for doing so ? What steps did you take to perform the upgrade ?

          HTH
          Srini
          • 2. Re: OWB considerations  after the db upgrade
            883677
            our os is Solaris
            Basically we create new oracle home.Patch that oracle home with latest psu(jan 2013)then we
            Move the database from the old oracle home to the new oracle home

            1.log in as Oracle
            2.. oraenv
            a.TS11
            b.sss
            i.shutdown immediate
            c.cd $ORACLE_HOME/dbs
            d.l TS11
            e.cp TS11 $NEW_ORACLE_HOME/dbs
            i.cd $ORACLE_HOME/network/admin
            ii.vi listener.ora
            1.edit the line for TS11 to listen for the new oracle home
            2.lsnrctl reload
            3.cp *.ora $NEW_ORACLE_HOME/network/admin
            iii.vi /var/opt/oracle/oratab
            iv.change the oracle home for TS11 to the new oracle home
            3.log out
            4.log in as oracle
            a.set the oraenv to TS11
            b.cd $ORACLE_HOME/rdbms/admin
            c.sss
            d.startup
            e.@catbundle.sql psu apply
            f.@utlrp

            in this process do we have to do anything special for owb

            update wb_rt_service_nodes set SERVER_SIDE_HOME='/ora/SW/db/11.2.0.3.5';
            update owbrtps set VALUE='/ora/SW/db/11.2.0.3.5';
            • 3. Re: OWB considerations  after the db upgrade
              Srini Chavali-Oracle
              880674 wrote:
              our os is Solaris
              Basically we create new oracle home.Patch that oracle home with latest psu(jan 2013)then we
              Move the database from the old oracle home to the new oracle home
              It is not clear as to why you take this approach - it is not required - all you need to do is apply the PSU patch to the current home by following the instructions in the PSU patch README.
              1.log in as Oracle
              2.. oraenv
              a.TS11
              b.sss
              i.shutdown immediate
              c.cd $ORACLE_HOME/dbs
              d.l TS11
              e.cp TS11 $NEW_ORACLE_HOME/dbs
              i.cd $ORACLE_HOME/network/admin
              ii.vi listener.ora
              1.edit the line for TS11 to listen for the new oracle home
              2.lsnrctl reload
              3.cp *.ora $NEW_ORACLE_HOME/network/admin
              iii.vi /var/opt/oracle/oratab
              iv.change the oracle home for TS11 to the new oracle home
              3.log out
              4.log in as oracle
              a.set the oraenv to TS11
              b.cd $ORACLE_HOME/rdbms/admin
              c.sss
              d.startup
              e.@catbundle.sql psu apply
              f.@utlrp

              in this process do we have to do anything special for owb

              update wb_rt_service_nodes set SERVER_SIDE_HOME='/ora/SW/db/11.2.0.3.5';
              update owbrtps set VALUE='/ora/SW/db/11.2.0.3.5';
              I do not have any experience with OWB, but pl see if these MOS Docs can help

              How to Change The OWB Home on the Same Server [ID 968712.1]
              How To Update Warehouse Builder After A Database Cloning [ID 434272.1]

              HTH
              Srini