4 Installing and Configuring the Oracle Database

You can configure and tune your Oracle database to work with the Oracle Communications Billing and Revenue Management (BRM) system.

Topics in this document:

• Collecting Information Before Installing the Oracle Database Software

• Before Installing Oracle Database Software

• Installing and Configuring Your Oracle Database: Task List

• Installing the Database and Oracle DM on Separate Machines

• Modifying Your Oracle Database Installation

The person installing and configuring the Oracle database should be familiar with the following:

• UNIX commands and the UNIX operating system

• Database installation and configuration

• Network Management Systems

• SQL*Plus

• A UNIX text editor, such as vi or vuepad

Collecting Information Before Installing the Oracle Database Software

You will need the following documents while installing and configuring the Oracle database software:

• Oracle documentation:

  • Oracle operating system installation documentation.
  • The current release notes for your Oracle software.
  • The Oracle Administrator's Guide for instructions about configuring the network.

• A UNIX operating system reference guide.

About Capturing Information When Installing the Oracle Database Software

As you install the Oracle software, record the following important information. You will need this information later, when you install BRM.

• Host name of the Oracle database server.

• IP address of the Oracle database server.

• Port number of the Oracle database server.

• User login name and password.

• SID for the BRM database name (the BRM default is pindbhostname).

• Oracle database alias/Global Database Name (for example, pindbhostname.example.com).

Before Installing Oracle Database Software

Before installing the Oracle database software on your system, verify the following:

• Your system meets the minimum hardware and software requirements.

  See "System Requirements".

• You have all the software required to run BRM with an Oracle database.

  See "Database Requirements".

• You planned your Oracle database according to the guidelines in "Improving BRM Performance" in BRM System Administrator's Guide and "Database Configuration and Tuning".

Installing and Configuring Your Oracle Database: Task List

Installing and configuring your Oracle database for BRM includes these major tasks:

Note:

This list is not a substitute for the Oracle documentation or the most recent release notes for the database.

1. Installing the Oracle Database Software

2. Creating your BRM Database

3. Setting Environment Variables

4. Setting Your Database for BRM

Installing the Oracle Database Software

Install the Oracle database software according to the instructions in the Oracle documentation. When you install the software, pay particular attention to the following requirements.

• Install the Oracle Enterprise Edition.

• Choose a Customized installation. This option lets you configure Oracle with the AL32UTF8 database character set.

  Note:

  If you installed your database before referring to this document and used the Complete installation option, your database might have been installed with another character set. See "Modifying Your Oracle Database Installation" for information on how to modify your existing database.

• To configure discounts in BRM, install the following Oracle components:

  • Oracle XML DB. For more information, see the Oracle documentation.

  • Oracle XML Developer's Kit (XDK). For more information, see the Oracle documentation.

• Install Oracle JServer as part of the Oracle Database installation.

• To partition the tables in your BRM database, you must install the Oracle Partitioning component. See "Partitioning Tables" in BRM System Administrator's Guide.

Creating your BRM Database

Create your database by using the Oracle Database Configuration Assistant, which can be started automatically by the Oracle installer or started manually. If you start it manually, choose the Custom option.

Note:

BRM 12.0 supports AL32UTF8 as its default character set. It also continues to support the UTF8 character set for backward compatibility. The unicode character set AL32UTF8 is recommended for all new BRM 12.0 deployments.

As you create your database, pay particular attention to the following:

• Specify a Global Database Name using the format DatabaseName.DomainName, where DatabaseName is the database name and DomainName is the network domain in which the database is located. For example, pindbhostname.example.com. Most BRM databases use a DatabaseName of pindbhostname, but you can use another name.

  Note:

  You can modify your machine's default domain name in the $ORACLE_HOME/network/admin/sqlnet.ora file. For information, see your Oracle documentation.

• Specify a System Identifier (SID) for your database. For clarity, it should be the same as your Oracle database name. Most BRM databases are named pindbhostname, but you can use another name.

  • Set the Character Set to AL32UTF8.

  • Set the National Character Set to AL16UTF16.

For detailed instructions on how to create your database, see the Oracle documentation.

Setting Environment Variables

Set the 64-bit environment variables shown in Table 4-1.

Table 4-1 Environment Variables (64-Bit)

Operating System	Environment Variable	Value
Solaris	LD_LIBRARY_PATH_64	$ORACLE_HOME/lib
Linux	LD_LIBRARY_PATH	$ORACLE_HOME/lib

Setting Your Database for BRM

You have the option to configure your database manually or let the BRM installer configure your database automatically. Set up your database using one of the following options:

• Using the BRM Installer to Configure Your Database for Demonstration Systems

• Configuring Your Database Manually for Demonstration Systems

• Configuring Your Database Manually for Production Systems

Using the BRM Installer to Configure Your Database for Demonstration Systems

