Guenadi N Jilevski's Oracle BLOG

Oracle RAC, DG, EBS, DR and HA DBA BLOG

Using DBUA for upgrade to 11.2.0.2

Using DBUA for upgrade to 11.2.0.2

This is a brief post, originating from an earlier request, related to using DBUA for database upgrade to 11.2.0.2. Screenshots in the posts are on Windows platform but the concept is similar on Linux/Unix.

Start DBUA. Press Next.

Select the database to upgrade. Make sure that the database version supports direct upgrade. Here I have 11.1.0.7, 10.2.0.4 and 11.2.0.1 and all of them maintain direct upgrade. For details see (Oracle 11gR1 Upgrade Companion [ID 601807.1], 10g Upgrade Companion [ID 466181.1] and Oracle 11gR2 Upgrade Companion [ID 785351.1]). Here 11gR1 database is selected. If a direct upgrade is possible dbua is doing all the work for us and the screens are similar regardless of the database version as far as a direct upgrade is supported.

Accept the Warning. It is related to the Ultra Search de-support in 11gR2and the lack of ability to downgrade the OEM Database Control after the upgrade.

Select the degree of parallelism to be used for recompilation of invalid objects (equivalent of running the utlrp.sql), upgrade of the time zone and the option to backup the database.

Select the option to move the data files as part of the upgrade. Select a file system as a target location and press Next.

Review the Upgrade summary and press Finish for the upgrade to start.

The ordered list of actions and their progress appears on the screen. Wait until completion.

When 100% of the work is done press OK to see the results.

Here is a summary of the performed upgrade. Press Close to exit.

February 9, 2011 - Posted by | oracle

10 Comments »

  1. […] Using DBUA for upgrade to 11.2.0.2 […]

    Pingback by Top ORCLearning of the last week « Oracle DB 10g & 11g Tops | February 20, 2011 | Reply

  2. Hi
    is it possible to upgrade cross plate forme (OS unix to linux) from oracle 8i to 11g
    Kind regards

    Comment by Smain | April 10, 2011 | Reply

    • Hi,

      You can not upgrade directly. You can upgrade directly only from 9.2.4+ or later.

      For 8i you need intermediate release such as 9i/10g. For example 8.1.X->8.1.7.4->9.2.8->11 or 8.1.X->8.1.7.4->10g->11g

      For cross platform upgrade it all depends. You may first migrate to Linux and upgrade or use exp/imp or Goldengate otherwise.

      Regards,

      Comment by gjilevski | April 10, 2011 | Reply

  3. Guenadi, good quick write-up for doing a direct upgrade, but do you have a source (i.e. from Oracle) the write-up is based on?
    Thanks.

    Comment by Doug | May 6, 2011 | Reply

  4. send me information about upgradation of 9i to 11g manually
    thank you

    Comment by shrikant suvarnkar | May 22, 2011 | Reply

  5. I am upgrading Oracle 10.2.0.4 to 11.2.0.3 32bit database on linux platform, I am getting this message when i invoke DBUA
    “you do not have operating system authentication. Specify a user with SYSDBA privileges” I have done this upgrade before on 11g and not sure what i am missing, my oratab looks good so far:

    [orabbda@erpprod dbs]$ cat /etc/oratab
    BBDA:/d02/oracle/bbdadb/10.2.0:N

    its just weird, don’t know what parameter to change. Can you please suggest.

    Thanks,
    EJ

    Comment by EJ | April 7, 2012 | Reply

    • Hi,

      Which user do you run dbua? Can you make sure that the 11.2.0.3 user is a member of oinstall and dba groups? Is the 11.2.0.3 user the same as 10.2 user? Are they both oinstall and dba groups?

      What is the id command output from user that installed 10.2 and 11.2.0.3?

      Regards,

      Comment by gjilevski | April 7, 2012 | Reply


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: