ORA-01722: SELECT TO_NUMBER('Not ONLINE for READ/WRITE') from ts$

[PaulH]

I am in the process of upgrading my database from Oracle 9i to 10.2.0.1.0
on Solaris.

I completed all the pre-upgrade scripts. I logged into the 10G database as
sqlplus '/ as sysdba'

startup upgrade

When I run the script catupgrd.sql I get the following error:

SELECT TO_NUMBER('Not ONLINE for READ/WRITE') from ts$
2 WHERE name='SYSAUX' AND online$ !=1;
SELECT TO_NUMBER('Not ONLINE for READ/WRITE') from ts$
*
ERROR at line 1:
ORA-01722: invalid number

Can somebody please explain the problem to me and tell me how to
rectify this issue.

Thanks in advance to all who answer this post.

Paul

[PaulH]

I found my problem. What happen is that I created the sysaux tablespace
in my 9i version of the database. When I ran the script utlu102i.sql it told me
I needed that tablespace.

I figured out that this tablespace had to be created in 10g instead of 9i.

Once created in 10g my error seem to go away.

[PAVB]

I found my problem. What happen is that I created the sysaux tablespace
in my 9i version of the database. When I ran the script utlu102i.sql it told me
I needed that tablespace.

I figured out that this tablespace had to be created in 10g instead of 9i.

Once created in 10g my error seem to go away.

As far as you create SYSAUX as ...

EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO

... it don't matter if you create it on Ora9i or Ora10g.