Installing RME - Configuring Content Manager Records Enabler with an Oracle 10g database

You must configure the IBM® Content Manager Records Enabler system to work with an Oracle 10g database.

Before you configure IBM Content Manager Records Enabler, verify that you already completed the following steps:

You migrated your data to Oracle 10 on the IBM Records Manager database.
You upgraded and configured DB2® Content Manager on Oracle 10.
You upgraded and configured IBM Records Manager on Oracle 10g.
You upgraded IBM Content Manager Records Enabler on Oracle 10g.

To configure IBM Content Manager Records Enabler with an Oracle 10g database:

In the WebSphere® Application Server administrative console, ensure that the JDBC provider and the data source of IBM Content Manager Records Enabler refer to Oracle 10g:
1. In the WebSphere Application Server administrative console, click Resources > JDBC > JDBC providers.
2. Select the IBM Content Manager Records Enabler server name, for example, cmresvr.
3. Click the JDBC driver name, for example, RMEOracleJdbcProvider.
4. In the configuration page, verify that the following values refer to Oracle 10g directories:
  Classpath
  
  Example: oracle_home/jdbc/lib/ojdbc14.jar. If an environment variable such as ${ORACLE_JDBC_DRIVER_PATH} is used to define the class path, then ensure that the Scope refers to the correct Oracle 10g JDBC library path oracle_home/jdbc/lib.
  
  Native lib path
  
  Example: oracle_home/lib32 for AIX or oracle_home\bin for Windows.
5. Click Apply.
6. Click Save.
7. From the same JDBC driver, click Data sources in the Additional Properties area and select the data source name, for example, RMEJdbcICMNLSDB.
8. In the configuration page, verify that the Datasource Helper Classname specifies the correct Oracle 10g helper class:
  - For WebSphere Application Server V6, select the Oracle10g data store helper: com.ibm.websphere.rsadapter.Oracle10gDataStoreHelper.
9. Click Apply.
10. Click Save.
11. Restart WebSphere Application Server.
In the WebSphere Application Server administrative console, verify that the shared library for the cmresvr and rmecmhost servers to refer to the Oracle 10g JDBC driver.
1. In the WebSphere Application Server administrative console, expand Environment and click Shared Libraries.
2. Select the IBM Content Manager Records Enabler server cmresvr.
3. Click the shared library cmresvr.RMEServerLib.
4. In the configuration page, verify that the following value refers to Oracle 10g directories:
  Classpath
  
  Example: oracle_home/jdbc/lib/ojdbc14.jar. If an environment variable such as ${ORACLE_JDBC_DRIVER_PATH} is used to define the class path, then ensure that the Scope refers to the correct Oracle 10g JDBC library path oracle_home/jdbc/lib.
5. Click Apply.
6. Click Save.
7. In the WebSphere Application Server administrative console, expand Environment and click Shared Libraries.
8. Select the IBM Content Manager Records Enabler server rmecmhost.
9. If you have more than one IBM Content Manager Records Enabler shared library, verify those class paths too.
10. Click the shared library rmecmhost.RMECMHostLib.
11. In the configuration page, verify that the following value refers to Oracle 10g directories:
  Classpath
  
  Example: oracle_home/jdbc/lib/ojdbc14.jar. If an environment variable such as ${ORACLE_JDBC_DRIVER_PATH} is used to define the classpath, then ensure that the Scope refers to the correct Oracle 10g JDBC library path oracle_home/jdbc/lib.
12. Click Apply.
13. Click Save.
14. Restart WebSphere Application Server.