3 Replies Latest reply: Dec 3, 2008 6:16 AM by Mike Dietrich-Oracle RSS

    upgrade database from 10.2.0.1 to 10.2.0.4  error

    578069
      i upgraded my oracle 10g 10.2.0.1 database on windows XP to 10.2.0.4.
      after performing the upgrade, i started the database with startup upgrade; option.
      then to upgrade the database, i ran the following script;
      @D:\oracle\product\10.2.0\db_2\RDBMS\ADMIN\catupgrd.sql
      spool c:\patch.txt

      i am getting the following output in the log file:
      SQL> @D:\oracle\product\10.2.0\db_2\RDBMS\ADMIN\catupgrd.sql
      DOC>######################################################################
      DOC>######################################################################
      DOC>     The following statement will cause an "ORA-01722: invalid number"
      DOC>     error if the user running this script is not SYS. Disconnect
      DOC>     and reconnect with AS SYSDBA.
      DOC>######################################################################
      DOC>######################################################################
      DOC>#

      no rows selected

      DOC>######################################################################
      DOC>######################################################################
      DOC>     The following statement will cause an "ORA-01722: invalid number"
      DOC>     error if the database server version is not correct for this script.
      DOC>     Shutdown ABORT and use a different script or a different server.
      DOC>######################################################################
      DOC>######################################################################
      DOC>#

      no rows selected

      DOC>#######################################################################
      DOC>#######################################################################
      DOC> The following statement will cause an "ORA-01722: invalid number"
      DOC> error if the database has not been opened for UPGRADE.
      DOC>
      DOC> Perform a "SHUTDOWN ABORT" and
      DOC> restart using UPGRADE.
      DOC>#######################################################################
      DOC>#######################################################################
      DOC>#

      no rows selected

      DOC>#######################################################################
      DOC>#######################################################################
      DOC>     The following statements will cause an "ORA-01722: invalid number"
      DOC>     error if the SYSAUX tablespace does not exist or is not
      DOC>     ONLINE for READ WRITE, PERMANENT, EXTENT MANAGEMENT LOCAL, and
      DOC>     SEGMENT SPACE MANAGEMENT AUTO.
      DOC>
      DOC>     The SYSAUX tablespace is used in 10.1 to consolidate data from
      DOC>     a number of tablespaces that were separate in prior releases.
      DOC>     Consult the Oracle Database Upgrade Guide for sizing estimates.
      DOC>
      DOC>     Create the SYSAUX tablespace, for example,
      DOC>
      DOC>     create tablespace SYSAUX datafile 'sysaux01.dbf'
      DOC>     size 70M reuse
      DOC>     extent management local
      DOC>     segment space management auto
      DOC>     online;
      DOC>
      DOC>     Then rerun the catupgrd.sql script.
      DOC>#######################################################################
      DOC>#######################################################################
      DOC>#

      no rows selected


      no rows selected


      no rows selected


      no rows selected


      no rows selected


      Session altered.


      Session altered.


      Table created.


      1 row deleted.


      1 row created.


      Commit complete.


      TIMESTAMP
      ------------------------------------------------------------
      COMP_TIMESTAMP UPGRD__BGN 2008-12-01 12:46:12 2454802 45972


      Table created.


      Index created.


      Table created.


      Index created.


      Table created.


      Index created.


      Index created.


      Table created.


      Index created.


      Table created.


      Index created.


      Table altered.


      Index created.


      Table created.


      Index created.


      Table created.


      Index created.


      Table created.


      Table altered.


      Table altered.


      Table altered.


      Table altered.


      Table altered.


      Table altered.


      Table altered.


      Table created.


      Index created.


      1 row deleted.


      1 row created.


      Commit complete.


      Table created.


      Table truncated.


      1 row created.


      Table created.


      Index created.


      Table created.


      Index created.


      Table created.


      Table altered.


      Index created.


      Table created.


      Index created.


      Table created.


      Index created.


      Table created.


      Index created.


      Sequence created.


      Table created.


      Index created.


      Sequence created.


      Table altered.


      Table altered.


      Table altered.


      Table altered.


      Table altered.


      Index created.


      Table altered.


      633 rows updated.


      633 rows updated.


      Table altered.


      Table created.


      Index created.


      Index created.


      Index created.


      Table created.


      Index created.


      Index created.


      Table created.


      Sequence created.


      Table created.


      Index created.


      Index created.


      Table created.


      Index created.


      Table created.


      Index created.


      Table altered.


      Table altered.


      Table altered.


      Table altered.


      Table altered.


      Table altered.


      Table altered.


      0 rows deleted.


      Table created.


      Index created.


      Table created.


      Index created.


      Table created.


      Index created.


      Index created.


      Sequence created.


      Table created.


      Index created.


      1 row deleted.


      1 row created.


      Commit complete.


      0 rows deleted.


      0 rows deleted.


      Commit complete.


      Table altered.


      Table altered.


      Table created.


      Index created.


      Table created.


      Index created.


      Table created.


      Table altered.


      Table altered.


      System altered.


      no rows selected


      0 rows updated.


      System altered.


      Table created.


      Index created.


      Table created.


      Index created.


      0 rows deleted.


      Commit complete.


      System altered.


      0 rows deleted.


      Commit complete.


      System altered.






      Function created.

      No errors.
      SELECT version_script AS file_name FROM DUAL
      *
      ERROR at line 1:
      ORA-20000: Upgrade re-run not supported from version
      ORA-06512: at "SYS.VERSION_SCRIPT", line 45

      i am getting the follownig two errors, how can i correct these error, so that my database is upgraded.

      ERROR1:
      OC>#######################################################################
      DOC>#######################################################################
      DOC>     The following statements will cause an "ORA-01722: invalid number"
      DOC>     error if the SYSAUX tablespace does not exist or is not
      DOC>     ONLINE for READ WRITE, PERMANENT, EXTENT MANAGEMENT LOCAL, and
      DOC>     SEGMENT SPACE MANAGEMENT AUTO.
      DOC>
      DOC>     The SYSAUX tablespace is used in 10.1 to consolidate data from
      DOC>     a number of tablespaces that were separate in prior releases.
      DOC>     Consult the Oracle Database Upgrade Guide for sizing estimates.
      DOC>
      DOC>     Create the SYSAUX tablespace, for example,
      DOC>
      DOC>     create tablespace SYSAUX datafile 'sysaux01.dbf'
      DOC>     size 70M reuse
      DOC>     extent management local
      DOC>     segment space management auto
      DOC>     online;
      DOC>
      DOC>     Then rerun the catupgrd.sql script.


      ERROR2:
      No errors.
      SELECT version_script AS file_name FROM DUAL
      *
      ERROR at line 1:
      ORA-20000: Upgrade re-run not supported from version
      ORA-06512: at "SYS.VERSION_SCRIPT", line 45