Oracle RCU 11.1.1.3.3 on Oracle XE Universal

OK, this post is going to be quick.

I am setting up my other notebook to run Oracle SOA Suite and start by installing a copy of Oracle XE Universal. All went well, I need a small footprint database on this old notebook.

To use OracleXE as the DB for SOA Suite, I only need to modify the following parameters.

alter system set open_cursors=500 scope=spfile;
alter system set processes=500 scope=spfile;

(also depends on with component you want to install, can be less)


I then downloaded Oracle RCU 11.1.1.3.3 (ofm_rcu_win32_11.1.1.3.3_disk1_1of1.zip) from Oracle and tried to install it with all options selected. To my dismay, I kept bumping into the problem saying JVM is not installed.

2010-10-05 21:34:56.846 ERROR rcu: oracle.sysman.assistants.rcu.backend.task.ActualTask::run: RCU Operation Failed
oracle.sysman.assistants.common.task.TaskExecutionException: RCU-6083:Failed - Check prerequisites requirement for selected component:OIM
Please refer to RCU log at Z:\Oracle\ofm_rcu_win32_11.1.1.3.3_disk1_1of1\rcuHome\rcu\log\logdir.2010-10-05_19-24\rcu.log for details.
Error: JVM is not installed on the Database.

Google is your friend, isn't that right? So I found the following thread on the Oracle forum.

http://forums.oracle.com/forums/thread.jspa?threadID=1130282

No solution as yet. Some people went back to RCU version 11.1.1.3.0 and installed successfully. I search further and found that OracleXE does not come with the DBMS_JAVA package, which only available in Oracle SE and EE. In theory, one can install DBMS_JAVA package into XE, but that is illegal. So I ended up unselect the offending components, and everything went well, with a few warnings. Here is the list of components that are unlikely to install successfully into OracleXE if you are going with RCU 11.1.1.3.3:

1) Identity Management
2) Portal and BI

When installing other components, I have also encountered problems with Enterprise Scheduler Service and the following errors are recorded in the oraess.log. I have ignored all these warnings and will fix them when it comes to surface.

Executing SQL statement: begin
  execute immediate 'grant select on dba_subscr_registrations to DEV_ORAESS';
exception
  when others then
    if sqlcode = -942 then
      null;
      raise;
    end if;
end;
JDBC SQLException - ErrorCode: 942SQLState:42000 Message: ORA-00942: table or view does not exist
ORA-06512: at line 7

JDBC SQLException handled by error handler

The reason is because OracleXE does not come with the table DBA_SUBSCR_REGISTRATIONS.

Information about this table is here.

http://download-west.oracle.com/docs/cd/B28359_01/server.111/b28320/statviews_5028.htm

Other than that, all was good. I can use OracleXE Universal database for RCU 11.1.1.3.3 with a few exceptions.

Cheers,