Guenadi N Jilevski's Oracle BLOG


Using DBUA for upgrade to

Using DBUA for upgrade to

This is a brief post, originating from an earlier request, related to using DBUA for database upgrade to 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, and 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


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

    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->>9.2.8->11 or 8.1.X->>10g->11g

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


      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?

    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 to 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

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


    Comment by EJ | April 7, 2012 | Reply

    • Hi,

      Which user do you run dbua? Can you make sure that the user is a member of oinstall and dba groups? Is the 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


      Comment by gjilevski | April 7, 2012 | Reply

Leave a Reply to gjilevski Cancel reply

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

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

Google photo

You are commenting using your Google 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 )

Connecting to %s

%d bloggers like this: