Configuring topology search apps for use with Oracle databases

Edit online

If you are using an Oracle database for topology storage (that is, as the NCIM database), obtain the Oracle driver and point to the driver in the custom apps. You can skip this task if you are using a Db2® database. You can make this configuration while the products and Insight® Pack are still running.

Before you begin

Install and configure the supported products, and install and configure the Network Manager Insight Pack

Procedure

Obtain and install the Oracle driver from the Oracle website.
On the Operations Analytics - Log Analysis host, save the driver to $UNITY_HOME/wlp/usr/servers/Unity/apps/Unity.war/WEB-INF/lib.
Point the custom apps to the driver:
1. Open the following files for editing:
  - $UNITY_HOME/AppFramework/Apps/NetworkManagerInsightPack_v1.3.0.0/Network_Topology_Search/NM_Show_Alerts_Between_Two_Nodes_Layer2.sh
  - $UNITY_HOME/AppFramework/Apps/NetworkManagerInsightPack_v1.3.0.0/Network_Topology_Search/NM_Show_Alerts_Between_Two_Nodes_Layer3.sh
2. Insert the path to the Oracle driver into the classpath parameter.
  For example, change it from this classpath:
```
$UNITY_LIB_PATH/db2jcc.jar:$UNITY_LIB_PATH/log4j-1.2.16.jar
```
  To this classpath:
```
To: $UNITY_LIB_PATH/db2jcc.jar:$UNITY_LIB_PATH/ojdbc14.jar:$UNITY_LIB_PATH/log4j-1.2.16.jar
```
In the $UNITY_HOME/AppFramework/Apps/NetworkManagerInsightPack_V1.3.0.0/Network_Topology_Search/NM_EndToEndSearch.properties file, which point the Insight Pack to the NCIM database, ensure that the following properties for Oracle are correctly set.

ncp.dla.datasource.type

Enter oracle.

ncp.dla.datasource.driver

Enter the driver name, for example oracle.jdbc.driver.OracleDriver.

ncp.dla.datasource.url

Enter the URL, in the format jdbc:oracle:thin:@host:port:name, where name is the name of the database. For example, jdbc:oracle:thin:@192.168.1.2:1521:itnm