2 Replies Latest reply: Mar 21, 2012 8:06 AM by Nicolas.Gasparotto RSS

    11gR2 manually upgrade

    Nicolas.Gasparotto
      In the documentation of database manual upgrade, description is wrong.
      The step 9 says to start the database in upgrade mode within the 11.2 binaries.
      The step 12 says to run the pre-upgrade tool utlu112i.sql
      Following that order, it just fails.
      # sqlplus / as sysdba
      
      SQL*Plus: Release 11.2.0.3.0 Production on Wed Dec 14 11:45:46 2011
      
      Copyright (c) 1982, 2011, Oracle.  All rights reserved.
      
      Connected to an idle instance.
      
      SQL> startup upgrade
      
      ORACLE instance started.
      
      Total System Global Area 2137886720 bytes
      Fixed Size                  2223208 bytes
      Variable Size             889193368 bytes
      Database Buffers         1073741824 bytes
      Redo Buffers              172728320 bytes
      Database mounted.
      Database opened.
      SQL> @$ORACLE_HOME/rdbms/admin/utlu112i.sql
      ERROR:
      ORA-04023: Object SYS.STANDARD could not be validated or authorized
      
      
      DECLARE
      *
      ERROR at line 1:
      ORA-04023: Object SYS.STANDARD could not be validated or authorized
      
      
      ERROR:
      ORA-04023: Object SYS.STANDARD could not be validated or authorized
      
      
      SQL>
      The pre-upgrade tool executed on the same database opened in normal mode within the 10g binaries (source version of my database) run successfully :
      # sqlplus / as sysdba
      
      SQL*Plus: Release 10.2.0.4.0 - Production on Wed Dec 14 11:47:49 2011
      
      Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
      
      Connected to an idle instance.
      
      SQL> startup
      ORACLE instance started.
      
      Total System Global Area 2147483648 bytes
      Fixed Size                  2085464 bytes
      Variable Size             855641512 bytes
      Database Buffers         1124073472 bytes
      Redo Buffers              165683200 bytes
      Database mounted.
      Database opened.
      SQL> @/appl/oracle/product/11.2.0/rdbms/admin/utlu112i.sql
      Oracle Database 11.2 Pre-Upgrade Information Tool 12-14-2011 11:48:46
      Script Version: 11.2.0.3.0 Build: 001
      ...
      <snipped>
      Whether the first is what the documentation instruct to do, the latter is obviously what it should be done. So the documentation is wrong here.

      Nicolas.
        • 1. Re: 11gR2 manually upgrade
          cshea
          Sometimes you can't see the forest for the trees. Thank you for noticing this error. In fact, Oracle recommends that you run the Pre-Upgrade Information Tool the night before upgrading. Since the Pre-Upgrade Information Tool utlu112i.sql generates the status of the database to be upgraded and provides a list of components and suggestions for fixes, this needs to be run before actually performing the upgrade. There may be problems that need to be fixed before running the upgrade.

          The utlu112i.sql script needs to be run from the new release's directory: ORACLE_HOME/rdbms/admin. I think the entire procedure should be looked at again.
          • 2. Re: 11gR2 manually upgrade
            Nicolas.Gasparotto
            The documentation has been updated accordingly.

            Thanks,

            Nicolas.