Installing SOA 10g (10.1.3.4) – Fusion Middleware

Introduction:

This is my first post under Fusion Middleware technology. In this post we will see how to install SOA and carry out the basic validation (sanity check) for the installed components.

Pre-Installation Steps

You can download SOA software from OTN. This software version available for download is 10.1.3.1. Once we install SOA 10.1.3.1, we will upgrade the same to 10.1.3.4 using patchset. SOA 10.1.3.4 patch set can be downloaded from metalink. The patchset checkin number is 7272722.

Before starting the SOA installation we need to do some pre-installation task. Every SOA suite installation needs a database (Oracle). Also we need to create 3 schemas in that database before we proceed with runInstaller of SOA suite.

Please carry out a installation of Oracle database server software and create a simple database. Also you need to have database version 10g R2 (10.2.0.2) for SOA installation.

Once the database is created you need to run irca.sh shell script. This script will be present in the software dump downloaded from OTN.

After unzipping the software in a directory, you can navigate to the following location

base_dir/install/soa_schemas/irca

Here you will find irca.sh.Before running this script, make sure that you set ORACLE_HOME and ORACLE_SID of the database you have installed. If the database is not installed on the same host, then you need to login to the server where database is installed and then run this script.

Run this script as shown below. You need to provide hostname, port # and database SID of the database you have installed.

-bash-3.00$ sh irca.sh
Integration Repository Creation Assistant (IRCA) 10.1.3.1.0
(c) Copyright 2006 Oracle Corporation. All rights reserved.

Enter database “host port serviceName” [localhost 1521 orcl]: rws60066rems 1618  obieebam
Enter sys password:
Enter sys password: Running IRCA for all product(s):
connection=”rws60066rems 1618  obieebam”, , orabpelUser=ORABPEL, esbUser=ORAESB, orawsmUser=ORAWSM

Validating database …
Validating database character set …
WARNING: The target database character set is WE8ISO8859P1
For multi-byte support, the AL32UTF8 character set is recommended.

Running prerequisite checks for ORABPEL …
Enter password for ORABPEL:
Loading ORABPEL schema (this may take a few minutes) …

Running prerequisite checks for ORAESB …
Enter password for ORAESB:
Enter password for ORAESB: Loading ORAESB schema (this may take a few minutes) …

Running prerequisite checks for ORAWSM …
Enter password for ORAWSM:
Loading ORAWSM schema (this may take a few minutes) …

INFO: ORABPEL schema contains 225 valid objects.

INFO: ORAESB schema contains 180 valid objects.

INFO: ORAWSM schema contains 90 valid objects.

IRCA completed.
Please check for any ERROR message above and also check the log file
/tmp/irca2008-12-31_01-54-01AM.log for any error or other information.

Also while running the script you need to provide password for sys, orabpel, oraesb and orawsm. It will set the password for orabpel, oraesb and orawsm.

Once this is down, you can start with the installation task of installing SOA.

Installation Step

From the SOA software dump, start the runInstaller using following command.

-bash-3.00$ ./runInstaller -invPtrLoc $HOME/oraInst.loc

1

Screen 1) Advanced Installation (For more option and flexibility go for Advanced installation)

2

Screen 2) Provide the path for inventory location

3

Screen 3) select “J2EE Server, Web Server and SOA Suite” for complete installation.

4

Screen 4) Verifying the system requirements

5

Screen 5) Database connection Information – You need to provide the connection information for the database you have installed before starting the SOA installation

6

Screen 6) Database Schema Passwords – Provide the database schema passwords for ORABPEL, ORAESB and ORAWSM. These will be same as what provided while running irca.sh script in  pre-installation step.

7

Screen 7) You can provide the file staticports.ini for custom ports, or you can accept the default ports.

8

Screen 8) Administration Settings – Provide the name for AS Instance and OC4J instance. You also need to set the password for administrator.

9

Screen 9) Cluster Topology Configuration – This is requrired for advanced installation in case if we have to configure a standby or a load balancing site. For this installation we are ignoring this step.

10

Screen 10) This screen will show the installation summary. You can click on Install.

11

At the end of installation it will ask you to run root.sh as a root user. After you run root.sh, you can click on OK on that dialog box. Configuration assistants will start, which will install all the components.

SOA gets installed in $HOME/product/10.1.3.1/OracleAS_1 direcory

Following are the different URLs that will be available

Enterprise Service Bus : http://rws60076rems.us.oracle.com:7777/esb

Enterprise Manger : http://rws60076rems.us.oracle.com:7777/em

BPEL Console : http://rws60076rems.us.oracle.com:7777/BPELConsole

Worklist Application : http://rws60076rems.us.oracle.com:7777/integration/worklistapp/Login

OWSM Control : http://rws60076rems.us.oracle.com:7777/ccore

