Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 10G Upgrade HELP!
What is the path of least resistance to upgrade an existing 10.1.0.3
database to 10.2.0.1?
The dbua blows up, and if it was not so close to being utterly pathetic, the result could end up as some typical unintended Ellison sponsored humor.
During the scripts that are run, the following sql is executed:
SQL> select to_number('MUST_BE_OPEN_UPGRADE') from v$instance where status =
'OPEN MIGRATE';
select to_number('MUST_BE_OPEN_UPGRADE') from v$instance where status =
'OPEN MIGRATE'
*
ERROR at line 1:
ORA-01722: invalid number
No surprises here: the dbua then pops a window with the following content:
<snip
ORA=01722: Invalid Number.
Upgrade failed due to running the step "Upgrading Oracle Server"
Snip>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 28 2007 - 14:08:07 CDT
![]() |
![]() |