Installing the Oracle JDBC driver

To integrate the Avaya IR system with an Oracle database, you must install the JDBC driver for Oracle. Oracle provides JDBC drivers with the Oracle software package. Or, you can download JDBC drivers from the Oracle website.

To obtain the JDBC driver for Oracle:

1. To locate the driver on the system where Oracle is installed, or with the Oracle software, search the Oracle product documentation for JDBC driver information and file location.
2. To download the driver from the Internet site:
   1. You can go to the Oracle home page and search the Product area for JDBC drivers, or you can go directly to http://otn.oracle.com/software/tech/java/sqlj_jdbc/index.html.
   2. Select the Oracle release number that most closely matches the one you have.
   3. When the license information page is displayed, click I Accept.
   4. Select the appropriate Thin driver package that matches your Oracle release and JDK 1.3. The driver should be in the form of a .zip file. You do not need the DLL files or the OCI driver package.
3. Transfer the .zip file (using the ftp command or some other method) to the /tmp directory on the Avaya IR system.
4. Log on to the Avaya IR system as root.
5. Enter cd /tmp to go to the directory that contains the .zip file.
6. Enter cp filename.zip /vs/java/jdbc/lib/oracle.jar to copy the .zip file to /vs/java/jdbc/lib directory of the Avaya IR system and to rename it as oracle.jar.
7. Enter ls /vs/java/jdbc/lib to display the contents of the java directory and to verify that the oracle.jar file was successfully copied and correctly renamed.

To administer the Oracle DIP:

1. Enter /etc/init.d/tomcat stop

   The system displays messages indicating that the Tomcat engine is stopped.

2. Enter /etc/init.d/tomcat start

   The system displays messages indicating that the Tomcat engine is started.

3. Use a browser to access Avaya IR Web Administration and view the JDBC Administration - Main screen.
4. Click the Dipid of the data interface process (DIP) you want to administer.

   The JDBC Administration - Edit screen for the selected DIP is displayed.

5. Select Oracle as the database type.
6. Complete the remaining fields to specify the database for your system. Click the Help link to see individual field descriptions.
7. Select Test, and change settings if necessary.
8. Select Save.
9. Click Main to view the JDBC Administration - Main screen.
10. Click the option button associated with the new DIPID.
11. Click Start to make the connection between the Avaya IR system and the Oracle database.

© 2006 Avaya Inc. All Rights Reserved.