WARN,04 Sep 2012 13:19:22,248,[XELLERATE.GC.PROVIDER.RECONCILIATIONTRANSPORT],FILE SUCCESSFULLY ARCHIVED : /home/oracle/Oracle/910Middleware/OIM9101/datadumps/import/HR_OIM_090412.txt
ERROR,04 Sep 2012 13:19:23,348,[XELLERATE.SERVER],Class/Method: tcUSR/eventPreInsert Error :Mandatory fields are blank or null.
ERROR,04 Sep 2012 13:19:23,349,[XELLERATE.SERVER],Class/Method: tcDataObj/save Error :Insertion of dataobject into database failed
ERROR,04 Sep 2012 13:19:23,350,[XELLERATE.DATABASE],Class/Method: tcDataBase/rollbackTransaction encounter some problems: Rollback Executed From
java.lang.Exception: Rollback Executed From
 at com.thortech.xl.dataaccess.tcDataBase.rollbackTransaction(Unknown Source)
 at com.thortech.xl.dataobj.tcDataObj.rollback(Unknown Source)
...
 at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
ERROR,04 Sep 2012 13:19:23,351,[XELLERATE.SERVER],Class/Method: tcDataObj/save Error :Wrong SQL operation for save
ERROR,04 Sep 2012 13:19:23,352,[XELLERATE.DATABASE],Class/Method: tcDataBase/rollbackTransaction encounter some problems: Rollback Executed From
java.lang.Exception: Rollback Executed From
 at com.thortech.xl.dataaccess.tcDataBase.rollbackTransaction(Unknown Source)
 at com.thortech.xl.dataobj.tcDataObj.rollback(Unknown Source)
 at com.thortech.xl.dataobj.tcDataObj.doRollback(Unknown Source)

I did some investigation and for whatever reason, I needed to upgrade from 9.1.0.1 to 9.1.0.2

Click here to download the same patch in this demonstration.

Incremental patches process over time so click here to view all the associated patches for OIM 10g.

I always forget, though make sure you export your JAVA path.

export PATH=$JAVA_HOME/bin:$PATH

Once you've downloaded the patch, proceed with the following:

[oracle@localhost Scripts]$ pwd
/home/oracle/Desktop/oim9.1.0.2/p8484010_9102_Generic.zip_FILES/db/oracle/Scripts
[oracle@localhost Scripts]$ ./oim_db_upg_9101_to_9102.sh

## Enter the ORACLE HOME directory or Press [Enter] to
accept the default /home/oracle/app/oracle/product/11.2.0/dbhome_1 as ORACLE_HOME.


## Current database is orcl
Do you want to continue with this database [y,Y,n,N] ?

y

## Enter the valid directory,having Oracle Identity Manager Db Schema upgrade scripts

/home/oracle/Desktop/oim9.1.0.2/p8484010_9102_Generic.zip_FILES

## Enter the Oracle Identity Manager Db schema user name

xelsysadm

## Enter the password for Oracle Identity Manager (xelsysadm) user



Starting Oracle Identity Manager Db Schema Upgrade....

Oracle Identity Manager Db Schema Upgrade Successful....

Starting Oracle Identity Manager Db Stored Procedure Upgrade.....

Oracle Identity Manager Db Stored Procedure Upgrade Successful....
Please see logs at /home/oracle/Desktop/oim9.1.0.2/p8484010_9102_Generic.zip_FILES/db/oracle/log/oim_db_upg_9101_to_9102
.

Once you've completed the step above, begin by starting up the LoadXML.sh file with the JDBC path and Username/Password passing as arguments.

./LoadXML.sh jdbc:oracle:thin:@172.16.128.128:1521:orcl xelsysadm Password1

I then made sure the patch I installed was also updated within the Database

With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@localhost setup]$ sqlplus xellerate/Password1

SQL*Plus: Release 11.2.0.1.0 Production on Tue Sep 4 16:19:53 2012

Copyright (c) 1982, 2009, Oracle. All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name: xelsysadm
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select XSD_VALUE from XSD where XSD_CODE='XL_BUILD_NUMBER';

XSD_VALUE
-------------
9.1.0.1865.28

SQL>

About the author