OCI @ iAS903: Solving the miracles 'round there (getting UnsatisfiedLinkError - no ocijdbc9)

.. and once again .. some more stuff on this oci thing -
specially needed when you attempt to use OCI in a J2EE App, deployed into your own container on iAS.

1) Stop opmn (by using "$ORACLE_HOME/opmn/bin/opmnctl stop")

2) open opmn.xml (in $ORACLE_HOME/opmn/conf)

3) search for an head-entry representing your container .. (for OC4J__Demos it look like the following)
    <oc4j instanceName="OC4J_Demos" gid="OC4J_Demos">

4) add the following entry between this tags (right before </oc4j>)
    <environment>
      <prop name="LD_LIBRARY_PATH" value="/home/oracle/9iAS903/lib"/>
    </environment>

    where LD_LIBRARY_PATH MUST point to $ORACLE_HOME/lib !

5) After this go to $ORACLE_HOME/dcm/bin and do
    dcmctl updateconfig -ct opmn

6) restart opmn by using opmnctl startall , that starts all containers/components and it will work now properly :)

Having questions? Feedback me on this entry Clemens Utschig