-
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.
-
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.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|