A while ago, I posted a few references for installing an 11i Vision instance, noting that it was "something you'll hopefully only need to do once." The fun doesn't stop with installing the software, though. Once you're done with the easy part you're left with:
- A desupported version of the database
- A desupported version of the Developer 6i tools (yes, even more obsolete than 6i's inherent obsolescence)
- JInitiator, which is also, you guessed it, desupported in favor of the standard Sun JDK.
What's the big deal? After all, 11i is in Extended Support mode, so why should it matter if an installed Vision instance has technical components that are a bit long in the tooth? Extended Support or not, there are probably one or two (hah) 11i instances still stubbornly kicking around out there. Presumably those instances have been patched up at least a little bit. If you're installing an 11i Vision instance for educational purposes, it might help to have something that (hopefully) more closely matches the modern state of affairs.
Below are some of my notes from when I dragged my 11i Vision instance forward from 2005 to 2011. Well, sort of. It is still on 32-bit Linux (OEL 5.5 in this case) . But the latest Developer 6i patch set has been applied, the database is at 126.96.36.199, Jinitiator's been replaced by JDK 6, and the AD tools are a bit more up-to-date. If you decide to use these notes, please understand that I intend them to be a rough guide, to save you some research time. I can't commit to detailed support of your effort. This is a reference, not a cookbook.
Not surprisingly, upgrading 11i components to this decade requires a lot of preparatory reading. Even if you're really familiar with the contents, it's worth revisiting these docs; some of them were changed as recently as July 2011. Here's a list that should cover everything for 32-bit OEL:
- Note 216550.1: Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0)
- 11gR2 database upgrade guide
- Note 881505.1: Interoperability Notes Oracle EBS 11i with Oracle Database 11gR2 (188.8.131.52)
- Note 216205.1: Database Initialization Parameters for Oracle Applications Release 11i
- Note 233044.1: About Oracle Applications DBA Minipack 11i.AD.I
- Note 783600.1: About Oracle Applications Technology 11i.ATG_PF.H.delta.7 (RUP 7)
- Note 858801.1: Known Issues On Top of 11i.ATG_PF.H.delta.7 (RUP7) - 6241631
- Note 165195.1: Using AutoConfig to Manage System Configurations with Oracle Applications 11i
- Note 316806.1: Oracle Applications Installation Update Notes, Release 11i (184.108.40.206) -- pay particular attention to the post-installation steps for relinking ASCP modules if you're using OEL/Redhat 5.4 and above. You may have already done this when installing Vision, but it's likely that a patch will overwrite adrelinknew.sh.
Forms, Java, and friends
- Note 125767.1: Upgrading Developer 6i with Oracle Applications 11i
- Note 401561.1: Using J2SE Version 6 with Oracle E-Business Suite 11i
- Note 290807.1: Deploying Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite 11i
While you're reading, if you want to get a jump on downloading the patches listed in these documents, I've listed them below. Please validate that the patch numbers still match the documents; the Developer 6i patch document in particular are subject to relatively frequent updates.
- 4547809 (220.127.116.11)
- 6880880 (18.104.22.168)
- 5495695 (22.214.171.124)
- 5391326 (126.96.36.199)
- 10098816 (188.8.131.52 RDBMS, parts 1, 2 and 6 only)
Forms, Java, and friends
- JDK 6 and JRE: Download from OTN
Order of operations
Tying all those notes and patches together looks daunting, but it's not actually that bad. Here's a quick summary of what needs to happen. Make sure to reference the relevant notes for detail. Please recall that we're working on a Vision "playground" here; some of my suggestions for speeding things up may not be comfortable in production.
- Start downloading all those fun patches! Here's a script to get you started, though you might need to make adjustments if patch requirements have changed.
- Upgrade the database from version 184.108.40.206 to 220.127.116.11, per note 216550.1 to make the 11gR2 upgrade smoother. Doesn't take long, and while the scripts are running, you can work on the next five steps. Just do the database pieces (Section 2, steps 3-9 & 12 should be sufficient) for now.
s_discostatus=disabledin the context file to be picked up by the next Autoconfig run; this is 2011 for heaven's sake.
- Install the JDK version 6 rpm as root.
- Install 18.104.22.168 software and examples, per Note 881505.1
- Create NLS data directory per note 881505.1
- Apply database patches (9776940,10149223, 10165223, and 10229719) to the 11gR2 ORACLE_HOME.
- Bring the newly-patched 22.214.171.124 database up and apply the AD.I.7 patch set. Use the nocompileb option; you have a utlrp step coming later.
- Adjust adrelinknew.sh script, per Note 316806.1.
- To avoid an error during the next round of patches, make an adjustment to the
IGW.IGW_AWARD_BUDGET_Ssequence. This can also be fixed with a patch, but why go through the trouble of getting a password-protected patch for this exercise?
SQL> alter sequence IGW.IGW_AWARD_BUDGET_S increment by 10000; SQL> select IGW.IGW_AWARD_BUDGET_S.nextval from dual; SQL> alter sequence IGW.IGW_AWARD_BUDGET_S minvalue 10000;
- Apply the rest of the Apps patches (Merge them all. Yes, seriously). Again, use the nocompiledb option, and noautoconfig as well; the JDK step below will take care of that for you.
- Apply Forms 19 patchset and the small pile of related Forms and 8.0.6 ORACLE_HOME patches as documented in Doc ID 125767.1 -- don't forget the relink steps afterward
- Run txkrun.pl per section 5.1 of note 401561.1 (use jdk_top=/usr/java/latest)
- Regenerate jar files for jdk6 (use force option)
- Deploy the JRE to the apps tier per note 290807.1
- Perform the database upgrade per note 881505.1. There's a lot to do there; follow the note closely.
- Find something else to do with your day; recompiling 140K invalid objects might take a while.
Next steps ("Exercise for the Reader")
What, you thought you were done? Now that all of the technical bits are more-or-less up-to-date, you can turn your attention to security patches and applications updates. That may seem like a lot for a playground Vision instance, and maybe it is. It's also too much to cover in this blog post, but check the following notes if you're an overachiever:
- Database CPU/PSU patching and Oracle Applications CPU patches. As an example of what you're looking for is Note 1315202.1: Oracle E-Business Suite Releases 11i and 12 Critical Patch Update Knowledge Document (July 2011). This is a quarterly "moving target," so that link will eventually be stale; check My Oracle Support for updates.
- Oracle Applications Extended Support Baseline patches. If you want to be really, really up-to-date, visit Note 883202.1: Patch Requirements for Extended Support of Oracle E-Business Suite Release 11.5.10 .