| 8174 to 9205 migration error [message #62631] |
Wed, 04 August 2004 05:49  |
bill
Messages: 75
Registered: November 1999
|
Member |
|
|
I am trying to manually upgrade from Oracle 8174 to 9205, on Solaris 2.8 (64bit)
I've managed to get to the point where I run the upgrade utility: @$ORACLE_HOME/rdbms/admin/u0801070.sql
When I run this script the following message is displayed:
DOC>#######################################################################
DOC>#######################################################################
DOC> The following statement will cause an "ORA-01722: invalid number"
DOC> error if the database has not been opened for MIGRATE.
DOC>
DOC> Perform "SHUTDOWN ABORT" and
DOC> restart using MIGRATE.
DOC>#######################################################################
DOC>#######################################################################
DOC>*/
SELECT TO_NUMBER(status) FROM v$instance
*
ERROR at line 1:
ORA-01722: invalid number
I tried to start the instance in "migrate" mode (SQL> startup migrate), the instance starts, but status = mounted.
Is this a red herring? any ideas ???????
Cheers
Bill
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
