3 Installing OracleAS Infrastructure and Oracle Database

Before you install the Oracle Content DB middle tier, you must first install OracleAS Infrastructure (which contains Oracle Identity Management) and Oracle Database. Alternatively, you can use an existing Oracle Database as your Oracle Content DB database, and/or use an existing Oracle Identity Management.

You can also use the OracleAS Infrastructure database as your Oracle Content DB database, or you can use an existing Oracle Database as your Metadata Repository. You can also install OracleAS Infrastructure, Oracle Database, and the Oracle Content DB middle tier on one computer, provided that computer meets the recommended hardware requirements.

See Also: "Installing Oracle Content DB on a Single Computer" for information about installing OracleAS Infrastructure, Oracle Database, and the Oracle Content DB middle tier on the same computer, as well as information about using the OracleAS Infrastructure database as your Oracle Content DB database Oracle Application Server Metadata Repository Creation Assistant User's Guide for information about using an existing Oracle Database as your Metadata Repository

This chapter provides important information and tips about how to install OracleAS Infrastructure and Oracle Database for Oracle Content DB. It also provides links to key places in the Oracle Application Server and Oracle Database documentation sets to help you proceed smoothly through the installation process.

Tip: When you refer to books in the Oracle Database and Oracle Application Server documentation libraries, make sure that the version and platform of the book you are looking at matches the version and platform of the Oracle Database or OracleAS Infrastructure you are installing.

This chapter contains the following topics:

• Installing OracleAS Infrastructure

• Installing Oracle Database

• Registering Oracle Database with Oracle Internet Directory

3.1 Installing OracleAS Infrastructure

Refer to Oracle Application Server Installation Guide for complete information about how to install OracleAS Infrastructure (which includes Oracle Identity Management). In particular, refer to Chapter 6, "Installing OracleAS Infrastructure" in Oracle Application Server Installation Guide for step-by-step instructions, as well as information about different OracleAS Infrastructure install types.

Review the information about installation types closely to determine which configuration best suits your needs. For example, you can install all OracleAS Infrastructure components, then use the OracleAS Infrastructure database as your Oracle Content DB repository. Or, you may decide to use an existing database as your Metadata Repository database, and install Oracle Identity Management components only.

Although Oracle recommends that you review the entire Oracle Application Server Installation Guide before installing, Table 3-1 highlights particularly important sections and chapters that you should read.

Note: The chapter and section numbers referred to in Table 3-1 may change, depending on the version of the Oracle Application Server documentation library you are using. If you cannot find the information you are looking for at the listed chapter or section number, search for the chapter or section by name rather than by number.

Table 3-1 Sections and Chapters to Read in Oracle Application Server Installation Guide

Section or Chapter Name
Section 4.2, "System Requirements"
Section 4.3, "Software Requirements"
Section 5.18, "Setting the Mount Point for the CD-ROM or DVD"
Section 5.19, "Starting Oracle Universal Installer"
Chapter 6, "Installing OracleAS Infrastructure"
Section 6.23, "Installing Oracle Identity Management Components Only (Including Oracle Internet Directory)"
Section 6.26, "Installing OCA and OracleAS Metadata Repository Only"

See Also: If you are installing OracleAS Infrastructure on a Solaris 10 system, please refer to Metalink note 330016.1. For more information on Metalink notes, refer to OracleMetaLink at: https://metalink.oracle.com

3.1.1 OracleAS Infrastructure Hardware and Software Requirements

Oracle Content DB requires an OracleAS Infrastructure version 10.1.2.0.2 or OracleAS Infrastructure version 10.1.4. For the most up-to-date certification information, refer to OracleMetaLink at:

https://metalink.oracle.com

Refer to Section 4.2, "System Requirements" and Section 4.3, "Software Requirements" in Oracle Application Server Installation Guide for information about hardware and software requirements for OracleAS Infrastructure.

3.1.2 Oracle Identity Management Component Requirements

Oracle Content DB requires the following Oracle Identity Management components:

• Oracle Internet Directory

• OracleAS Single Sign-On

• OracleAS Delegated Administration Services

• OracleAS Directory Integration and Provisioning

3.2 Installing Oracle Database

Refer to Oracle Database Installation Guide for HP-UX PA-RISC (64-Bit) or Oracle Database Quick Installation Guide for HP-UX PA-RISC (64-Bit) for your platform for complete information about how to install Oracle Database. Choose the Advanced installation type so that you can specify required initialization parameters and the required database character set during installation.

In addition, read the following sections for information about how to install Oracle Database (or adjust an existing Oracle Database) so that it can be used with Oracle Content DB.

This section contains the following topics:

• Oracle Database Hardware and Software Requirements

• Setting Required Initialization Parameters and the Database Character Set

• Data Types and Storage Requirements

• Upgrading an Existing Oracle Database

• Using the Raw Storage Type with Oracle Content DB

3.2.1 Oracle Database Hardware and Software Requirements

Oracle Content DB requires an Oracle Database version 10.2.0.2 or 10.1.0.5. Oracle Database version 9.2 is not supported. For the most up-to-date certification information, refer to OracleMetaLink at:

http://metalink.oracle.com

Refer to Chapter 2, "Preinstallation Tasks" in Oracle Database Installation Guide for HP-UX PA-RISC (64-Bit) for complete information about hardware, software, and other requirements. In particular, refer to the following sections:

• Section 2.2, "Checking the Hardware Requirements"

• Section 2.3, "Checking the Software Requirements"

• Section 2.6, "Configuring Kernel Parameters"

If you do not set Kernel parameters appropriately, you may see an error during installation.

For additional information about database computer sizing requirements for Oracle Content DB, see Chapter 2, "Planning for Oracle Content DB Deployment" in Oracle Content Database Administrator's Guide.

3.2.2 Setting Required Initialization Parameters and the Database Character Set

This section describes how to set required database initialization parameters, and how to set the required database character set (AL32UTF8).

This section contains the following topics:

• Setting Required Database Initialization Parameters

• Setting the Required Database Character Set

3.2.2.1 Setting Required Database Initialization Parameters

You must set initialization parameters for the Oracle Database you want to use with Oracle Content DB.

To set initialization parameters during installation, choose the Advanced installation type. Then, select Advanced on the Select Database Configuration screen. You can set the initialization parameters after the Database Configuration Assistant (DBCA) launches.

To set initialization parameters for an existing database, you can use Oracle Enterprise Manager Database Control to update the server parameter file. See Section 5.2, "Logging In to Oracle Enterprise Manager Database Control" in Oracle Database Installation Guide for HP-UX PA-RISC (64-Bit) for information about how to access the Database Control.

Alternatively, you can use the following SQL command to set individual parameters:

SQL> alter system set parameter_name=parameter_value scope=both;

For example:

SQL> alter system set shared_pool_size=184549376 scope=both;

Table 3-2 lists the required database initialization parameters for Oracle Content DB.

Table 3-2 Database Initialization Parameters for Oracle Content DB

Parameter Name	Minimum Value
aq_tm_processes	1
db_block_size	8192
db_cache_size	150994944
db_file_multiblock_read_count	32
db_recovery_file_dest_size	2147483648
dispatchers	(PROTOCOL=TCP)=(SERVICE={SID}XDB)
dml_locks	200
java_pool_size	125829120
job_queue_processes	10
large_pool_size	4194304
max_commit_propagation_delay	1 This parameter was deprecated in Oracle Database 10.2. If you are using a 10.2 database, you do not need to set this parameter.
open_cursors	400
pga_aggregate_target	203423744
processes	250
remote_login_passwordfile	EXCLUSIVE
session_max_open_files	50
sessions	400
sga_max_size	629145600
sga_target	629145600
shared_pool_size	184549376
star_transformation_enabled	TRUE
undo_management	AUTO
db_create_file_dest Note: Do not set this parameter if the storage is in raw volumes and the required table spaces are already created. See Data Types and Storage Requirements for information about tablespaces required by Oracle Content DB.	Set this parameter to identify the default location for the database server to create the following files: Datafiles Tempfiles Redo log files Control files Block change tracking files The following example sets /u01/oradata as the default directory to use when creating Oracle-managed files: DB_CREATE_FILE_DEST = '/u01/oradata/<sid>/'

3.2.2.2 Setting the Required Database Character Set

You must set the database character set to AL32UTF8 in order to use the database with Oracle Content DB.

To set the database character set during installation, choose the Advanced installation type (recommended). To set the database character set for an existing database, you can use the Database Configuration Assistant (DBCA) to re-create the database with the correct character set.

3.2.3 Data Types and Storage Requirements

Table 3-3 shows the different types of data stored in Oracle Content DB and describes the purpose of each tablespace. These tablespaces are created for you automatically during Oracle Content DB configuration.

For additional information, see "Oracle Content DB Tablespaces" in Oracle Content Database Administrator's Guide.

Table 3-3 Tablespace Definitions

Tablespace Type	Tablespace Name	Description
File Storage	CONTENT_IFS_LOB_I	Stores the Large Object (LOB) data for files that can be indexed by Oracle Text, such as text and word processing files.
File Storage	CONTENT_IFS_LOB_N	Stores the LOB data for files that are not indexed by Oracle Text, such as zip files.
File Storage	CONTENT_IFS_LOB_M	Stores the LOB data for files that can be indexed by Oracle interMedia, such as image, audio, and video files.
Oracle Text	CONTENT_IFS_CTX_I	Stores words (tokens) extracted by Oracle Text from Oracle Content DB files (the Oracle table DR$IFS_TEXT$I).
Oracle Text	CONTENT_IFS_CTX_X	Stores the Oracle B*tree index on the Oracle Text tokens (the Oracle index DR$IFS_TEXT$X).
Oracle Text	CONTENT_IFS_CTX_K	Stores miscellaneous Oracle Text tables (the Oracle tables DR$IFS_TEXT$K, DR$IFS_TEXT$N, DR$IFS_TEXT$R).
Metadata	CONTENT_IFS_MAIN	Stores metadata for files, information about users and groups, and other Oracle Content DB object data.
Oracle Workflow	WORKFLOW_IFS_MAIN	Stores data for Oracle Workflow.
General Oracle Storage	Various	SYSTEM, ROLLBACK, TEMP, and other tablespaces that store the Oracle data dictionary, temporary data during transactions, and so on.

3.2.4 Upgrading an Existing Oracle Database

You may need to upgrade your Oracle Database to one of the versions certified with Oracle Content DB. If you upgrade, make sure to read the upgrade documentation carefully, follow all instructions, and perform all required post-upgrade tasks. Otherwise, you may encounter problems. Post-upgrade tasks may include running the following scripts:

• catupgrd.sql (10.2.0.2)

• utlrp.sql (10.2.0.2)

• changePerm.sh (10.2.0.2)

• catpatch.sql (10.1.0.5)

• utlrp.sql (10.1.0.5)

Refer to the database upgrade documentation for additional details.

3.2.4.1 Downloading and Applying Database Patches

You can download database patches from OracleMetaLink at:

http://metalink.oracle.com

If you have a support contract with Oracle, the steps to download a patch from the OracleMetaLink site are:

1. Log in to OracleMetaLink.

2. Click Patches & Updates.

3. Ensure that Patch Number is selected in the Simple Search list, then enter the required patch number in the adjacent field.

   If you do not know the patch number that you need to download, select Product or Family in the Simple Search list.

4. Select the appropriate operating system from the Platform or Language list.

5. Click Go.

6. Under Results, click View Readme to go through the information in the readme before downloading the patch. Then, return to the Results page and click Download to download the patch.

Make sure to stop all database processes before applying database patches. After the upgrade completes, you need to run root.sh. Refer to the patch upgrade documentation for additional details; follow all instructions, and perform all required post-upgrade tasks.

3.2.5 Using the Raw Storage Type with Oracle Content DB

If you choose to use raw devices for database file storage, you must create tablespaces manually. Table 3-4 shows the minimum size of each tablespace.

Table 3-4 Minimum Tablespace Sizes

Tablespace Name	Minimum Size
CONTENT_IFS_MAIN	60MB
CONTENT_IFS_LOB_N	270MB
CONTENT_IFS_LOB_I	270MB
CONTENT_IFS_LOB_M	10MB
CONTENT_IFS_CTX_I	10MB
CONTENT_IFS_CTX_K	15MB
CONTENT_IFS_CTX_X	130MB
WORKFLOW_IFS_MAIN	10MB

To create tablespaces manually, you can issue the create tablespace SQL command. Example 3-1 shows a command to create the CONTENT_IFS_MAIN tablespace, with a size of 270 MB.

Example 3-1 Create Tablespace Command

SQL > create tablespace CONTENT_IFS_MAIN logging datafile size 270M autoextend on next 27M maxsize unlimited extent management local segment space management auto;

3.3 Registering Oracle Database with Oracle Internet Directory

After you install OracleAS Infrastructure and Oracle Database, you must register the database with Oracle Internet Directory before you can install the Oracle Content DB middle tier. Typically, registering the database with Oracle Internet Directory involves the following two steps:

• Running the Net Configuration Assistant (NetCA)

• Running the Database Configuration Assistant (DBCA)

If you are using the OracleAS Infrastructure database as your Oracle Content DB database, you do not need to perform these tasks.

3.3.1 Running the Net Configuration Assistant (NetCA)

Run the Net Configuration Assistant (NetCA) from the database Oracle home to create a Directory Usage Configuration for the database. Performing this step creates an ldap.ora file that points to the Oracle Internet Directory you want to use with Oracle Content DB. If you already have an ldap.ora file with the correct Oracle Internet Directory information, you do not need to perform this step.

Tip: For additional information on the parameters described in the following procedure, click Help on any NetCA page.

To create a Directory Usage Configuration for the database:

1. On the database computer, run netca from $ORACLE_HOME/bin.

2. On the Welcome page, choose Directory Usage Configuration and click Next.

3. For Directory Type, choose Oracle Internet Directory and click Next.

4. Provide the fully-qualified Hostname, Port, and SSL Port for your Oracle Internet Directory instance and click Next. You can verify the port numbers using the Application Server Control for the OracleAS Infrastructure Oracle home.

5. Select the appropriate Oracle Context and click Next.

6. Click Next on the summary page.

7. Click Finish on the Welcome page to exit.

3.3.2 Running the Database Configuration Assistant (DBCA)

Run the Database Configuration Assistant (DBCA) from the database Oracle home to register the database with Oracle Internet Directory.

Tip: For additional information on the parameters described in the following procedure, click Help on any DBCA page.

To register the database with Oracle Internet Directory:

1. On the database computer, run dbca from $ORACLE_HOME/bin.

2. Select Configure Database Options and click Next.

3. Select the name of your database and click Next.

4. On the Directory Service tab, select Yes, register the database. You must also provide the following values:

   • User DN and Password: Enter the credentials of the Oracle Internet Directory super user (for example, cn=orcladmin).

   • Wallet Password and Confirm Password: Enter and confirm a password for the database wallet. The database requires the wallet even if SSL is not used to secure the connection between the database and Oracle Internet Directory. The wallet will be created if required.

5. Click Next, then click Next again on the Database Components page.

6. Click Finish.