Skip Headers
Oracle® Communications Network Integrity Installation Guide
Release 7.2.2

Part Number E36031-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

3 Installing and Configuring the Oracle Database

This chapter describes the process of installing the Oracle database and configuring the Oracle Database for Oracle Communications Network Integrity.

Oracle Database Installation

Network Integrity must be installed in an Oracle Database tablespace.

See Table 2-2, "Network Integrity Software Requirements" for database requirements.

For information on installing Oracle Database, see the Oracle Database installation documentation.

Note:

Configure the Oracle Database with the XDB component.

Oracle Database Configuration

The Oracle database must be configured for Network Integrity. Specifically, this section covers the following:

Creating a Tablespace for Network Integrity

Create a tablespace according to the Oracle Database documentation. See Table 2-9, "Network Integrity Hardware Planning Guideline" for tablespace sizing guidelines.

Setting the Database Time Zone

Oracle Database must have the correct time zone setting, because Network Integrity uses the datatype TIMESTAMP WITH LOCAL TIME ZONE in its database schema.

See Oracle Database Globalization Support Guide for information and instructions on setting the time zone.

Note:

After Network Integrity has been installed, the database time zone cannot be changed. Ensure the time zone is correctly set before installing Network Integrity.

Creating the Database (MetaData) Schema for Network Integrity

The MetaData schema is an Oracle Fusion Middleware component that is required by Network Integrity. You create the schema using the Repository Creation Utility (RCU).

Note:

A new schema must be created for all new Network Integrity installations. Upgrade installations will use the schema created during the installation of that Network Integrity instance.

Note:

The Repository Creation Utility can run on the Linux (32 bit) and Microsoft Windows platforms. A Linux or Windows system can be used to remotely access and configure the database.

To create the schema for Network Integrity using RCU:

  1. Download Oracle Fusion Middleware Repository Creation Utility 11g for Linux x86 from the Network Integrity media pack from the Oracle software delivery Web site:

    https://edelivery.oracle.com

    For information on creating the MetaData schema, see Oracle Fusion Middleware Repository Creation Utility User's Guide.

  2. Extract the RCU package to a temporary directory (dir).

  3. Run the following command:

    dir/bin/rcu
    

    The Welcome screen of the Repository Creation Utility Installation wizard appears.

  4. Click Next.

    The Create Repository screen appears.

  5. Select Create and click Next.

    The Database Connection Details screen appears.

  6. Do the following:

    1. From the Database Type list, select Oracle Database.

    2. In the Host Name field, enter the IP address of the system hosting the database.

    3. In the Port field, enter the port number for the system hosting the database.

    4. In the Service Name field, enter the service name.

    5. In the Username field, enter the user name for the database user.

      Note:

      This user account must have the following privileges: CATALOG, CONNECT, Create User, Create Session, Grant Any Privilege, Grant Any Role, Select Any Table, Select any Dictionary.

      Caution:

      You must use the same user name and password when providing database user information during Network Integrity installation.
    6. In the Password field, enter the password for the database user.

    7. In the Role list, select SYSDBA.

    8. Click Next.

      A pop-up dialog box appears.

    9. Click OK.

    The Select Components screen appears.

  7. On the Select Components screen, do the following:

    1. Select Create a new Prefix, and enter the prefix value in the corresponding box.

      The prefix is any appropriate name for your schema. RCU adds a suffix to this name.

    2. Expand Oracle AS Repository Components.

    3. Expand AS Common Schemas and select Metadata Services and Enterprise Scheduler Service.

      Note:

      Oracle Internet Directory under Identity Management is a default selection and you cannot change this selection.
    4. Click Next.

      A pop-up dialog box appears.

    5. Click OK.

    The Schema Passwords screen appears.

  8. Select Use same password for all schemas.

  9. In the Password field, enter the password for the schema.

  10. In the Confirm Password field, enter the password for the schema again and click Next.

    The Map Tablespaces screen appears.

  11. Review the entries on the Map Tablespaces screen and click Next.

    The Summary screen appears.

  12. Review and verify the information you have provided and click Create.

    The Completion Summary screen shows details of the newly created repository.

  13. Click Close to exit the RCU Wizard.

Installing and Configuring Database Real Application Clusters

Oracle recommends Oracle Real Application Clusters (RAC) for high availability and scalability if your network data requires multiple databases for storage purposes. Refer to the Oracle Real Application Clusters documentation on the Oracle Technology Network Web site:

http://www.oracle.com/technology

Tuning the Database

Table 3-1 and Table 3-2 provide the recommended database parameters for tuning your database for the Network Integrity installation. These are the minimum requirements for Network Integrity.

Table 3-1 Database Creation Parameters

Parameter Recommended Value

SGA+PGA

At least 4 GB in total.

Oracle recommends that you use as much memory as you have available in the system, and also use Automatic Memory Management.

Processes

2000

Connection mode

Dedicated server

Redo log file size

1024 MB


Table 3-2 Database Initialization Parameters

Parameter Recommended Value

db_file_multiblock_read_count

16

distributed_lock_timeout

7200

dml_locks

9700

job_queue_processes

10

log_buffer

31457280

open_cursors

5000

parallel_max_servers

640

plsql_code_type

NATIVE


Installing the SQL*Plus Instant Client

Download SQL*Plus Instant Client from the Oracle Technology Network Web site.

http://www.oracle.com/technology

For information on installing and configuring SQL*Plus Instant Client, see the SQL*Plus Instant Client installation documentation.

If you are installing Network Integrity on the IBM AIX operating system, set the LIBPATH environment variable to the installation location of the SQL*Plus Instant Client.

If you are installing Network Integrity on the Linux operating system, set the LD_LIBRARY_PATH environment variable to the installation location of the SQL*Plus Instant Client.

Caution:

Install Oracle SQL*Plus on the Administration server from where you launch the Network Integrity installer.