• Find us:
    +1-669-900-5138   |   +44-203-372-5553
  • Free Newsletter

    Get Latest Updates

  • Make Training Enquiry


  • Categories

  • Archive

  • Oracle SOA Suite Installation Part I : Database Installation

    Posted by "" in "fusion, soa" on 2007-06-13

    In next few posts I’ll cover installation of SOA Suite (Service Oriented Architecture Suite) which is one of the components in Oracle Fusion Middleware. For more information on Oracle Fusion Middleware and its various components and overview visit

    Fusion Middleware Part I
    Fusion Middleware Part II

    –In order to install SOA suite version 10.1.3.X you need Database version 10.2.X or higher to hold schema for BPEL, ESB, WSM ….
    –This database can exist on same machine (but under different ORACLE_HOME) or can be on different machine where you are planning to install SOA.
    –For this installation demo, I installing Database release on same machine under ORACLE_HOME.
    –This demo installation is on Redhat Linux ES 3 which is on VMWare.

    Install Oracle Database

    Software for Oracle Database can be downloaded from this link

    Operating System Prereq.
    For linux following version are supported for database version at time of writing this doc

    I picked up Red hat ES -3 (Enterprise Server) as operating system.

    Packages and Kernel Parameters mentioned below are for database on Red Hat linux Version 3 (Check Installation Documentation if your operating system version differs)

    Following packages with atleast following version should be installed

    To check if package/rpm is installed
    rpm –qa grep {rpm_name} (From root)

    To install package/rpm
    rpm –ivh {rpm_name} (From root)

    Kernel Parameter
    Make sure you add following entry in /etc/sysctl.conf

    After adding these entries execute below command to take these parameters in to effectsysctl –p /etc/sysctl.conf

    Unzip software you downloaded above as

    unzip 10201_database_linux32.zip

    Starting Database Installation

    Start Oracle Universal Installer (OUI) by running./runInstaller (from location where you unzipped database) *Use operating system user like oracle or orainstall (don’t execute runInstaller from root user)

    With this screen you get option to do basic database installation where as I opted for Advanced Installation (With Advanced Installation Option you get flexibility on where to keep database and various other options). You can also choose Basic Installation and OUI will ask only basic question and for rest values it will take default (pre configured) values.
    Again you have three options for type of installation for your database (Choose one as per your requirement, if you are not sure which one to pick, leave default i.e. Enterprise Edition)

    This is important detail which is prompting for Database ORACLE_HOME Name and Destination Path.

    ORACLE_HOME is always unique per system which identifies oracle software installed (Oracle Software can be database, application server or various other oracle software)
    PATH is directory where your oracle database software will be installed (Please note Oracle Software is not same as Oracle Data files)

    In my case Oracle Database 10.2.X requires minimum 900 MB memory but just had 750 MB allocated to Virtual Machine on which I am installing this database so I got warning related to memory. If you get warning related to memory you can ignore it (Not for Production or UAT deployment)

    In above screen you have option to Create Database, Configure ASM (more coming on ASM with RAC soon …) or Install database software only.If you select database software only you can create database later as well (this option will only install oracle database software and will not create any database)

    Leave default General Purpose in above screen

    If you have selected “Create a Database” above on this screen you have option to define SID and Global Database name for database which we are going to create with install. (You can leave default “orcl” SID or change like “SOADEV” to uniquely identify this database that it is going to be used with SOA Suite)Leave default “Database Control Management” or choose option 1 if you have Grid Control Agents installed on machine on which you are trying to install this database.

    Here you can specify type of storage management for database (SOADEV) which you are going to install. This storage management as seen in image can be File System, ASM or Raw device.Specify Database file location if you choose File System as storage management. (Database file location can exist under ORACLE_HOME or any other location. * better keep this different from ORACLE_HOME for better management)

    Choose password for your various schema (For security reasons, don’t choose same password for all accounts on production instance)

    Click on “Install” button to start your installation (Installation may take 30 minutes to 3 hours depending on your machine)

    If you wish to unlock non system accounts click on “Password Management” or click “OK” for unlocking them later. (For SOA Suite Installation, you can leave them locked)

    execute command root.sh from root user as shown blow

    This will complete your database installation for SOA Suite Installation.

    If you wish to start/stop oracle database installed above

    export ORACLE_HOME = /home/oracle/product/10.2.0/db
    export ORACLE_SID = SOADEV
    export PATH = $PATH:$ORACLE_HOME/bin

    (Where ORACLE_HOME and ORACLE_SID we entered above while installing database)

    Stopping database services
    sqlplus “/as sysdba”
    SQL> shutdown immediate
    lsnrctl stop

    Starting database services
    lsnrctl start
    sqlplus “/as sysdba”
    SQL> start

    For SOA Suite installation stay tuned (coming soon…)

    You can also subscribe to email feeds on right menu of this page for updates on this Apps DBA blog.

    16 Responses to “Oracle SOA Suite Installation Part I : Database Installation”

    1. Khaleel says:

      Could you please guide me how to install
      SOA Suite, and Oracle Portal together on one mechine on single Application Server and Single Database.


    2. Atul says:

      SOA Suite is supported on 10.1.3 and higher where is portal is supported on AS so currently you can’t configure portal & soa suite in same application server .

      You can install both against same database (Use MRCA to load portal repository in existing database ) .

      Run soa repository script in same database and install two application server ( portal and 10.1.3.X SOA)

    3. jskishor says:

      Hi Atul,

      I am a silent watcher of this site for a long time.

      The SOA suite installation document is excellent, I could able to install SOA suite on my Linux machince sucessfully. The only issue was I had to upgrade my database 10g R1 standard edition to 10g R2, though it was not required as per the document as 10GR2 was required only for EE.

      Appreciate your efforts for putting such useful info.


    4. Vani says:

      can u please explain why its always needed ot run root.sh after running the OUI?

    5. Atul says:

      If you open root.sh you will come to know. root.sh makes an entry in oratab and set file permission on couple of executables

    6. […] Preparation 1. Install Oracle database on Linux , check here  or here 2. Create tablespace for content server data SQL> create tablespace content_system […]

    7. KMG says:

      Hi Atul,
      Can we used SOA dehydration DB to store custom schemas as well or its recommended to keep SOA schemas in seperate database?

      Please advice.


    8. aa100 says:

      Hi, Can I follow the same steps for Installing Oracle SOA Suite 11g on RHEL 5

    9. Nagesh Kumar says:

      Hi Atul,

      i have little bit knowledge on BPEL, Please help me how can prepair for good knowledge and do you have any sample project and books please share me.


    10. satish says:

      Hi Atul,
      How to install soa suite 10g on windows7
      and mac os(line)

      Thanks & Regards

    11. Atul Kumar says:

      @ Satish,
      Check if there is SOA 10g software for windows 7. I don’t think there is software for MAC

    12. rampaage says:

      Hi Atul,
      Excellent site !.
      I was able to install Oracle r12 on a OEL5.5 on the Oracle virtual box from the documents on your site.Great Job with the site !! Thanks Again. Everything works fine so far.
      Now i would like to install SOA suite. Here’s where i am confused.
      1) can i install the soa suite on the same linux box?
      2) if so can i share the same database instance( VIS)
      3) Since R12 already installs a application server cant SOA use the same. Why do we need to reinstall it?
      4) If not Can i install this on my windows machine and then connect to the R12 instance on my linux box? If so do i need to install anything on enable anything on the R12 end??

      Sorry I have too many questions. A bit confused at this point.


    13. Atul Kumar says:

      @ rampaage,
      Glad that you managed to install R12

      1) can i install the soa suite on the same linux box?
      A1: Yes

      2) if so can i share the same database instance( VIS)
      A2: Yes

      3) Since R12 already installs a application server cant SOA use the same. Why do we need to reinstall it?

      A3: No. application server with R12 is 10g AS where as SOA 11g requires weblogic. Moreover you can’t use R12 AS for custom applications or 10g SOA.

      4) If not Can i install this on my windows machine and then connect to the R12 instance on my linux box? If so do i need to install anything on enable anything on the R12 end?
      A4: Check update above. For SOA integration with EBS , it depends on how you wish to use SOA 11g with R12 . If you are planning to use ISG (Integrated SOA Gateway) then there are some configuration in ISG implementation guide.

    14. rampaage says:

      Thanks for the quick reply !! :-)
      Yes my intent is to use/learn the Integrated SOA gateway. I have Dev experience in the Oracle Apps world but not on SOA. Also not a DBA :-(

      So is it safe to say that if install the SOA 11g suite on my laptop( Win 7) and then follow the procedure in the ISG implementation guide to enable SOA on the R12 instance, then i am good to go? Or is there any other piece i am missing.
      I am assuming the Weblogic server you mentioned above come bundled with the SOA suite and i can install it on the windows box.

      Thanks Again,

    15. Atul Kumar says:

      Yes you can install it on windows box.

    16. Vijay says:


      Now we are using oracle EBS R12.1.3, My company want to useSOA they want to install the SOA suiteand integrate that with EBS.I went through some documents I under stood thatSOA requires the database to run and store the metadata.

      Doubts :

      Ø Can I use the same EBS Production database forthe configuring the SOA in production
      Ø IIf I use the same EBS database is there anyeffect on the existing data .
      Ø Can we createthe schema in the existing EBS database requiredfor SOA

      Note : My production database is running from past 2 years

      Can you please kindly suggest me accordingly

    Leave a Reply

  • K21 Technologies is among the most experienced Oracle Gold Partner for Identity Access Management service providers. We work with application development companies and in-house technology division to help achieve significant returns on their IT security investment. Our clientele includes some of the globally renowned corporate, which speaks of our expertise in our field.

    We have the most talented and experienced team that can swiftly deploy security solutions even in complex IT ecosystem. Our clients highly appreciate our timely implementation, interactive training, on-demand support and community resources.

    K21 Technologies
    8 Magnolia Place, Harrow,
    London, HA2 6DS

    UK: +44(0)7476444481
    USA: +1-888-414-1821

  • 2014, K21 Technologies. All rights reserved DMCA.com
  • TOP