Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> 10G Upgrade HELP!

10G Upgrade HELP!

From: Johan Muller <johan.muller_at_gmail.com>
Date: Wed, 28 Mar 2007 13:08:07 -0600
Message-ID: <0d4301c7716c$6c1e9a20$e202020a@EFJDFW.local>


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-l
Received on Wed Mar 28 2007 - 14:08:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US