WARNING: This web is not used anymore. Please use PDBService.CreateOracle9iDatabase instead!
 

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/
These contain the following:

  • 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
The --sid argument will be used as the ORACLE_SID value for the deployment, along with the corresponding system password (--password option).

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.

Edit | Attach | Watch | Print version | History: r2 < r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r2 - 2005-11-29 - unknown
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    PSSGroup All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2020 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback