Install and Configure the Unanet Database for Oracle

Once you have met the Pre-installation requirements, you can create your Unanet database.  This page details instructions on creating the Unanet database using Oracle.  If you are using SQL Server follow those installation instructions instead.  

Important!!  Please make sure you are installing Unanet in a supported database version -- see System Requirements for more information.

The topics covered on this page include:

Create Tablespace and User

In order to create Oracle objects inside your Oracle system, you can use Oracle's DBA Studio or Enterprise Manager client tools.  Of course, you can also use server manager if you are familiar with the syntax for the following commands:

Note:  The unanet user will also need to have the CREATE VIEW privilege.  Beginning with Oracle v10g, this privilege may no longer be included by simply granting connect and resource, you may need to explicitly grant the CREATE VIEW privilege as well.


You will need to work with the DBA to determine the appropriate size for your installation.  As a rough guideline, we estimate you will need 12 MB of disk space per user in determining the unanet datafile size parameter.  This estimate assumes a standard usage pattern and allows for the storage of 2 years worth of history per person.  Your actual usage may vary, and the DBA will need to monitor space usage on a periodic basis.

Multiple Tablespace Note:  If you need an advanced setup for performance reasons, you may create multiple tablespaces to separate index data and/or table data -- but be advised that the Unanet create and migrate scripts do not directly support this and you will have to edit these scripts before running them.

Create Unanet Schema

In order to create the Unanet schema, Unanet provides a database script.  You can run the script from Oracle's SQL*Plus or SQL Worksheet client tools. The main script is named sqlunanet.sql.  When you run the sqlunanet.sql script, make sure you are logged into the Unanet Schema (Do not run this script in the SYSTEM Schema).   The script is located in the Unanet Home Directory, under the /database/oracle directory.   For best results, use SQL Plus to run the script. Also, the Notes below for additional information prior to running the script.

Note:  If you have created a non-standard tablespace setup, you will need to make backup copies of these scripts and modify them to meet your custom needs.

Note:  Whenever the sqlunanet.sql script is run, it first tries to delete any Unanet objects that may already be in the database.  For this reason, it is important that you never re-run this script if there is data in the database that you want to keep.  

Note: If you think you might need to re-run a part of the sql script, contact the Unanet support staff first and we'll help you decide the best course of action.  Remember, always back up your database before performing any maintenance activities!!

Login as the unanet user and run the sqlunanet.sql script.  


Creates the Unanet Tables, Foreign Keys, Check Constraints, Indexes and Views. This script actually calls the following scripts, also in the same directory:

Creates a set of procedures used to help build the database schema.  These will be deleted upon completion of the install process.

Calls all the delete scripts to make sure that no old Unanet objects are in the database (this create process makes sure it is running in a "clean" schema).

Creates all the tables.

Creates all the primary keys.

Creates all the foreign keys.

Creates all the check constraints.

Creates all the views.

Loads all the static data into the tables.

Loads the default Export Templates into the tables.

Creates all the indexes.

Removes the utility procedures.

Creates all the indexes.


After the script has run, you will see a log file created in the same directory where you started SQL Plus.  This file stores the results of the script run against the database.  Please do not delete the log file -- it is very useful to the Unanet support staff in the event of a problem.  

   *******   !! IMPORTANT !!   *******

Please review the sqlunanet.log file checking for any errors before you continue with the installation.  

If you encounter ANY ERRORS, please contact Unanet Support, DO NOT CONTINUE WITH THE INSTALLATION.

The log file is described in more detail below:



This log file contains all the output from the deletion process that runs before anything is created.  If this is the first time you have created the Unanet schema, you can ignore any error or warning messages that you see in this log file.


This log file contains all the output from the creation process.  It is very important that you check this log file for any warnings or errors.   If it does contain any errors, contact the Unanet support staff and email them both log files.


Note:  Once your Unanet Administrator has loaded the various tables within Unanet, you may want to update the Database statistics (compute or estimate) to achieve improved system performance.  This is particularly important after a version migration.  See your DBA for additional information regarding this maintenance activity.

Having Problems?

If you are experiencing difficulties contact Unanet Customer Support for assistance.

Next Step

Step 4 -- Install/Configure Java

Once the Database objects are created, you are ready to move on to Step 4 -- Installing and configuring Java.