Oracle 10g R2 - BPEL

1 Overview

1.1 Purpose of Document

This document is intended for use by IT personnel to record the run-time server and baseline stack procedure. This document is intended for use by Seygen, Inc. to create a particular setup for use in its business practices.

1.2 Installation Directions

This document contains installation information for Oracle Patch, and Oracle BPEL. These components should be installed after base Oracle 10g installation.

1.3 Prerequisites

This installation assumes that the following documents and resources are available:

1.3.1 Required Installed Software

The following indicates the relationship between software that should be installed. Where software is needed prior to the installation of a certain component, it will be shown in brackets.

• CentOS 5.3
• Oracle 10gR2 Patch [requires installation of 10gR2]
• Oracle BPEL [requires installation of Oracle 10gR2 and Oracle Patch]

1.3.2 DVD

The following media contains software needed to complete the installations mentioned in this manual:

• Oracle Patch 10.2.0 à10.2.4 CD

• Oracle BPEL CD
• System Supplemental CD

1.3.3 Documentation

This document is needed to complete the installation.

• Installing Oracle 10gR2
• Includes:
• Oracle 10gR2 Installation
• Oracle 10gR2 Patch
• Oracle BPEL Installation

1.3.4 Permissions

Permissions required are oracle and root.

2 Apply Patch to Update Oracle 10.2.0.1 to 10.2.0.4

The DVD needed to perform this patch is Oracle Patch 10.2.0 à 10.2.4.

The patch should be installed as oracle user, but may require root user permissions as well.

2.1 Prepare System for Installer

The patch should be applied by oracle user, unless otherwise specified.

2.1.1 Copy Software from DVD to Local Drive

This step copies the software from the local drive and is a continuation of the previous steps.

1. Open a terminal
2. Create a directory in $ORACLE_BASE called 10.2.0.4_OPatch using the following command:

mkdir $ORACLE_BASE/10.2.0.4_OPatch

3. Copy the files from the DVD to $ORACLE_BASE/10.2.0.4_OPatch

2.1.2 Stop Oracle Database Instance

All database instances and database services should be stopped to ensure the patch installs correctly.

1. Connect as the sysdba role from oracle user

sqlplus ‘/ as sysdba’;

2. Shut down any Oracle database instances using the following command:

shutdown immediate;

This may take a few minutes. When complete, a series of message will be shown, the last of which will be “ORACLE instance shut down.”

3. Log out of the sysdba role using the exit command:

exit

A confirmation will be shown saying you were disconnected from the Oracle Database.

2.1.3 Run Installation Wizard

These steps should be performed as the oracle user. Attempting to run the commands as the systdba role will result in message indicating that the commands are invalid.

1. Stop all Oracle related services

lsnrctl stop;

emctl stop;

The listener should respond with a command completed successfully message. The emctl may show a configuration issue if emctl is not installed; otherwise, a success message is shown.

2. Navigate to the directory where the patch installer is located:

cd $ORACLE_BASE/10.2.0.4_OPatch/p6810189_10204_Linux-x86/Disk1

3. Run the patch installer

./runInstaller

A graphical installation wizard will be shown.

2.2 Install Patch

The following are completed using the patch installation wizard. See figures for more details.

Click Next when the Oracle Universal Installer Welcome screen.

Figure 11 - Oracle Universal Installer Welcome

1. Check the Home Details and ensure they are set to the following:

· Name: OraDb10g_home1

· /u01/app/oracle/product/10.2.0/db_1

Figure 12 - Specify Home Details

1. Click the Next button to perform prerequisite checks.

Figure 13 - Prerequisite Check Screen

When complete, there should be a message indicating there are “0 requirements to be verified” and “Check complete. The overall result is passed.”

1. Click the Next button to continue. The Oracle Configuration Manager Registration Screen is shown.

Figure 14 - Oracle Configuration Manager Registration

The configuration registration is not necessary for the installation of the Oracle patch.

1. Ensure the Enable Oracle Configuration Manager check box is not selected
2. Click the Next button to execute configuration scripts.

1.1 Execute Configuration Scripts

The next screen requires the “root” user to be logged in to execute scripts. Follow the on-screen instructions to execute the scripts.

Figure 15 - Execute Configuration Scripts for Patch

When complete, return to the Execute Configuration Screen and click the OK button.

An End of Installation Screen is shown indicating that Oracle was successfully installed.

1.1 Run the Update Scripts

This assumes a terminal instance is already open with the user should be logged in as oracle with sysdba role.

$ORACLE_HOME/bin/lsnrctl start

1. At the SQL terminal prompt, use the following command to start the database instance in Upgrade Mode:

startup upgrade;

2. Run the utlu102i.sql script at the SQL command prompt in the terminal to checks requirements of the system and table spaces.

@$ORACLE_HOME/rdbms/admin/utlu102i.sql

3. Shut down any Oracle database instances using the following command:

shutdown immediate;

4. At the SQL command prompt, use the following command to re-start the database instance in Upgrade Mode:

startup upgrade;

5. Run the catupgrd.sql script at the SQL command prompt in the terminal to update the binary files to the new patch:

@$ORACLE_HOME/rdbms/admin/catupgrd.sql

A confirmation message, “PL/SQL procedure successfully completed” is shown upon completion.

6. Shut down any Oracle database instances using the following command:

shutdown immediate;

7. At the SQL command prompt, use the following command to re-start the database instance in Upgrade Mode:

startup;

8. Run the following two queries at the SQL terminal prompt to check the version:

1. To select from the registry:

Select version, status from sys.dba_registry;

Status should be valid and version should be 10.2.0.4.0

VERSION STATUS

------------------------------ -----------

10.2.0.4.0 VALID

2. To select from the instance, use the following command:

Select version, status from v$instance;

Status should be OPEN and version should be 10.2.0.4.0

VERSION STATUS

----------------- ------------

10.2.0.4.0 OPEN

9. Run the following command to finalize the Oracle upgrade:

@$ORACLE_HOME/rdbms/admin/utlrp.sql

A confirmation message, “PL/SQL procedure successfully completed” is shown upon completion.

2 Oracle BPEL Pre-Installation and Setup

2.1 Pre-Installation Steps

2.1.1 Copy Files from CD to Server

The following are needed to copy the files from the BEPL CD and begin the installation for BEPL. These actions should be performed by oracle user.

1. Insert the Oracle BPEL CD into the media (CD) drive
2. Open a terminal
3. Use the following command to copy the contents of the CD to the /apps/opt/home/oracle directory:

cp –R “/media/bpel_101310/*.*” /apps/opt/home/oracle

2.1.2 Edit the Redhat Release Version

The installer for Oracle BPEL does not recognize the version of the operating system that is currently running; however, the current version is supported and can run the installer with a slight modification.

1. Open a terminal as root user
2. Use the following command to create a copy of the redhat-release file to the /home/oracle directory:

cd /etc/

cp redhat-release /home/oracle

3. Use the following command to open the redhat-release file from its original location:

vi /etc/redhat-release

4. Press the letter “I” to edit the file
5. Replace the first line in the file with the following text:

Red Hat Enterprise Linux AS release 4 (Nahant Update 4)

6. Press the [ESC] key to exit the editing mode
7. Type “:wq” to save the changes and exit the editor

3 Install BPEL on Existing Oracle Installation

This installation assumes that Oracle Database 10g R2 is installed on the destination machine.

3.1 Open Installer

1. Open a terminal as oracle user
2. Navigate to the location of the installer file using the following commands:

cd /apps/opt/home/oracle/bpel_101310/bpel_oc4j/

3. Run the .runInstaller file using the following command:

./runInstaller

When the installer is opening, it may indicate that the auto check for display colors could not be executed. This is an optional pre-requisite check and does not impact the installation.

4. Type “y” and press the [Enter] key when asked to continue despite display color check not being executed

The Welcome Screen should be shown for the installation.

3.2 Configure Installation

1. Click Next on the Oracle Universal Installer Welcome screen to specify the locations of source and destination files.

Figure 1 - Oracle Universal Installer Welcome

1. Modify, if necessary, the values shown for the source and destination file locations to the following:
• Source Path: /home/oracle/bpel_101310/bpel_oc4j/stage/products.xml
• Destination Name: OraBPEL1
• Destination Path: /u01/app/oracle/product/10.1.3.1/OraBPEL_1

2. Click Next to select the installation type.

Figure 2 – Select Installation Type

1. Select the BPEL Process Manager for Developers radio button

5. Click the Next button. A screen for configuring the proxy server is shown.

Figure 3 – Specify Outgoing HTTP Proxy Information

Our servers are not located behind a firewall, so the proxy settings are not needed.

1. Click Next button to continue. The Summary screen is shown.

Figure 4 – Pre-Install Summary

The Summary screen displays the settings, products to be installed, and other information about the BPEL install that is to be performed. Verify the data is correct.

1. Verify the Summary data shown is correct
2. Click Install to begin installation.

Figure 5 – Install Progress Screen

1.1 Install BPEL

A progress screen is shown indicating the percentage complete and checking steps as it progresses.

1.1.1 Monitor Install Progress

Figure 6 – Install Progress Screen

1.1.1 Setup Privileges

During installation, a Setup Privileges screen may be shown. This requires a configuration script to be run as root user.

Figure 7 – Setup Privileges Screen

1. Open a terminal
2. Log in as root user in the terminal
3. Run the following command:

.

/u01/app/oracle/product/10.2.3.1/OraBPEL_1/root.sh

4. Close the terminal and return to the Setup Privileges screen after running the script
5. Click OK on the Setup Privileges screen to resume BPEL installation.

1.1.1 Configuration Assistant

A Configuration Assistant will be displayed when the process indicator reaches one hundred percent (100%). Allow the system to run the configurations. No action is needed to continue.

Figure 8 - Configuration Assistant

1.1.1 End Installation

When the configurations are complete, an End of Installation screen is shown, indicating that the installation of Oracle BPEL Process Manager was successful. Click Exit to exit the installer.