Preparing Oracle

See the Oracle Waveset 8.1.1 Release Notes for supported database server versions.

To Prepare Oracle for Use with Waveset

1. Install Oracle or confirm the connection to an Oracle database.

2. Connect to the Oracle instance as a user with privileges to create users and tables.

3. Create the database. To do this:

   1. Copy the create_waveset_tables.oracle script to a temporary location. This script is located in the db_scripts directory in the Waveset installation package, and also in the idm\sample directory if Waveset is already installed.

   2. Modify the create_waveset_tables.oracle script:

      1. Change the user password.

      2. Change the path for DATAFILE to point to the location for your waveset.dbf data file.

      Your database administrator may want to modify the script to meet site-specific requirements for backup, replications, disk allocation, distribution, or other considerations.

   3. Create the new tables by using the following command:

      On Windows

      sqlplus dbausername/dbapassword @create_waveset_tables.oracle

      On UNIX

      sqlplus dbausername/dbapassword @create_waveset_tables.oracle

4. Download the JDBC driver to use with your version of Oracle.

   See Notes on Configuring Databases and Downloading Supporting JAR Files for more information.

   Later, during the Waveset installation process, you will install the JDBC driver to the $WSHOME/WEB-INF/lib directory on your application server.

Configuring lh setup for Oracle RAC

If you are using Oracle RAC as your Waveset repository and you are connecting with the thin driver, use the following URL parameter format in lh setup:

jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=OFF)
(ADDRESS=(PROTOCOL=TCP)(HOST=host01)(PORT=1521))(
ADDRESS=(PROTOCOL=TCP)(HOST=host02)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=host03)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=PROD)))