1. Data base [10g/11g]

• Increase data base performance

2. Run 11g[MDS, Dehydration tables]
3. J-developers /web logic 11g

• Jre – 64 bit/JDk -32 bit

4. SOA generic 11g/OSB generic 11g
5. Domain creation
6. Mds update
7. start web logic and SOA servers
8. update j- developers
9. J- developers –(Source code numbers
10. create boot file(user name, password)
11. start managed server with the help of console
12. servers desktop shortcuts
13. Table creation
14. partition(-:7001/EM)
15. -: 7001/Em (instance completed)

DB Installation:

• password = welcome 1
• Re- enter password = welcome1
• Increase data base performance:
• All programs –Oracle Data base 10g expression edtion    

Run SQl command line 

SQL > Connect sys/welcome1 xe as sysdba;

SQL> alter system reset session scope =spfile  sid =’*’;

SQL> alter system set process = 500 scope =spfile;

SQL > Shutdown immediate;   

Exit

• All programs -> Oracle data base 10g express edition start data base exit

• All programs -> oracle data base 10g express edition  Run SQL command line  

SQL > Connect sys /welcome Xe as sys dba;

SQL> show parameter session;

SQL> show parameter process;

SQL> exit;

RCU – Installation:

• ofm –rcu –wn -> rcu Home BIN -rcu  double click next  

Createnext  service name(Xe[DRCL]),Host name(local host),port (1521),username (sys),password(welcome1)next ignore  ok  

create a new prefx (dev)    SOA and BPM infra structure   next ok  

next ok     pass word (welcome1),conform password(welcome1)next next ok ok  create  close

Desired to gain proficiency on Oracle SOA? Explore the blog post on 
Oracle SOA Training in Hyderabad to become a pro in Oracle SOA.

3) J – Developer:

• J develop studio 11115 installDouble click next

Create a new middleware home  next  next  next

“All users” start menu  next  next  100%  done

• Install JRE:

64 bit  JRE

32 bit  JDK

4) $oa Installation:

Ofm – soa – generic  Disk 1  [set up  yes]  paste URL        next  next (skip software updates)  next  next [web logic server  next]  install  100%  next  finish

C: programfiles/java/jre6  64 bit

C: Oracle/middleware_24/jdk 160  32 bit

5) Domain creation:

All programs  oracle (SOA 11g – Home 1)  configuration App server – click  create a new web logic domain  next

select (4)        Oracle SOA suite 11.1.1.0) Oracle_SOA1)

Automatically:       Oracle WSM         created

Oracle_JRE

(5)        Oracle Enterprise manager

(6)        Oracle Business Activity monitoring

next  next  name (web logic), password (welcome1), confirm password (welcome1)  next  available JDK‘s, next

BAM schema                                     (schema password / welcome 1),

SOA Infrastructure                          (DBMS\server / XE [ORCL]),

User message                                   (Host name / local host),

OWSM MDS                                       (port / 1521)

SOA MDS             next  next  next  create  100%  done

6) Mds Update:

URL – (1)

C: Oracle\middleware\Oracle_common\reu\integration\mds\sq1

URL – (2)

C: Oracle\app\Oracle\product\10.2.0\server\bin

All programs  cmd  C: \> cd paste URL – (1)         then it shows  C: \> Oracle\middleware\Oracle_common\rcu\integration\mds\sql>  Beside above URL, paste URL –(2) & type  sql\plus.exe  Dev_mds/welcome1@XE   then it shows  C: \> Oracle\middleware\Oracle_common\rcu\integration\mds\sql> C:\Oracle\app\Oracle\product\10.2.0\server\bin\sqlplus.exe Dev_mds/welcome1@XE                      SQL > @upgmds.sql        Exit

7) Start web logic & SQL server:

Run  cmd

C: Oracle/middleware/user_projects/domain/base_domains/start web logic.cmd

C: Oracle/middleware/user_projects/domain/base_domains/start managed web logic SOQ_server1

8) Update J – developer:

J developer  help  check for updates  next

Install from local file   [D: \SOA\SOA11g\SOQ-j dev-extension.zip (j developer zip file) Browse]  next  finish.

Note: Unable to connect to the internet to check for updates.  Cancel

9) Add source code number to J developer:

J developer  tools  preferences  click   [code editor  expand]  [line gutter  select]  show line numbers  ok

Learn more about Oracle SOA Interview Questions in this blog post.

10) Create boot file:

It’s automatically takes username and password

C: \ Oracle\middleware\user_project1\domains\base_domains\server\soa_server1

Create one folder security inside SOA_server 1

Create one text file inside security folder

Open text file & write username = web logic, password = welcome1

Save as  [file name/boot.properties], [save as type / all file]  save

Delete dummy text file (ok)

11) Start managed server with the help of console:

C: Oracle\middleware\ wlserver_10.3\server\bin\start nodemc naget

Double click   [port 5556]  it means running mode.

Console(7001/console)  expand environment  server – click   soa_server 1- click

Control  start  it will not start

Oracle\middleware\w1server\common\node manager.properties file  open

It file last shown  start script enable = false X   [change property]

Start script enable = true _/

12) Server desktop shortcuts: (.bat)

TITLE WEBLOGIC

C: / Oracle/middleware/user_projects/domains/base_domains/start web logic cmd

• Copy above path and write into the text file.
• Save as “web logic.bat”, all files.

13) Table creation:

• J – Developer tools  data base  SQL worksheet  [connection/DB_RAMESH]  ok
• Create table employees (empid numbers(20), empname varchar2(20), empsal number(20), emplocation varchar2(20));

Insert into employees values (101, ‘Ram’, 100000,’Hyd’);

Insert into employees values (102, ‘Sai’, 200000,’Hyd’);

Insert into employees values (103, ‘Teja’, 300000,’Hyd’);

Commit;

• Select * from employees;
• Select * from tab;

For an Indepth knowledge on Oracle SOA click on:

• Oracle service bus in SOA
• Oracle SOA Business rule engine
• Java messaging service in Oracle SOA 11g
• How to work with FTP(File transfer protocol) in Oracle SOA
• DB Adapter configuration-11g in Oracle SOA