ORA-01722: SELECT TO_NUMBER('Not ONLINE for READ/WRITE') from ts$
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

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

  1. #1
    Join Date
    Feb 2009
    Posts
    91

    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

  2. #2
    Join Date
    Feb 2009
    Posts
    91
    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.

  3. #3
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by PaulH View Post
    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
  •  



Click Here to Expand Forum to Full Width