Wednesday, January 25, 2012

Upgrading Oracle XE 10g to XE 11g

I've been using Oracle XE with several Lombardi Teamworks and WLE installs on my laptop. In order to run  latest IBM BPM 7.5+ software I need Oracle 11g, so XE 11g instead of XE 10g was a natural choice. Besides, I am a bit tired of DB2 ;)


The upgrade is very straightforward. I pretty much just followed the documentation from Oracle below
http://docs.oracle.com/cd/E17781_01/install.112/e18803/toc.htm#autoId25

Here are my notes:

- the script gen_inst.sql creates the sql files in OracleXE bin folder, next to sqlplus command
- there were "object exists" errors during the first import which did not seem to cause any issues later