6 Replies Latest reply: Aug 13, 2012 1:12 PM by Srini Chavali-Oracle RSS

    upgrade from 11.2..0.1 to 11.2.0.3  (linux )

    redologger
      hi guys,

      just feeling confuse from all the read up notes on upgrading from 11.2.0.1 - 11.2.0.3.

      The part where it mention that on the target database, one have to:
      1. download and install oracle 11g r2 in a new oracle home. and make sure there are no relinking errors.

      My question here is,

      - does it refer using the 11g r2 installer? and with that i install a new oracle binaries on a new Oracle home.

      My confusion starts here:

      i download the patchset which contain 7 separate files. If i am not wrong , 1of7 and 2of7 can be use as the ' full installation'? I don't really understand the README file.

      If i am wrong about the patchset , then where does these files come to use during the upgrading process?

      2. the part where one invoke DBUA to upgrade the database is from the new oracle home /bin right?

      I don't see anywhere on the upgrading process where these patchset i have downloaded to be use in any part.
        • 1. Re: upgrade from 11.2..0.1 to 11.2.0.3  (linux )
          Srini Chavali-Oracle
          redologger wrote:
          hi guys,

          just feeling confuse from all the read up notes on upgrading from 11.2.0.1 - 11.2.0.3.

          The part where it mention that on the target database, one have to:
          1. download and install oracle 11g r2 in a new oracle home. and make sure there are no relinking errors.

          My question here is,

          - does it refer using the 11g r2 installer? and with that i install a new oracle binaries on a new Oracle home.
          Yes - starting with 11.2.0.2, patchsets are not patchsets, but complete installs - you can install 11.2.0.2 and 11.2.0.3 directly - see this MOS Doc

          Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2 [ID 1189783.1]
          My confusion starts here:

          i download the patchset which contain 7 separate files. If i am not wrong , 1of7 and 2of7 can be use as the ' full installation'? I don't really understand the README file.
          Ideally you should download and unzip all 7 files - but I believe for database only install, the first two zip files are sufficient.
          If i am wrong about the patchset , then where does these files come to use during the upgrading process?

          2. the part where one invoke DBUA to upgrade the database is from the new oracle home /bin right?
          Yes - pl see upgrade documentation - http://docs.oracle.com/cd/E11882_01/server.112/e23633/toc.htm
          I don't see anywhere on the upgrading process where these patchset i have downloaded to be use in any part.
          Pl also see these MOS Docs

          Complete Checklist to Upgrade the Database to 11gR2 using DBUA [ID 870814.1]
          Things to Consider Before Upgrading to 11.2.0.3 to Avoid Poor Performance or Wrong Results [ID 1392633.1]

          HTH
          Srini
          • 2. Re: upgrade from 11.2..0.1 to 11.2.0.3  (linux )
            vlethakula
            If you unzip the 7 files, the following would be the directory structure


            bash-3.2$ ls -ltr
            total 24
            drwxr-xr-x 20 oracle dba 4096 Sep 22 2011 deinstall
            drwxr-xr-x 8 oracle dba 4096 Sep 22 2011 grid
            drwxr-xr-x 7 oracle dba 4096 Sep 22 2011 gateways
            drwxr-xr-x 6 oracle dba 4096 Sep 22 2011 examples
            drwxr-xr-x 8 oracle dba 4096 Sep 22 2011 database
            drwxr-xr-x 6 oracle dba 4096 Sep 22 2011 client


            p10404530_112030_platform_1of7.zip & p10404530_112030_platform_2of7.zip are for rdbms/database level
            p10404530_112030_platform_3of7.zip- -for oracle ASM,oracle restart


            2)Regarding DBUA--

            Starting from 11.2.0.3 , oracle recommends Out of Place upgrade. After unzipping the files go to database folder

            bash-3.2$ cd database
            bash-3.2$ ls -ltr
            total 64
            -rwxr-xr-x 1 oracle dba 5466 Aug 23 2011 welcome.html
            drwxr-xr-x 12 oracle dba 4096 Sep 18 2011 doc
            -rwxr-xr-x 1 oracle dba 3226 Sep 22 2011 runInstaller
            drwxr-xr-x 2 oracle dba 4096 Sep 22 2011 rpm
            drwxr-xr-x 2 oracle dba 4096 Sep 22 2011 response
            drwxr-xr-x 4 oracle dba 4096 Sep 22 2011 install
            drwxr-xr-x 14 oracle dba 4096 Sep 22 2011 stage
            drwxr-xr-x 2 oracle dba 4096 Sep 22 2011 sshsetup
            -rwxr-xr-x 1 oracle dba 28122 Sep 22 2011 readme.html

            Invoke the runInstaller and install the 11.2.0.3

            To upgrade the database:

            export ORACLE_HOME=<11.2.0.3 Home path>
            export PATH=$ORACLE_HOME/bin:$PATH
            type dbua----it should pick from 11.2.0.3 home

            dbua -silent -sid <sidname>
            • 3. Re: upgrade from 11.2..0.1 to 11.2.0.3  (linux )
              mitlor44
              I still dont see a full 11.2..0.1 to 11.2.0.3 (linux ) Database instruction upgrade document (as there are full instructions for PSU's). Is it simply load 11.2.0.3 into a new home and run DBUA ?
              • 4. Re: upgrade from 11.2..0.1 to 11.2.0.3  (linux )
                Srini Chavali-Oracle
                Yes ,11.2.0.2 and 11.2.0.3 are complete installs - they are not patchsets - see MOS Doc 1189783.1 reference above.

                Install 11.2.0.3, apply the latest PSU on top, then run DBUA to upgrade

                Best approach for Oracle database patching sequence to latest/required patchset along with CPU/PSU/any-other-one-off patch [ID 865255.1]
                Oracle Database Upgrade Path Reference List [ID 730365.1]
                Complete checklist for out-of-place manual upgrade from previous 11.2.0.N version to the latest 11.2.0.N patchset. [ID 1276368.1]

                HTH
                Srini
                • 5. Re: upgrade from 11.2..0.1 to 11.2.0.3  (linux )
                  mitlor44
                  Where is the full 11.2.0.3 install that includes the July 2012 PSU/CPU ? Cant find the download page
                  • 6. Re: upgrade from 11.2..0.1 to 11.2.0.3  (linux )
                    Srini Chavali-Oracle
                    The base 11.2.0.3 install does not include July 2012 CPU patches. For that, you will need to install the 11.2.0.3.3 PSU on top of 11.2.0.3

                    Pl see this MOS Doc

                    Quick Reference to Patchset Patch Numbers [ID 753736.1]

                    HTH
                    Srini