An Oracle blog – Amardeep Sidhu

March 27, 2008

Upgrade 10gR1 to 10gR2 – DBUA error

Filed under: Troubleshooting — Sidhu @ 10:53 pm
Tags: , , ,

Today I was upgrading 10gR1 to 10gR2 (10.2.0.1) on Linux x86. The upgrade went almost fine (except that I had to install one package and change few kernel parameters) but while running DBUA to upgrade databases, it gave an error:

Could not get database version from the Oracle Server component. The CEP file rdbmsup.sql does not provide the version directive

and

Start of root element expected. Upgrade Configuration file
'C:\Oracle10g2\cfgtoollogs\dbua\test\upgrade5\upgrade.xml' is not a valid XML file.

I searched in the metalink and found that this all happens due to customized glogin.sql file which was there in my case also. And removing that customization made DBUA rock 🙂

You might want to check here, here and here.

2 Comments »

  1. Hello Amardeep,

    Can you help with the resolution of the error while upgrading Oracle 9i to 10g. The Oracle and the tnslistener are up and running.

    Also, kindly let me know how to make sure that there is an issue with glogin.sql.

    The error from the silent.log file is given below.
    —————————

    For input string: “”

    Upgrade Configuration file `/home/oracle/oracle10g/OraHome10g/cfgtoollogs/dbua/arcsight/upgrade5/upgrade.xml` is not a valid XML file.
    The Upgrade Assistant failed in executing any query on the database arcsight. Oracle Home /home/oracle/OraHome1 obtained from file /etc/oratab was used to connect to the database. Either the database is not running from Oracle Home /home/oracle/OraHome1 or its not in OPEN status. Correct the error and run the Upgrade Assistant again.
    Could not proceed with Upgrade due to errors.
    Fix the errors and restart again!

    ——-

    Regards,
    Manoj

    Comment by Manoj Abraham — October 10, 2008 @ 5:29 pm | Reply

  2. Hi Manoj

    Also, kindly let me know how to make sure that there is an issue with glogin.sql.

    Simply look for any customization in the glogin.sql like setting custom SQL prompt or anything else.

    About the error, are you running the DBUA in silent mode ?

    Also are you able to connect to the database manually from the shell prompt ?

    Comment by Amardeep Sidhu — October 11, 2008 @ 6:18 pm | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Theme: Rubric. Get a free blog at WordPress.com

%d bloggers like this: