| Oracle® Communications Services Gatekeeper Installation Guide Release 5.1 E37539-02 |
|
|
PDF · Mobi · ePub |
| Oracle® Communications Services Gatekeeper Installation Guide Release 5.1 E37539-02 |
|
|
PDF · Mobi · ePub |
This chapter provides an overview of the process of installing the database for use with Oracle Communications Services Gatekeeper.
Although there are substantial differences among the installation procedures for each type of database, all installation types include the following basic steps:
Installing the base software.
Setting up a user account that Services Gatekeeper will use to access the database.
Granting the user account appropriate privileges on the database.
Follow these instructions if you are using Oracle 10g or Oracle 11g with Real Application Clusters (Oracle 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.
This section covers the following topics:
Oracle RAC is the only database configuration for supported production environments that require high availability.
For information on using Oracle WebLogic Server (OWLS) with a multi data source configuration, see the discussion on 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
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.
Continue to "Define a Services Gatekeeper Database User for the Oracle Database".
To define a Services Gatekeeper for the Oracle database, do the following:
Create a database user for 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 Services Gatekeeper Server.
Grant the user the following privileges to the Services Gatekeeper database user:
CREATE SESSION
CREATE TABLE
Continue to "Installing Oracle Communications Services Gatekeeper".
Follow the instructions in this section if you are using Oracle XE as your database.
Oracle XE 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.
Note:
Oracle XE is recommended over MySQL for Services Gatekeeper development installations since it is schema-compatible with enterprise Oracle databases. Neither Oracle XE nor MySQL is recommended for production deployment.This section covers the following topics:
To install Oracle XE on Windows, do the following:
Log on to Windows with Administrative privileges.
You must be part of the Administrators group on Windows to install Oracle Database XE. If you are logged in as a domain user, ensure that you are connected to the network.
If the ORACLE_HOME environment variable has been set, then use System in the Control Panel to delete it.
Go to the following Web site:
http://www.oracle.com/technetwork/database/express-edition/downloads/index.html
Click Free Download and follow the instructions to select and download the Microsoft Windows version of Oracle Database XE.
After downloading the Oracle Database XE installation executable, setup.exe, double-click it.
In the Oracle Database 11g Express Edition - Install Wizard welcome window, click Next.
In the License Agreement window, select I accept the terms in the license agreement and then click Next.
In the Choose Destination Location window, either accept the default or click Browse to select a different installation directory. (Do not select a directory that has spaces in its name.) Then click Next.
If you are prompted for a port number, then specify one.
The following port numbers are the default values:
1521: Oracle database listener
8080: HTTP port for the Oracle Database XE graphical user interface
If these port numbers are not currently used, then the installation uses them automatically without prompting you. If they are in use, then you will be prompted to enter an available port number.
In the Specify Database Passwords window, enter and confirm the password to use for the SYS and SYSTEM database accounts. Then click Next.
In the Summary window, review the installation settings, and if you are satisfied, click Install. Otherwise, click Back and modify the settings as necessary.
In the InstallShield Wizard Complete window, click Finish.
Continue to "Configuring Oracle XE for Services Gatekeeper".
To install Oracle Database XE on Linux, do the following:
Log on to your computer with root permissions.
Go to the following Web site:
http://www.oracle.com/technetwork/database/express-edition/downloads/index.html
Click Free Download and follow the instructions to select and download the Linux version of Oracle Database XE.
Run the Oracle Database XE executable oracle-xe-11.2.0-1.0.x86_64.rpm to install Oracle Database XE.
# rpm -ivh downloads/oracle-xe-11.2.0-1.0.x86_64.rpm
The installation displays a status of its progress.
When prompted, run the following command:
# /etc/init.d/oracle-xe configure
Enter the following configuration information:
A valid HTTP port for the Oracle Application Express (the default is 8080)
A valid port for the Oracle database listener (the default is 1521)
A password for the SYS and SYSTEM administrative user accounts
Confirm password for SYS and SYSTEM administrative user accounts
Whether you want the database to start automatically when the computer starts (next reboot)
Restart the computer.
Continue to "Configuring Oracle XE for Services Gatekeeper".
To configure Oracle XE for Services Gatekeeper, do the following:
Open a terminal session (Linux) or a command window (Windows).
(Linux only) If the required environment variables are not already set, do the following:
For Bash, Bourne or Korn shells, enter the following command:
source ORACLE_HOME/bin/oracle_env.sh
For C shell, enter the following command:
source ORACLE_HOME/bin/oracle_env.csh
Enter the following command at the operating system prompt:
sqlplus /nolog
Connect to the database (on Windows you will be prompted for the username and password):
SQL> connect SYSTEM/<SYSTEM user password>@XE
Run the following command to increase the number of allowable JDBC connections:
SQL> alter system set processes=300 scope=spfile;
Create a Services Gatekeeper user using the following command:
SQL> create user <Services Gatekeeper database user name> identified by <Services Gatekeeper database user password>;
Grant the newly created user proper privileges using the following command:
SQL> grant create session, create table, resource to <Services Gatekeeper database user name>;
Exit SQL*Plus:
SQL> exit
Restart the computer for the changes to take effect.
Continue to "Installing Oracle Communications Services Gatekeeper"
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.
Note:
Oracle XE is recommended over MySQL for Services Gatekeeper development installations since it is schema-compatible with enterprise Oracle databases. Neither Oracle XE nor MySQL is recommended for production deployment.This section covers the following topics:
For most Linux distributions, MySQL can be installed by way of a package manager such as dpkg or YUM. Please check the instructions for your particular distribution.
Once MySQL is installed, you will need to configure it. The following is a summary of the commands required to configure MySQL on most versions of Linux. Command locations may differ between Linux distributions.
To configure MySQL on Linux:
As root, start the MySQL database:
/etc/rc.d/init.d/mysqld start
Edit the file, /etc/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, but you may need to increase it. For example:
[mysqld] max_connections=400
You should also add settings for default character set.
The recommended character set is Latin1.
default-character-set=latin1
Restart MySQL:
/etc/rc.d/init.d/mysqld stop /etc/rc.d/init.d/mysqld start
Continue to "Configuring MySQL for Services Gatekeeper".
You can download the latest MySQL Windows installer from: http://www.mysql.com/downloads/. Detailed instructions on using the installer are available at the MySQL web site. Unless you have additional special requirements, you can select Developer Default.
To configure MySQL on Windows:
Open my.ini in a plain text editor such as notepad.exe. Depending upon your version of Windows, it may be located on one of two places:
Windows XP:
C:\Documents and Settings\All Users\Application Data\my.ini
Windows 7 or Windows Vista:
C:\ProgramData\MySQL\MySQL Server 5.6\my.ini
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, but you may need to increase it. For example:
[mysqld] max_connections=400
You should also add settings for default character set.
The recommended character set is Latin1.
default-character-set=latin1
Select your default character set. The recommended character set is Latin1.
Continue to "Configuring MySQL for Services Gatekeeper".
To configure MySQL for Services Gatekeeper, do the following:
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 <Services Gatekeeper database user>@'<ip-address>' IDENTIFIED BY '<Services Gatekeeper database user 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>
Continue to "Installing Oracle Communications Services Gatekeeper".
|
 Copyright © 2007, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices |
|