Where 7777 is your HTTP port.

This version for SOA is 10.1.3.1 Now we need to upgrade the same to 10.1.3.4. Following are the steps for the same.

Upgrading the SOA to 10.1.3.4

Download and unzip the patch 7272722. After unziping you will get Disk1 and Disk2.

Before running runInstaller you need to carryout some pre-installation task.

Pre-Installation Step

Step 1) From the base directory where the patch was unziped, navigate to following directory

cd /base_dir/Disk1/install/soa_schema_upgrade/bpel/scripts

and run script upgrade_10131_10134_oracle.sql by connecting to SOA database as orabpel user

Step 2) From the base directory where the patch was unziped, navigate to following directory

cd /base_dir/Disk1/install/soa_schema_upgrade/esb/sql/oracle

and run script upgrade_10133_10134_oracle.sql by connecting to SOA database as oraesb user

Installation Task

Go to Disk1 and start the runInstaller.

./runInstaller  -invPtrLoc $HOME/oraInst.loc

12

Screen 1) Make sure you select the correct ORACLE_HOME here. This should be your SOA 10.1.3.1 Oracle Home.

131

Screen 2) Provide the oc4jadmin password you selected during SOA 10.1.3.1 installation

14

Installer will shutdown the SOA services. Click on OK and wait for some time.

15

Screen 3) After shutting down all services, you will see the summary screen. Click on Install.

At the end of installation it will ask you to run root.sh as a root user. Once that is done, it will start with configuration assistants.

17

After the installation you can bring up all the services. This completed SOA 10.1.3.4 installation.

Hope this helps !!

Forms Runtime Diagnostics – Oracle Apps 11i

Many times we face issue with the form and we have to carry out the debugging at runtime as we give input to the form. This kind of situations can be handeled easily using FRD (Forms Runtime Diagnostics). This feature is available in 11i as well as in R12. In this post we will see how to enable the diagnostics and view the trace files in Oracle Apps 11i. You can also check one of my old post about generating forms trace files in Oracle E-Business Suite R12.

The following method applies to 11.5.10 and above.

Step 1) Check the value of “ICX:Forms launcher” profile option.

Current value set for this profile in my environment is : http://rws60090rems.us.oracle.com:8078/dev60cgi/f60cgi

Step 2) Append the ICX:Forms launcher profile value with the “Forms Runtime Diagnostics (FRD)” variables. Following are the different variables available in FRD

  • record=all
  • config=debug
  • log=<logfile path>

So the new “ICX: Forms Launcher” profile value will become : http://rws60090rems.us.oracle.com:8078/dev60cgi/f60cgi?record=all&log=/tmp/avdeo_frd.log

Step 3) Close the forms and then go to the home page and open the form you want to work upon. No need to bounce the forms services.

Once you open the form you will see the dialog as shown below

untitled

Also you will be able to see the trace file at the location given by variable “log=” In my case the trace file is present in /tmp directory.

The content of the trace file is as shown below

===================================================================

Forms Runtime Performance/Diagnostics Collection
File Name: /tmp/avdeo_frd.log
Process ID: 29403
Client IP: 10.176.87.235:50951
Forms 6.0 (Forms Runtime) Version 6.0.8.24.1 (Production)
PL/SQL Version 8.0.6.3.0 (Production)
Oracle Virtual Graphics System Version 6.0.5.38.0 (Production)
Oracle Multimedia Version 6.0.8.20.1 (Production)
Oracle Tools Integration Version 6.0.8.17.0 (Production)
Oracle Tools Common Area Version 6.0.5.32.0
Oracle CORE Version 4.0.6.0.0 – Production

TSE Startup Time : 1230616643390353000
TSE Handshake Duration  : 1230616643393408000
##### CTIME STARTS HERE
# C
WINDOW NONAME START START

Opened file: /slot/ems1978/appmgr/hz1mq100appl/fnd/11.5.0/forms/US/FNDSCSGN.fmx

ON-LOGON Trigger Fired:
Form: FNDSCSGN

State Delta:
FORM FNDSCSGN
STATUS     NEW
BLOCK PROGRESS_INDICATOR
STATUS     NEW
RECSTATUS  “”
FIELD TEXT
CANVAS     PROGRESS_INDICATOR
GEOMETRY   100,250:4000,400
ENABLED    TRUE
NAVIGABLE  TRUE
INSERTABLE TRUE
QUERYABLE  TRUE
UPDATEABLE TRUE
FIELD PERCENT_COMPLETE
CANVAS     PROGRESS_INDICATOR
.

.

===================================================================

If you don’t give the variable “log=” in “ICX:Forms Launcher” profile option then the trace file will be located in $FORMS60_TRACE_PATH location.

Hope this helps !!