Thursday, September 9, 2010

Quickly installing Oracle Fusion Middleware 11g and Oracle SOA Suite 11g

If you'd like to quickly set up a single node Oracle Fusion Middleware 11g and Oracle SOA Suite11g environment for development purposes (on Linux 32-bit), look no further. Firstly, ensure that you have a correctly installed operation system by following this blog post.

The software installs the following on Oracle Enterprise Linux 5.5 32-bit:
  • Oracle Database 11g (11.2.0.1)
  • Oracle WebLogic Server 11g (10.3.3)
  • Oracle SOA Suite 11g (11.1.1.3)
  • Oracle JDeveloper 11g (11.1.1.3)
The installation takes approximately 1 hour.


Install Oracle Database Enterprise Edition 11gR2 (11.2.0.1.0)

1. Download the software from here:
http://download.oracle.com/otn/linux/oracle11g/R2/linux_11gR2_database_1of2.zip
http://download.oracle.com/otn/linux/oracle11g/R2/linux_11gR2_database_2of2.zip
2. Perform the following:
unzip linux_11gR2_database_1of2.zip
unzip linux_11gR2_database_2of2.zip
./database/runInstaller
Uncheck 'I wish to receive security updates via My Oracle Support'
Click 'Next'
Click 'Yes'
Click 'Next'
Click 'Next'
Enter 'Administrative password'
Enter 'Confirm password'
Click 'Next'
Click 'Next'
Click 'Finish'
(Installation runs)
Click 'OK'
Run the listed script as root (and press ENTER when prompted)
Click 'OK'
Click 'Close'

Install Oracle WebLogic Server 11g (10.3.3)

1. Download the software from here:
http://download-llnw.oracle.com/otn/linux/middleware/11g/wls1033_linux32.bin
2. Perform the following:
chmod 700 wls1033_linux32.bin
./wls1033_linux32.bin
Click 'Next'
Enter '/u01/app/oracle/Middleware'
Click 'Next'
Uncheck 'I wish to receive security updates via My Oracle Support'
Click 'Yes'
Click 'Next'
Check 'Custom'
Click 'Next'
Uncheck 'Oracle Coherence'
Click 'Next'
Click 'Next'
Click 'Next'
Click 'Next'
(Installation runs)
Click 'Done'

Create the SOA database schemas using the Repository Creation Utility (RCU) 11g (11.1.1.2.1)

1. Download the software from here:
http://download.oracle.com/otn/linux/middleware/11g/ofm_rcu_linux_11.1.1.2.1_disk1_1of1.zip
2. Perform the following:
unzip ofm_rcu_linux_11.1.1.2.1_disk1_1of1.zip
./rcuHome/bin/rcu
Click 'Next'
Click 'Next'
Host Name:    oradev.ipnweb.com
Port:        1521
Service Name:    orcl.ipnweb.com
Username:    sys
Password:    sys
Click 'Next'
Click 'OK'
Check 'SOA and BPM Infrastructure'
Click 'Next'
Click 'OK'
Password:                 welcome1
Confirm Password:    welcome1
Click 'Next'
Click 'Next'
Click 'OK'
Click 'OK'
Click 'Create'
Click 'Close'
Install Oracle SOA Suite 11g (11.1.1.2)

1. Download the software from here:
http://download.oracle.com/otn/nt/middleware/11g/ofm_soa_generic_11.1.1.2.0_disk1_1of1.zip
2. Perform the following:
unzip ofm_soa_generic_11.1.1.2.0_disk1_1of1.zip
./Disk1/runInstaller -jreLoc /u01/app/oracle/Middleware/jdk160_18
Click 'Next'
Click 'Next'
Click 'Next'
Click 'Install'
(Installation runs)
Click 'Next'
Click 'Finish'

Create the SOA domain

1.  Perform the following:
cd /u01/app/oracle/Middleware/Oracle_SOA1/common/bin
./config.sh
Click 'Next'
Check 'Oracle SOA Suite - 11.1.1.0 [Oracle_SOA1]'
Check 'Oracle Enterprise Manager - 11.1.1.0 [oracle_common]'
Check 'Oracle Business Activity Monitoring - 11.1.1.0 [Oracle_SOA1]'
Click 'Next'
Click 'Next'
User password:                welcome1
Confirm user password:    welcome1
Click 'Next'
Click 'Next'
Check 'BAM Schema', 'SOA Infrastructure', 'User Messaging Service', 'OWSM MDS Schema', 'SOA MDS Schema'
DBMS/Service:    orcl.ipnweb.com
Host Name:    oradev.ipnweb.com
Schema Password:    welcome1
Click 'Next'
Click 'Next'
Click 'Next'
Click 'Create'
(Installation runs)
Click 'Done'

Upgrading to Oracle SOA Suite 11g (11.1.1.3)

1. Download the software from here:
http://download.oracle.com/otn/nt/middleware/11g/ofm_soa_generic_11.1.1.3.0_disk1_1of1.zip
2. Perform the following:
unzip ofm_soa_generic_11.1.1.3.0_disk1_1of1.zip
./Disk1/runInstaller -jreLoc /u01/app/oracle/Middleware/jdk160_18
Click 'Next'
Click 'Next'
Click 'Install'
(Installation runs)
Click 'Next'
Click 'Finish'

Install Oracle JDeveloper 11g (11.1.1.3) and the SOA Composite Editor extension

1. Download the software from here:
http://download.oracle.com/otn/java/jdeveloper/11.1.1.3.0/jdevstudio11113install.exe
2. Perform the following:
Double-click 'jdevstudio11113install.exe'
Click 'Run'
Click 'Next'
Click 'Next'
Click 'Next'
Click 'Next'
Click 'Next'
Click 'Next'
(Installation runs)
Click 'Done'
Start JDeveloper 11.1.1.3 by double-clicking on "jdeveloper.exe"Uncheck 'Always prompt for role selection on startup'
Click 'OK'
Accept or close any popup windows
Click 'Help'
Click 'Check for Updates'
Click 'Next'
Click 'Next'
Check 'Oracle SOA Composite Editor 11.1.1.3.0.25.57' (or higher)
Click 'Next'
Enter your Oracle Web Account user name and password (free registration)
Click 'OK'
Click 'Finish'

Startup commands

Start the WebLogic Administration Server:
/u01/app/oracle/Middleware/user_projects/domains/base_domain/startWebLogic.sh
Wait for the following:
<Sep 3, 2010 5:36:25 PM EDT> <Notice> <WebLogicServer> <BEA-000360> <Server started in RUNNING mode>
Start the SOA Managed Server:
/u01/app/oracle/Middleware/user_projects/domains/base_domain/bin/startManagedWebLogic.sh soa_server1
When prompted, enter the username and password entered during installation (e.g., weblogic/welcome1),
Wait for the following:
<Sep 3, 2010 6:40:51 PM EDT> <Notice> <WebLogicServer> <BEA-000332> <Started WebLogic Managed Server "soa_server1" for domain "base_domain" running in Development Mode>
Start the BAM Managed Server:
/u01/app/oracle/Middleware/user_projects/domains/base_domain/bin/startManagedWebLogic.sh bam_server1
When prompted, enter the username and password entered during installation (e.g., weblogic/welcome1).
Wait for the following:
<Sep 3, 2010 9:39:43 PM EDT> <Notice> <WebLogicServer> <BEA-000360> <Server started in RUNNING mode>

Consoles

WebLogic Console:
http://localhost:7001/console
Enterprise Manager Console:
http://localhost:7001/em
SOA Composer:
http://localhost:8001/soa/composer
SOA Worklist:
http://localhost:8001/integration/worklistapp
B2B Console:
http://localhost:8001/b2b
BAM (must use IE):
http://localhost:9001/OracleBAM

Log files

/u01/app/middleware/home_11g/user_projects/domains/base_domain/servers/AdminServer/logs/AdminServer.log
/u01/app/middleware/home_11g/user_projects/domains/base_domain/servers/AdminServer/logs/base_domain.log
/u01/app/middleware/home_11g/user_projects/domains/base_domain/servers/soa_server1/logs/soa_server1.log
/u01/app/middleware/home_11g/user_projects/domains/base_domain/servers/bam_server1/logs/bam_server1.log

3 comments:

Michael Quinn said...

Really need some comments about the processes and cursor settings

Ahmed Aboulnaga said...

Michael,

I'll take it you're referring to database cursors and processes.

In a 2-node cluster on Linux 64-bit running Oracle SOA Suite 11.1.1.4 (64-bit JVM) and Oracle AIA Foundation Pack 11.1.1.4, here are some numbers from our database:

=====

SELECT name, value
FROM v$parameter
WHERE name = 'processes'

NAME VALUE
processes 1000

=====

SELECT AVG(a.value) avg_cur, MAX(a.value) max_cur, s.username, s.machine
FROM v$sesstat a, v$statname b, v$session s
WHERE a.statistic# = b.statistic#
AND s.sid=a.sid
AND b.name = 'opened cursors current'
AND username LIKE ('TEST%')
GROUP BY s.username, s.machine
ORDER BY 1 desc

AVG_CUR MAX_CUR USERNAME MACHINE
11.6 15 TEST_SOAINFRA server2
10.9 15 TEST_SOAINFRA server1
10.3 15 TEST_MDS server1
10 14 TEST_MDS server2
3.4 6 AIA_TEST_JMSUSER server2
3.4 6 AIA_TEST_JMSUSER server1
3 3 TEST_ORASDPM server2
3 3 TEST_ORASDPM server1
2.7 5 AIA_TEST_AIA server2
2.7 5 AIA_TEST_AIA server1
2 2 AIA_TEST_AIALIFECYCLE server1
2 2 AIA_TEST_AIALIFECYCLE server2
1 1 AIA_TEST_XREF server1
1 1 AIA_TEST_XREF server2

=====

Rafi said...

Hi,
I have done these setup...open_cursors for entire fusion middleware should be 1000.

alter system set open_cursors=1000;
only soa
open_cursors=300 should be ok..