Ask the Expert

DBUA throws "not a valid xml file" error during upgrade

While trying to run the DBUA to upgrade an Oracle 9.2 database to 10.2 I get the error:
For input string: "" 
Upgrade configuration file
/oracle/SND/102_64/cfgtoollogs/dbua/SND/upgrade2/upgrade.xml 
is not a valid xml file 
and the DBUA does not run. Please help as this is my first Oracle upgrade ever!

    Requires Free Membership to View

There have been reported issues when using the DBUA to upgrade to a 10.2 database if the SYS user's temporary tablespace in the Oracle 9.2 database is dictionary managed rather than locally managed. Check to see if this is the case by first querying the DBA_USERS view to determine which tablespace has been defined as temporary for SYS:
select temporary_tablespace from dba_users where username='SYS';
Then check to see whether this tablespace is locally or dictionary managed:
select tablespace_name, extent_management from dba_tablespaces;
If the temporary tablespace defined for the SYS user is a dictionary managed tablespace, try creating another locally managed tablespace and assign it to be the temporary tablespace for SYS as follows:
alter user sys temporary tablespace <new tablespace name here>;
Try the upgrade again using the DBUA.

This was first published in April 2007

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: