> Installation Guide > Installing the Database

Installation Guide

     Previous  Next    Open TOC in new window    View as PDF - New Window  Get Adobe Reader - New Window
Content starts here

Installing the Database

This chapter provides an overview of the process of installing the database for use with WebLogic Network Gatekeeper.

Note: Individual files names are given in the form: filename<version>.type. As an example, the file referred to as jrockit-j2sdk<version>.bin.gz could have the full name jrockit-j2sdk1.4.2_05-linux-ia32.bin.gz

 

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 an Oracle 10g with RAC Database

Use these instructions if you are using Oracle 10g with RAC as your database. For more information on using WLS RAC with multidatasource configuration, see also http://download.oracle.com/docs/cd/E13222_01/wls/docs100/jdbc_admin/oracle_rac.html.

Note: This is the only database configuration supported for production environments that require High Availability.

1. Set up the base configuration

Oracle 10g RAC must be installed on dedicated servers not running in the cluster building up the WebLogic Network Gatekeeper.

  1. Install the Oracle 10g RAC database software using the instructions provided by Oracle.
  2. Download and install the latest patch set. This is important because significant improvements have been made with regards to fail-over.

2. Use these recommended configuration options

  1. Create the database using the Transaction Processing template.
  2. Use Automatic Storage Management.
  3. Use the Dedicated Server Mode for the database.
  4. Change the processes parameter:

    5. Define the number or of processes to be equal to (wlng.datasource MaximumCapacity + wlng.localTX.datasource MaximumCapacity) times the number of Network 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.

3. Define a database user

  1. Create a database user for Network 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 Network Gatekeeper Server.
  2. The user must be granted the following privileges:
    • CREATE SESSION
    • CREATE TABLE

Network 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 Network Gatekeeper for more information.

4. Configure the Oracle database for backup

  1. Configure the Oracle database for backup as described in the System Backup and Restoration Guide.

 

Install an Oracle 10g Single Instance Database

Follow the instructions in this section if you are using a Oracle 10g single instance as your database.

1. Set up the base configuration

The Oracle 10g instance must be installed on a dedicated server not running in the cluster building up the WebLogic Network Gatekeeper.

  1. Install the Oracle 10g database software using the instructions provided by Oracle.

2. Use these recommended configuration options

  1. Create the database using the Transaction Processing template.
  2. Use Automatic Storage Management.
  3. Use Dedicated Server Mode for the database.
  4. Change the processes parameter:

    5. Define the number or of processes to be equal to (wlng.datasource MaximumCapacity + wlng.localTX.datasource MaximumCapacity) times the number of Network 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.

3. Define a database user

  1. Create a database user for Network Gatekeeper with an allowed (unlimited) quota on its default tablespace, (the users tablespace). The user name and password for the user are later defined in each Network Gatekeeper Server.
  2. The user must be granted the following privileges:
    • CREATE SESSION
    • CREATE TABLE

Network 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 Network Gatekeeper for more information.

4. Configure the Oracle database for backup

  1. Configure the Oracle database for backup as described in the System Backup and Restoration Guide

 

Install a MySQL Database

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

Note: MySQL is not supported in environments that require High Availability.

MySQL can be installed either on a server in the cluster building up the WebLogic Network Gatekeeper 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 binaries (4.1.22 and higher bugfix releases for 4.1) for your platform. The binaries can be downloaded from http://www.mysql.com.

  1. Copy the installation file to the desired directory.
  2. 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 needed to install MySQL on some versions of Linux. You should check the specific instructions for your version. It assumes an installation directory of /usr/local:

    1. Create a group for mysql and add the mysql user to it:
      2. groupadd mysql
      useradd -g mysql mysql
    2. Run the installation script:
      3. cd /usr/local
      ln -s /usr/local/mysql-standard-<version> mysql
      cd mysql
      scripts/mysql_install_db --user=mysql
    3. Set ownership:
      4. chown -R root .
      chown -R mysql data
      chgrp -R mysql .
    4. Start the database:
      5. bin/mysqld_safe --user=mysql &
    5. 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 Network 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:
      6. [mysqld]
      set-variable=max_connections=400

      You should also add settings for default character set and storage engine:

      set-variable=default-character-set=<desired character set>

      Note: The recommended character ste is latin1. If you need to use a multibyte character, such as UTF-8, you should select the InnoDB storage engine.

      set-variable=default-storage-engine=<desired default storage engine>

      Note: The recommended default storage engine is MYISAM.
    6. 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 do configuration basics. (Use the default choice unless specified below):

  1. 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).
  2. Create the Network Gatekeeper database user and password and give it access privileges using the SQL command. You will need the 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. 
    3. GRANT ALL ON *.* TO <Network Gatekeeper database user>@'<ip-address>' IDENTIFIED BY '<password>'

    You must do this for every IP address in the cluster.

  3. Create the database for Network 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
    4. CREATE DATABASE <database name>
  4. Network 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 Network Gatekeeper for more information.

  Back to Top       Previous  Next