Kevin Kempf's Blog

December 15, 2009

More to upgrades

Filed under: 10g, 11g, Oracle — kkempf @ 9:38 am

With the end of Premier support for RDBMS 10.2 coming in July of next year (Officially from Oracle here), I started doing some more 10g to 11g migrations.  6 upgrades later, I am happy to say that it’s been successful across the board.  In the interest of brevity, I’m going to skip all the detailed checks outlined in 837570.1 and cut to the chase:  Make sure you have a backup before you start the upgrade.   The rest of this assumes a vanilla database, meaning you don’t have any of the issues outlined in 836570.1.  Like you don’t have duplicate items in SYS and SYSTEM schemas, you are smart enough to already have a SYSAUX tablespace, you understand what the new connect role is, you don’t have TIMESTAMP WITH TIMEZONE Datatypes in the database, etc, etc, etc.

  1. Install 11g in a new home
  2. Run the 11g_home/rdbms/admin/utlu112i.sql script against your 10gR2 database and see what it says.   In my case:
    1. Archivelog formats now require %r in them
    2. user/background/core dump destination parameters are depricated (I simply removed them and went with the new defaults)
    3. minimum sga_target of 700M & minimum java_pool_size of 128M (I allowed this for the upgrade, then cut it back)
    4. Empty the recycle bin: purge dba_recyclebin
    5. exec dbms_stats.gather_schema_stats vs. SYS and SYSMAN schemas
  3. Run 10g_home/rdbms/admin/utlrp to recompile invalids
  4. Shutdown the 10g instance
  5. Source the new Oracle Home so $ORACLE_HOME points to the 11.2 home
  6. Copy the new/modified initSID.ora file to the 11g_home/dbs directory; copy the listener.ora and tnsnames.ora file from the 10g home to the 11g_home/network/admin directory
  7. startup upgrade pfile=initSID.ora (11g version)
  8. Run 11g_home/rdbms/admin/catupgrd.sql  (catalog upgrade, this script takes quite a while to finish, about 1.5 hours on a wimpy 2 CPU VM)
  9. Run 11g_home/rdbms/admin/utlu112s.sql (the doc incorrectly identifies this as utlu111s.sql)
  10. Run 11g_home/rdbms/admin/utlrp.sql (recompile)
  11. Check your compatible parameter (in my case I simply changed it from to and restart the database if required
  12. Start your listener
Oracle Database 11.2 Post-Upgrade Status Tool           12-15-2009 09:34:18
Component                                Status         Version  HH:MM:SS
Oracle Server
.                                         VALID  00:31:18
JServer JAVA Virtual Machine
.                                         VALID  00:11:33
Oracle Workspace Manager
.                                         VALID  00:01:00
OLAP Analytic Workspace
.                                    OPTION OFF  00:00:00
OLAP Catalog
.                                    OPTION OFF  00:00:00
.                                    OPTION OFF  00:00:00
Oracle Enterprise Manager
.                                         VALID  00:12:34
Oracle XDK
.                                         VALID  00:01:29
Oracle Text
.                                         VALID  00:01:17
Oracle XML Database
.                                         VALID  00:04:45
Oracle Database Java Packages
.                                         VALID  00:00:33
Oracle Multimedia
.                                         VALID  00:04:37
.                                    OPTION OFF  00:00:00
Oracle Expression Filter
.                                         VALID  00:00:21
Oracle Rule Manager
.                                         VALID  00:00:11
Gathering Statistics
.                                                                00:15:12
Total Upgrade Time: 01:24:57


  1. Hi

    I need to upgrade the database of EBS 11i , which is to , can you help me out with this, i need to just upgrade the database but not the whole EBS.

    Comment by db — November 12, 2010 @ 4:47 pm

    • I have not upgraded to 11.2 in my 11i environment. It was a deliberate decision, based on some feedback I’d heard via OAUG recommending to get to R12 first, then go to 11.2. That said, it can’t be that different than going to 11.1, and I did that. It’s explained in this blog here:

      Comment by kkempf — November 12, 2010 @ 7:18 pm

RSS feed for comments on this post.

Sorry, the comment form is closed at this time.

Blog at