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

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

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.

Quote:

---

Originally Posted by 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.

---

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.