Description:
If you have a working setup of TIBCO BusinessWorks Collaborator (BWC) 5.6.0 installed with Oracle 10g, when upgrading your database to Oracle 11g (import/export data from old version (10g) to a newer version (11g)), after the database upgrade, when starting the Workflow server it fails to start with the error, "cannot open shared object file."


Symptoms:
Error: jcli ERROR: Thread:[Thread-5] ./IcDispatcher: error while loading shared libraries: libnnz10.so: "cannot open shared object file: No such file or directory".

Cause:
As TIBCO BusinessWorks Collaborator was installed with the Oracle 10g database and the database is upgraded later with 11g, but the Ic binaries were not upgraded to use Oracle 11g. When starting the Workflow server, BWC was looking for the 10g libraries and throws the error while loading shared libraries: libnnz10.so, and fails.

Workflow fails to start. Error: "IcDispatcher: error while loading shared libraries: libnnz10.so".

The following are to be performed after the database server upgrade for upgrading IC binaries to use Oracle 11g.

1). Run the TIBCO BusinessWorks Collaborator 5.6.0 installer to do a dummy install with an Oracle 11g dummy database on a different box. The installation will create the IC binaries for Oracle 11g.

2). Make a backup of your existing ‘BWC_home/server/<Server_name>/bin’ and 'BWC_home/server/<Server_name>/lib' directory. Name it  Originalbin and Originallib respectively.

3). Copy the bwc/5.6/sever/<server name>/bin  and  bwc/5.6/sever/<server name>/lib folder from the dummy installation and paste it into the existing BWC 5.6 server bwc/5.6/sever/<server name>/bin  and  bwc/5.6/sever/<server name>/lib .

4). Copy the files IcTSMstart* from the backuped bwc/5.6/sever/<server name>/Originalbin folder and paste it into bwc/5.6/sever/<server name>/bin .

5). Open the icconfig.xml file under the config directory of the Workflow server and go to the database to verify that it is correctly pointing to the required values (Oracle version should be 11, icora11.dll). To correctly tally these values, compare it with the values in the icconfig.xml file in the dummy version. Make sure to point the <IC_RDBMS_VERSION> to the correct Oracle 11g.

**********************************
<database>
            <IC_CONNECT_SEPARATOR>@</IC_CONNECT_SEPARATOR>
            <IC_DATABASE_DLL>icora11.dll</IC_DATABASE_DLL>
            <IC_DATABASE_NAME>not used</IC_DATABASE_NAME>
            <IC_DATABASE_PASSWORD>mLpKNYtb0AAA</IC_DATABASE_PASSWORD>
            <IC_DATABASE_TRAN_MODE>0</IC_DATABASE_TRAN_MODE>
            <IC_DATABASE_USER>KTRA574</IC_DATABASE_USER>
            <IC_RDBMS>ORACLE</IC_RDBMS>
            <IC_RDBMS_VERSION>11</IC_RDBMS_VERSION>
            <OR_TWO_TASK>orcl1</OR_TWO_TASK>
</database>
**********************************

6). Verify that the files env.sh, env.csh, IcTSMstartRepDaemon_env.sh,  and  IcTSMstartServer_env.sh are updated as per the upgraded Oracle version.

7). Source the env.sh file and start the Workflow and repository servers.