Oracle Database Setup

If you are not using an Oracle Database, then you must do the SQL*Server Database Setup or go back to Installation Table of Contents.

If you have not installed Oracle, you will need to do that first. See the installation documentation included with Oracle.

Once Oracle is up and running, you will need to do the following:

Create Tablespace and Schema

Create a tablespace that will be the tablespace for the Unanet tables and a temporary tablespace for the temp space. Consult with your DBA or System Administrator to determine the physical location that the datafiles will be located. Refer to Oracle documentation for optimal locations for datafiles for the best performance.

After you have created the tablespaces, you will need to create the Unanet schema. This schema should be created as Unanet. You will also have to grant connect and resource to the Unanet schema.

This is an example of creating a tablespace and a Unanet schema using Oracle on NT (logged in as a dba):

create tablespace temporary datafile 'c:\orant\database\temporary.dbf' size 25M default storage (pctincrease 0);
create tablespace unanet datafile 'c:\orant\database\unanet.dbf' size 100M default storage (pctincrease 0);

create user unanet identified by unanet default tablespace unanet temporary tablespace temporary;
grant connect to unanet;

Create Unanet Tables and Relationships (running the scripts)

To run these scripts, make sure you are logged into the Unanet Schema (Do not run these scripts in the SYSTEM Schema). The script is located in the Unanet Home Directory, under the /database/oracle directory. Login as the unanet user and run the following scripts in this order.

unanet.sql	Creates the Unanet Tables
FK.sql	Creates the Foreign Keys
CC.sql	Creates the Check Constraints
Idx.sql	Creates the Indexes
Views.sql	Creates the Views

Put the oracle.jar file in your Servlet Engine ClassPath

Make sure that the oracle.jar file (JDBC Driver), located in your Unanet Home directory, is in your Servlet Engine's ClassPath. See JRun Setup Procedure for information on setting up the ClassPath variable.

Configure database.properties File

Open the Unanet database.properties file located in the properties directory in your Unanet Home Directory on the web server. Comment out any lines that refer to using the i-Net or WebLogic JDBC Driver and use the Oracle parametes at the bottom of the file. Follow the documentaion notes in the database.properties file on setting up those parameters.

Back to Installation Table of Contents