This discussion is archived
2 Replies Latest reply: Mar 21, 2012 6:06 AM by Nicolas.Gasparotto RSS

11gR2 manually upgrade

Nicolas.Gasparotto Oracle ACE
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    The documentation has been updated accordingly.

    Thanks,

    Nicolas.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points