What are steps to be followed to use Oracle OCI drivers in BW
Article ID: KB0087109
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks | - |
| Not Applicable | - |
Description
Resolution:
Here are the steps to make these drivers work .
1. Set ORACLE_HOME environment variable
This refers to the folder where Oracle Client or Database has been installed.
Example D:\oracle9i , /home/oracle/orahome. This folder will have sub-folders such as bin, sqlj, network, rdbms, jdbc, jlib, lib, ...etc.
2. Add ORACLE_HOME\lib and ORACLE_HOME\bin to System PATH.
In our case add this to designer.tra.
## this will be prepended to tibco.env.PATH
tibco.env.CUSTOM_PATH C:/tibco/AE50/adapter/adadb/5.0/bin;C:/oracle/ora92/bin;C:/oracle/ora92/lib
3 Set CLASSPATH environment variable to use Oracle JDBC driver from ORACLE_HOME\jdbc\lib
In designer.tra ,
tibco.env.CUSTOM_CP_EXT C:/oracle/ora92/jdbc/lib;......
After these settings stop the designer and re-start.
Here are the steps to make these drivers work .
1. Set ORACLE_HOME environment variable
This refers to the folder where Oracle Client or Database has been installed.
Example D:\oracle9i , /home/oracle/orahome. This folder will have sub-folders such as bin, sqlj, network, rdbms, jdbc, jlib, lib, ...etc.
2. Add ORACLE_HOME\lib and ORACLE_HOME\bin to System PATH.
In our case add this to designer.tra.
## this will be prepended to tibco.env.PATH
tibco.env.CUSTOM_PATH C:/tibco/AE50/adapter/adadb/5.0/bin;C:/oracle/ora92/bin;C:/oracle/ora92/lib
3 Set CLASSPATH environment variable to use Oracle JDBC driver from ORACLE_HOME\jdbc\lib
In designer.tra ,
tibco.env.CUSTOM_CP_EXT C:/oracle/ora92/jdbc/lib;......
After these settings stop the designer and re-start.
Issue/Introduction
What are steps to be followed to use Oracle OCI drivers in BW
Feedback
Yes
No
Powered by
