- Data base [10g/11g]
- Increase data base performance
- Run 11g[MDS, Dehydration tables]
- J-developers /web logic 11g
- Jre – 64 bit/JDk -32 bit
- SOA generic 11g/OSB generic 11g
- Domain creation
- Mds update
- start web logic and SOA servers
- update j- developers
- J- developers –(Source code numbers
- create boot file(user name, password)
- start managed server with the help of console
- servers desktop shortcuts
- Table creation
- partition(-:7001/EM)
- -: 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 onOracle SOA Training in Hyderabad to become a pro in Oracle SOA.
3) J – Developer:
- J develop studio 11115 install
Double 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