Appendix D: Oracle Installation and Administration

This section provides information and guidelines about installing, configuring, and managing an Oracle database server to use with the Administration Server. This must be performed before installing the Administration Server.

To perform these steps, you must be a database administrator with permission to create a new instance.

Overview of the Oracle Client/Server Architecture

Each Oracle service is identified by a global database name and an Oracle system identifier referred to as the SID (see Figure D-1). The Oracle global database name is the full name of a database that uniquely differentiates it from other databases in a network domain. One global database name can represent several database instances. The global database name is also known as the service name. The SID distinguishes the database instance from other instances on the same machine.

An Oracle instance is a running Oracle database made up of memory structures and background processes. Each instance is associated with an SID. With the Oracle Parallel Server, multiple instances can exist on different machines for a single database.

The policy database is a set of database schemas in which all data is stored. A database schema is a collection of objects associated with a particular schema name. The objects include tables, views, domains, constraints, assertions, privileges, and so on.

A datafile is an Oracle term for a file that contains the contents of logical database structures, such as tables and indexes. One or more datafiles form a logical unit of storage called a tablespace. A datafile is associated with only one tablespace and only one database.

A tablespace is a logical portion of a database used to allocate storage for table and index data. Each tablespace corresponds to one or more physical datafiles. Every Oracle database has a tablespace called SYSTEM and may have additional tablespaces. A tablespace is used to group related logical structures. The database username or user ID is a login that is given permission by the database administrator to access a specific database instance. This user is also called the schema owner, that is, the owner of the schema objects such as tables, views and triggers that are created.

Oracle Database System Requirements

Table D-1 Oracle Setup Requirements
Requirement	Description
Software version	Oracle database server: Version 9i Release 2 (9.2.x) Version 10g Release 1 (10.1.2, 10.2.0.2, 11.1.0.6)
Server platform	Any platform supported by Oracle.
Memory	As required by Oracle server installation (64 MB minimum).
Disk space for the starter database	As required by Oracle server installation, plus space required to store policy data; 500 MB recommended.
Disk space for Oracle software	Refer to the installation guide for the Oracle Database Server.
Disk space for policy database	Minimum of one tablespace with 250 MB of free space is required.

Installing and Configuring the Oracle Database

This section provides additional instructions for installing and configuring an Oracle database for use with the Administration Server.

Installing the Oracle Database

This section provides recommendations for installing the Oracle database and creating a database instance. The Oracle installation program automatically starts the Database Configuration Assistant, which is used to create a database instance. If the database is already installed, skip this procedure and go to Creating an Oracle Database Instance.

To install the Oracle database and create a database instance, perform these steps:

When the Oracle Universal installer runs, select the install options as specified in Table D-2. For other installer options, accept the default settings or modify as desired.

Table D-2 Recommended Selections in the Oracle Universal Installer
Installer Option	Recommended Selections
Available Products	Oracle 9i Database 9.2.x Version 10g Release 1 (10.1.2, 10.2.0.2, 11.1.0.6)
Installation Types	Enterprise Edition
Database Configuration	General Purpose
Oracle MTS Recovery Service Configuration Port Number	Accept the default setting.
Global Database Name (For Oracle 10g only)	The full Oracle database name that distinguishes the database from any other databases in a network domain, for example `asi.ales`, where `asi` is the database name and `ales` is the domain.
Database System Identifier (For Oracle 10g only)	The Oracle system identifier (SID).
Passwords (For Oracle 10g only)	The install program creates four user accounts, `SYS`, `SYSTEM,` `SYSMAN`, and `DBSNMP` and assigns default passwords. During installation, you are prompted to change these passwords. For security reasons, Oracle recommends specifying new passwords for these user accounts. Be sure to record these entries — you will need them later.

For Oracle 9i, when the Database Configuration Assistant starts, step through the screens using the settings specified in Table D-3.

Note:

For Oracle 10g, the Database Configuration Assistant is run after the installer program (just as it is with Oracle 9i). However, it does not prompt you for input.

Database Configuration Assistant Screen

Recommended Setting

Step 1 of 8: Operations

Select Create a database and click Next.