The BRM installer provides the option to automatically configure your database for demonstration or development systems. The installer configures your database by creating one data, one index, and one temporary tablespace; creating the BRM user; and granting connection privileges to the BRM user. If you want the BRM installer to configure your database, your Oracle installation is complete and you can go directly to "Installing BRM".

Configuring Your Database Manually for Demonstration Systems

To configure your database so that it uses additional or larger tablespaces, you can perform the following general tasks:

• Creating BRM Tablespaces

• Creating the BRM User for Oracle

Note:

You can also create the additional tablespaces and the BRM user during the BRM server installation.

Creating BRM Tablespaces

For a simple demonstration BRM system, you must create a minimum of three tablespaces for BRM. The following section shows the steps required to create the following tablespaces:

• pin00 (for data)

• pinx00 (for indexes)

• PINTEMP (for a temporary tablespace)

To create your tablespaces:

1. Create a directory for the tablespaces, such as /u02/oradata/pindb.

   This directory is referred to as table_location.

2. Connect to the Oracle database with SQL*Plus:

   % sqlplus system@DatabaseAlias
   Enter password: password

3. Create the data, index, and temporary tablespaces, making sure:

   • Data tablespaces are at least 600 MB with an extent ("next") size of 64 KB.

   • Index tablespaces are at least 400 MB with an extent size of 64 KB.

   • Temporary tablespaces are at least 100 MB with an extent size of 64 KB.

     SQL> create tablespace pin00 datafile 'table_location/pin00.dbf'
          size 600M reuse autoextend on extent management
          local uniform size 64K segment space management auto; 
       
     Tablespace created.
       
     SQL> create tablespace pinx00 datafile 'table_location/pinx00.dbf'
          size 400M reuse autoextend on default 
          storage( initial 64K next 64K pctincrease 0 );
       
     Tablespace created.
       
     SQL> create temporary tablespace PINTEMP tempfile 
          'table_location/PINTEMP.dbf'
          size 100M reuse autoextend on maxsize unlimited 
          storage(initial 64K next 64K pctincrease 0);
       
     Tablespace created.

Creating the BRM User for Oracle

Create a new BRM user who can access the Oracle database. The Oracle Data Manager (DM) gains access to the Oracle database by using the Oracle user pin. This Oracle user owns all the tables created and used by BRM.

Note:

If you are installing a multischema system, the primary and secondary database schemas must not use the same user name. If they do, multischema installation will fail.

Usually, the BRM database is set up at the SQL*Plus command prompt with the user name pin, but you can choose another name.

To create the BRM user:

1. Connect to the Oracle database with SQL*Plus:

   % sqlplus system@DatabaseAlias
   Enter password: password

2. Create the Oracle user pin, grant the user the resource to connect to Oracle with the user name pin, and allow pin access to the pin00 and PINTEMP tablespaces:

   SQL> create user pin identified by password;
     
   User created.
     
   SQL> grant resource, connect, create synonym, create any synonym to pin;
     
   Grant succeeded.
     
   SQL> alter user pin default tablespace pin00;
     
   User altered.
     
   SQL> alter user pin temporary tablespace PINTEMP;
     
   User altered.

3. Type exit to exit SQL*Plus.

Configuring Your Database Manually for Production Systems

To create a production system, you must create multiple tablespaces for the BRM data and indexes. For information on how to estimate your database size, create multiple tablespaces, and map the tablespaces to BRM tables, see "Database Configuration and Tuning".

Installing the Database and Oracle DM on Separate Machines

If you are installing your Oracle database and Oracle DM on separate machines, you must perform the following on the machine containing the Oracle DM:

1. Install the Oracle database client. For the list of supported database clients, see "BRM Software Compatibility" in BRM Compatibility Matrix.

   Note:

   For BRM installation to be successful:

   • Install the same version of the database server and database client software.

   • Install the 32-bit version and 64-bit version of the Oracle database client.

2. Modify the Oracle_home/network/admin/tnsnames.ora file to include entries for connecting to your BRM database.

   Note:

   If you are installing the BRM server and Pipeline Manager on separate machines, ensure that you include the database alias for connecting to the BRM database and the Pipeline Manager database in the Oracle_home/network/admin/tnsnames.ora file. The database alias for each database must be unique.

3. Use SQL*Plus to ensure that you can connect to your database.

For information, see the Oracle database software documentation.

Modifying Your Oracle Database Installation

If you installed your Oracle database before referring to this document and accepted the default options, your database installation might have defaulted to an unsupported character set. If this occurred, you must move your data to a database installation that supports the AL32UTF8 or the UTF8 character set. By default, BRM 12.0 uses the AL32UTF8 character set.

Note:

After you create a database, you cannot change the character set.

To export your existing data to a database installation that supports the AL32UTF8 character set:

1. Back up your existing database. See your Oracle documentation for details.

2. Uninstall your existing database. See your Oracle documentation for details.

3. Create a new Oracle database that supports the AL32UTF8 character set.

   See "Creating your BRM Database".

4. Use the Oracle Import utility to import your existing data to the new database.

   See your Oracle documentation for more information.