Oracle® Communications Marketing and Advertising Installation Guide Release 5.1 Part Number E20239-01 |
|
|
View PDF |
This chapter describes the system configuration tasks to complete prior to installing Oracle Communications Marketing and Advertising. These tasks involve installing the database software that supports Marketing and Advertising and setting up the database users.
Prior to installing and configuring the software, you must install and configure either an Oracle RAC, Oracle Single Instance, or MySQL database for use by Marketing and Advertising. The installation and configuration of the database in preparation for Marketing and Advertising should be performed by a qualified database administrator.
Although there are substantial differences among the specific installation procedures for each type of database, all installation types include the following basic steps:
Install the database software.
Set up two database user accounts, one for Marketing and Advertising and one for the delivery system (Oracle Communications Service Gatekeeper) to access the database.
Grant both user accounts appropriate privileges on the database.
When you install and configure a database, you define system configuration values that you need to enter when you install and configure the Marketing and Advertising software. When you create the following values, write them down so you can use them during the Marketing and Advertising installation and domain configuration processes:
Vendor—The database vendor's name. For Marketing and Advertising this is either Oracle or MySQL.
JDBC driver—The JDBC driver to use to connect to the database.
Database usernames—The usernames that Marketing and Advertising and Services Gatekeeper use when connecting to the database. There will be two.
Database user password—The passwords for the specified usernames.
Database SID or database name—If you are using an Oracle database, this is the Database System Identifier. If you are using a MySQL database, this is the name of the database.
Host Name—The name or IP address assigned to the server hosting the database.
Port—The port number to use to connect to the database. The default port numbers are: port 1521 for the Oracle database, and port 3306 for the MySQL database
Use these instructions if you are using Oracle 11g with RAC as your database. For more information on using WLS RAC with multidatasource configuration, see Oracle WebLogic Server Configuring and Managing WebLogic JDBC at
http://download.oracle.com/docs/cd/E12840_01/wls/docs103/jdbc_admin/
A RAC database is recommended to support production environments requiring high availability.
Oracle 11g RAC instances must be installed on dedicated servers separate from the cluster on which Marketing and Advertising will be installed.
To set up the base configuration:
Install the Oracle 11g RAC database software using the instructions provided with the software.
Download and install the latest patch set to guarantee the most recent updates to the database software are present.
Create the database using the Transaction Processing template.
Use Automatic Storage Management.
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 + ocma.datasource MaximumCapacity
) X the number of Marketing and Advertising servers in the cluster]. MaximumCapacity
is defined as a parameter in the connection pool settings for the JDBC datasources. Normally this value is 150 per datasource.
To create the database users:
Create two database users, one for Marketing and Advertising and one for the delivery system (a modified version of Service Gatekeeper).
Give each database user an allowed (unlimited) quota on the default tablespace, (the users tablespace).
The user name and password for each user are later copied to each instance of Marketing and Advertising.
Grant the database users the following privileges:
CREATE SESSION
CREATE TABLE
CREATE SEQUENCE
After installation, Marketing and Advertising must be configured with an additional set of parameters to make it work correctly with the database. This configuration is performed during the domain configuration phase, described in Chapter 5, "Configuring the Domain for Oracle Communications Marketing and Advertising."
Follow the instructions in this section if you are using an Oracle 11g single instance as your database.
The Oracle 11g instance must be installed on a dedicated server separate from the cluster on which Marketing and Advertising will be installed.
To set up the base configuration:
Install the Oracle 11g database software using the instructions provided with the software.
Download and install the latest patch set to guarantee the most recent updates to the database software are present.
Create the database using the Transaction Processing template.
Use Automatic Storage Management.
Use Dedicated Server Mode for the database.
Change the processes parameter:
Define the number or of processes to be equal to [(wlng.datasource MaximumCapacity + wlng.localTX.datasource MaximumCapacity + ocma.datasource MaximumCapacity
) X the number of Marketing and Advertising 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.
To create the database users
Create two database users, one for Marketing and Advertising and one for the delivery system (a modified version of Service Gatekeeper). Each should have an allowed (unlimited) quota on the default tablespace (the users tablespace).The user name and password for each user are later copied to each instance of Marketing and Advertising and Service Gatekeeper.
Grant the users granted the following privileges:
CREATE SESSION
CREATE TABLE
CREATE SEQUENCE
After installation, Marketing and Advertising must be configured with an additional set of parameters to make it work correctly with the database. This configuration is performed during the domain configuration phase, described in Chapter 5, "Configuring the Domain for Oracle Communications Marketing and Advertising."
Follow the instructions in this section if you are using MySQL as your database.
MySQL is not supported in environments that require high availability.
MySQL can be installed either on a server included in an Marketing and Advertising cluster or on a dedicated server. If the MySQL database is installed in the cluster, it should be placed on the same server as the core tier of Marketing and Advertising.
Before you start, make sure you have the appropriate installation binaries (5.0) for your platform. The binaries can be downloaded from
Copy the installation file to the installation directory and follow the instructions below for installing on 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.
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:
Install the MySQL database according to the MySQL documentation
Create a new database instance for Marketing and Advertising according to the MySQL documentation
Start the newly created database instance
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 +ocma.datasource MaximumCapacity
) X the number of Marketing and Advertising servers in the cluster].
MaximumCapacity
is defined as a parameter in the connection pool settings for the JDBC datasources. Normally this value is 150 per datasource. For example:
[mysqld] set-variable=max_connections=400
You should also add settings for default character set and storage engine. he recommended character set is latin1
:
set-variable=default-character-set=desired character set
set-variable=default-storage-engine=MYISAM
Restart MySQL.
Go on to Preparing the Database.
The Windows version is available with a graphical 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 for basic configuration. (Use the default choice unless specified below):
Select Detailed Configuration.
Select Multi-functional Database as your usage type.
To set concurrent connections, select Manual and choose a value equal to
[(wlng.datasource MaximumCapacity + wlng.localTX.datasource MaximumCapacity + ocma.datasource MaximumCapacity
) X the number of Marketing and Advertising servers in the cluster].
MaximumCapacity
is defined as a parameter in the connection pool settings for the JDBC datasources. Normally this value is 150 per datasource. Use the dropdown 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).
Set the 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.
When the installation and configuration are complete, make one manual edit in the my.ini
configuration file. In a standard installation this is located in C:\Program Files\MySQL\MySQL Server 5.1\. You must change one line in the file. Set this variable "default-storage-engine=MYISAM"
Go on to Preparing the Database.
After you have set up the MySQL installation, prepare the database for use with Marketing and Advertising.
Set MySQL to autostart on reboot. This 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 two databases, one for Marketing and Advertising, and one for the delivery system, a modified version of Services Gatekeeper.
The two names 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
Create a database user and password for each of the databases and give them access privileges.
You must do this for every IP address in the cluster.
You will need these user names and passwords 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.
You can use the following SQL command:
GRANT ALL ON *.* TO database user@'ip-address' IDENTIFIED BY 'password'
Marketing and Advertising must be configured with an additional set of parameters to make it work correctly with the databases. This configuration is performed after installation, during the domain configuration phase, which is described in Chapter 5, "Configuring the Domain for Oracle Communications Marketing and Advertising."
When you install Marketing and Advertising, you are prompted to specify a Middleware home directory. This directory serves as a repository for common files that are used by multiple Oracle Fusion Middleware products on the same machine. For this reason, the Middleware home directory can be considered a central support directory for all the Oracle Fusion Middleware products installed on your system.
The files in the Middleware_Home directory are essential to ensuring that Marketing and Advertising, Services Gatekeeper, and WebLogic Server, which Marketing and Advertising is built upon, operate correctly on your system. The central location of Oracle Fusion Middleware files ensures that cross-product dependencies during installation are fulfilled.
Marketing and Advertising software is available through web distribution. Use the following link to obtain the installation program:
The following installers are available on Oracle E-Delivery:
Generic: Use the generic installer to install the Marketing and Advertising software on any supported system using an approved java run-time.
Linux x86: Use the Linux installer to install the Marketing and Advertising software on Linux operating systems. This installer includes a Java Runtime Environment for Linux, as well as the Sun and Oracle JRockit JDKs.
Solaris Sparc: Use the Solaris Sparc installer to install the Marketing and Advertising software on Solaris systems with Sparc architecture. This installer includes a Java Runtime Environment for Solaris, as well as the Sun JDK.
Windows x86: Use the Windows installer to install Marketing and Advertising software on Microsoft Windows operating systems.