Oracle 11g installation step by step process

  • Share this blog:

Installation steps:

  1. Data base [10g/11g]
  • Increase data base performance
  1. Run 11g[MDS, Dehydration tables]
  2. J-developers /web logic 11g
  • Jre – 64 bit/JDk -32 bit
  1. SOA generic 11g/OSB generic 11g
  2. Domain creation
  3. Mds update
  4. start web logic and SOA servers
  5. update j- developers
  6. J- developers –(Source code numbers
  7. create boot file(user name, password)
  8. start managed server with the help of console
  9. servers desktop shortcuts
  10. Table creation
  11. partition(-:7001/EM)
  12. -: 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    2

Run SQl command line 2 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;   2 Exit

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

  SQL > Connect sys /welcome Xe as sys dba; SQL> show parameter session; SQL> show parameter process; SQL> exit; RCU – Installation:

  • ofm –rcu –wn -> rcu Home2 BIN -2rcu 2 double click2 next  2

Create2next 2 service name(Xe[DRCL]),Host name(local host),port (1521),username (sys),password(welcome1)2next2 ignore 2 ok  2 create a new prefx (dev)   2 SOA and BPM infra structure  2 next 2ok  2 next2 ok    2 pass word (welcome1),conform password(welcome1)2next 2next 2ok 2ok 2 create 2 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 install2Double 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 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 (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/], [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 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.

  18     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:


You liked the article?

Like : 0

Vote for difficulty

Current difficulty (Avg): Medium

Recommended Courses


About Author
Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.

Stay Updated

Get stories of change makers and innovators from the startup ecosystem in your inbox