Create Oracle 9i Database

Overview

This note describes how to deploy an Oracle 9i Database.

Requirements

We assume you already have complete a binary install of the database.

It is possible to do the deployment onto a different configuration, but see here if you have a different configuration.

Get creation scripts

The configuration scripts for the database are contained in the Application-RLS bundle in the File Upload section of savannah. Download this bundle and unpack it. When run, these scripts will download additional resources from the portal as required. It's contents are the following:

    Applications/
        RLS/
            RlsDump/
            as-deployment/
            cern-specific/
            db-creation/
            db-deployment/

• db-creation A script to create the directories and data files for the actual database. Running this is a pre-requisite to deploying actual users into the database.

Database Creation

To create the Oracle database, you use the scripts in the db-creation sub-directory. There is one main script, called db-creation which has the following usage:

    usage: db-creation --sid SID --password PWD [ --base PATH ] [-v]

    Options:
          --sid       SID     The system identifier of the db to set as default
          --password  PWD     The system password
          --base      PATH    The path to ORACLE_BASE.  Defaults to
                              "/ORA/dbs01/oracle"
          --v                 verbose mode

    Example:
           ./db-creation --sid rls1 --password foo

Running this script will produce a lot of output on your screen, as it runs the SQL to create all the tables, users and views in the database. It should take about 20 minutes to run.