Step 2 of 8: Templates

Select New Database and click Next.

Note:

This selection specifies the template to use to create the instance of the database.

Step 3 of 8: Database Identification

Specify the Global Database Name, for example asi.ales.

Specify the SID, for example asi, and click Next.

Step 4 of 8: Database Features

Set these check boxes to on: Oracle spatial, Oracle Ultra Search, Oracle Data Mining, Oracle OLAP, Example Schemas and all check boxes below, and click Next.

Step 5 of 8: Database Connection Options

Select Dedicated Server Mode, and click Next.

Step 6 of 8: Initialization Parameters

Select the Memory tab, click the Custom radio button, and set the parameters as follows:

Shared Pool: 69 MB
Buffer Cache: 24 MB
Java Pool: 32 MB
Large Pool: 8 MB
PGA: 24 MB

Click Next.

Step 7 of 8: Database Storage

Click Next. The Database Assistant creates the database.

Database Configuration Assistant

Set passwords for the SYS and SYSTEM accounts and record these entries — you will need them later. Click Exit. The Database Assistant completes.

End of Installation

Click Exit.

(Oracle 9i) Do one of the following to set the system PATH environment variables:

For Windows systems, set the environment variables as shown in Listing D-1.
For Solaris and Linux systems, refer to the Oracle installation guide for that operating system.

Listing D-1 Oracle 9i System PATH Environment Variable Settings for Windows

<drive>:\oracle\ora920\bin;
C:\Program Files\Oracle\jre\1.3.1\bin;
C:\Program Files\Oracle\jre\1.1.8\bin;

(For Oracle 10g) do one of the following to set environment variables:

On Microsoft Windows, the installer program automatically sets the environment variables.
On Solaris or Linux, refer to the Oracle installation guide for that operating system.

To allow remote connections to the database instance, proceed to Configuring the Oracle Database Listener for Remote Connections.

Configuring the Oracle Database Listener for Remote Connections

If the Administration Server will be installed on a separate machine, you must configure an Oracle listener.

Start the Oracle Net Configuration Assistant and respond to the assistant screens as directed in Table D-4.

Table D-4 Oracle Listener Setting
Assistant Screen	Setting
Welcome	Select Listener configuration and click Next.
Listener	Select Add and click Next.
Listener Name	Enter listener name, for example, `asi`, and click Next.
Select Protocols	Select TCP and click Next.
TCP/IP Protocol	Select the standard port 1521 and click Next.

To verify that the listener is configured, open a command window on a remote system and enter: SQLplus system/password@listenername.

where password is the password assigned to the SYSTEM account and listenername is Oracle listener name, for example asi.

Creating an Oracle Database Instance

This section provides guidance on how to create and configure additional database instances after the Oracle database software is installed. For detailed instructions, consult the Oracle documentation.

To start the Oracle Database Configuration Assistant, click Start>Programs>Oracle-<OraHome>Configuration and Migration Tools>Database Configuration Assistant, where OraHome indicates the version of the software. The Database Configuration Assistant starts.
Step through the screens and select settings as specified in Table D-3.

Administering an Oracle Policy Database

Using the Database Administration Utilities with Oracle

Table D-5 describes the batch and shell files provided for database administration. The files are located in the <BEA_HOME>\ales32-admin\bin directory.

Table D-5 Oracle Database Administration Utilities
File Name	Used to:
policyexporter.bat policyexporter.sh	Exports policy data. See the Policy Managers Guide for information on how to export policy. The `dbtype` is the type of database, Sybase or Oracle.
install_ales_schema.bat install_ales_schema.sh	Installs the policy database schema. See Installing the Policy Database Schema for information on how to install the database schema.
uninstall_ales_schema.bat uninstall_ales_schema.sh	Uninstall the policy database schema from the database server. The parameters for this script are the same as the `install_ales_schema` script.

Backing Up an Oracle Database

The policy database should be backed up at regular intervals and before uninstalling or re-installing the policy database. If necessary, contact a database or system administrator to assist with this process.

For Oracle database backup instructions, see the Oracle Backup and Recovery Guide.

Administration Server Installation Guide