3 Installing the Database

This chapter provides an overview of the process of installing the database for use with Oracle Communications Services Gatekeeper.

Outline of Installation

Although there are substantial differences among the installation procedures for each type of database, all installation types include the following basic steps:

Install the base software.
Configure the database for backup.
Set up a user account that Services Gatekeeper will use to access the database.
Give the user account appropriate privileges on the database.

Install Oracle with RAC or Oracle Single Instance Database Software

Use these instructions if you are using Oracle 10g or Oracle 11g with Real Application Clusters (RAC) or Oracle 10g or Oracle 11g Single Instance database software for your database.

The database must be installed on dedicated servers running outside the Oracle Communications Services Gatekeeper cluster.

Oracle RAC

Oracle with RAC is the only database configuration for supported production environments that require high availability.

For information on using Oracle WebLogic Server (OWLS) RAC with a multi data source configuration, see “Using WebLogic Server with Oracle RAC” in Oracle Fusion Middleware Configuring and Managing JDBC for Oracle WebLogic Server at:

http://download.oracle.com/docs/cd/E15523_01/web.1111/e13737/toc.htm

Installing the Database Software

To install the database software:

Install the Oracle database software using the instructions provided by Oracle.

During the installation process, choose these recommended configuration options:
- Create the database using the Transaction Processing template.
- Use the Dedicated Server Mode for the database.
- Change the processes parameter as follows:
  
  Define the number or of processes to be equal to (wlng.datasource MaximumCapacity + wlng.localTX.datasource MaximumCapacity) times the number of Services Gatekeeper servers in the cluster. MaximumCapacity is defined as a parameter in the connection pool settings for the JDBC datasources. Normally this value is 150 for both data sources.
Download and install the latest patch set.

Note:

In previous releases, Oracle Automatic Storage Management (ASM) was installed as part of the Oracle Database installation. With Oracle Database 11g Release 2 (11.2), Automatic Storage Management is part of an Oracle grid infrastructure installation, either for a cluster, or for a standalone server.

If you want to upgrade an existing Automatic Storage Management installation, then you must upgrade Automatic Storage Management by running an Oracle grid infrastructure upgrade. If you do not have Automatic Storage Management installed and you want to use Automatic Storage Management as your storage option, then you must complete an Oracle grid infrastructure installation before you start your Oracle Database installation.

The Oracle Grid Infrastructure Installation Guide 11gRelease2 (11.2) for Linux is at:

http://download.oracle.com/docs/cd/E11882_01/install.112/e17212/toc.htm

Configure the Oracle Database for Backup

Configure the Oracle database for backup as described in System Backup and Restore Guide, another document in this set.

Define a Database User for the Oracle Database

Create a database user for Oracle Communications Services Gatekeeper with an allowed (unlimited) quota on its default tablespace, (the users tablespace).The user name and password for the user are later copied to each Oracle Communications Services Gatekeeper Server.
The user must be granted the following privileges:
- CREATE SESSION
- CREATE TABLE

Oracle Communications Services Gatekeeper must be configured with an additional set of parameters to make it work correctly with the database. This action is performed during the domain configuration phase. See Configuring the Domain for Oracle Communications Services Gatekeeper for more information.

Install a MySQL Database

Follow the instructions in this section if you are using MySQL as your database.

MySQL can be installed either on a server in the Services Gatekeeper cluster or on a separate server. If it is installed in the cluster, it should be in the same server as the Network Tier.

Before you start, make sure you have the appropriate installation software for your platform. The software can be downloaded from

http://www.mysql.com

Copy the installation file to the desired directory.
Follow the installation instructions for your platform. These may vary widely depending on your platform and the type of binary you chose to download. You may need to be logged in with administrative privileges.

Linux

The following is a summary of the commands to install MySQL on some versions of Linux. Check the specific instructions for your version.These instructions assume an installation directory of /usr/local.

To install MySQL on Linux:

Create a group for mysql and add the mysql user to it:
```
groupadd mysql
useradd -g mysql mysql
```

Run the installation script:

cd /usr/local
ln -s /usr/local/mysql-standard-<version> mysql
cd mysql
scripts/mysql_install_db --user=mysql

Set ownership:

chown -R root .
chown -R mysql data
chgrp -R mysql .

Start the database:
```
bin/mysqld_safe --user=mysql &
```
Create a file, /usr/local/mysql/data/my.cnf, and set the following connection variable, so that max_connections is equal to (wlng.datasource MaximumCapacity + wlng.localTX.datasource MaximumCapacity) times the number of Oracle Communications Services Gatekeeper servers in the cluster. MaximumCapacity is defined as a parameter in the connection pool settings for the JDBC datasources. Normally this value is 150 for both datasources. For example:
```
[mysqld]
set-variable=max_connections=400
```
You should also add settings for default character set and storage engine.

The recommended character set is Latin1.
```
set-variable=default-character-set=<desired character set>
```
```
set-variable=default-storage-engine=<desired default storage engine>
```
Restart MySQL.

Windows

The Windows version is available with a GUI installer. Detailed instructions on using the installer are available at the MySQL web site. Unless you need to install the database in a non-standard location, you can select Typical Install.

You can also use the Instance Configuration Wizard to perform basic configuration. Use the default choice unless an alternative is specified below.

To install MySQL on Windows:

Select Detailed Configuration.
Select your appropriate usage type. The recommended usage type is Non-transactional Database.
To set concurrent connections, select Manual and choose a value equal to (wlng.datasource MaximumCapacity + wlng.localTX.datasource MaximumCapacity) times the number of Services Gatekeeper servers in the cluster. MaximumCapacity is defined as a parameter in the connection pool settings for the JDBC datasources. Normally this value is 150 for both datasources. Use the drop-down menu. You can change this value later if necessary.
Check Enable TCP/IP Networking (the standard port is fine unless you need to change it for your particular installation).
Select your default character set. The recommended character set is Latin1.
Select Install as Windows Service if you desire.
Select Modify Security Settings and set a root password.
Do not check Enable root access from remote machines.
Setting MySQL to autostart on reboot is recommended. Refer to the instructions for MySQL and the operating system. If you are installing on Windows, you can set up MySQL to run as a Windows Service (see above).
Create the Services Gatekeeper database user and password and give it access privileges using the SQL command. You will need this user name and password for the domain configuration stage of the installation. (For information on the various command level modes of accessing the MySQL server, see the documentation on the MySQL website.
```
GRANT ALL ON *.* TO <Gatekeeper database user>@'<ip-address>' IDENTIFIED BY '<password>'
```
You must do this for every IP address in the cluster.
Create the database for Services Gatekeeper. This name will be used in the Domain Configuration stage of the installation The standard way to do this is to issue the following SQL command.
```
CREATE DATABASE <database name>
```
Services Gatekeeper must be configured with an additional set of parameters to make it work correctly with the database. This action is performed during the domain configuration phase. See "Configuring the Domain for Oracle Communications Services Gatekeeper" for more information.