{"id":155,"date":"2007-06-13T14:56:00","date_gmt":"2007-06-13T18:56:00","guid":{"rendered":"http:\/\/onlineappsdba.com\/?p=155"},"modified":"2007-12-30T03:26:07","modified_gmt":"2007-12-30T07:26:07","slug":"oracle-soa-suite-installation-part-i-database-installation","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/13\/oracle-soa-suite-installation-part-i-database-installation\/","title":{"rendered":"Oracle SOA Suite Installation Part I : Database Installation"},"content":{"rendered":"

In next few posts I\u2019ll 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<\/p>\n

Fusion Middleware Part I<\/a>
\nFusion Middleware Part II<\/a><\/p>\n

–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 ….
\n–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.
\n–For this installation demo, I installing Database release 10.2.0.1 on same machine under ORACLE_HOME.
\n–This demo installation is on Redhat Linux ES 3 which is on VMWare.<\/p>\n

Install Oracle Database 10.2.0.1<\/strong>
\n——————————————-<\/strong><\/p>\n

Software for Oracle Database can be downloaded from this link<\/a><\/p>\n

Operating System Prereq.
\n<\/em><\/strong>For linux following version are supported for database version 10.2.0.1 at time of writing this doc
\n-Redhat-3
\n-Redhat-4
\n-SuSe-9
\n-Aslinux-1
\n-Aslinux-2<\/p>\n

I picked up Red hat ES -3 (Enterprise Server) as operating system.<\/p>\n

Packages and Kernel Parameters mentioned below are for database 10.2.0.1 on Red Hat linux Version 3 (Check Installation Documentation if your operating system version differs)
\n<\/span>
\nPackages
\n<\/em><\/strong>Following packages with atleast following version should be installed
\nbinutils-2.14
\ngcc-3.2
\nlibaio-0.3.96
\nglic-2.3.2-95.47<\/p>\n

To check if package\/rpm is installed
\nrpm \u2013qa grep {rpm_name} (From root)<\/p>\n

To install package\/rpm
\nrpm \u2013ivh {rpm_name} (From root)<\/p>\n

Kernel Parameter
\n<\/em><\/strong>Make sure you add following entry in \/etc\/sysctl.conf
\n<\/a><\/p>\n

After adding these entries execute below command to take these parameters in to effectsysctl \u2013p \/etc\/sysctl.conf<\/p>\n

Unzip software you downloaded above as<\/p>\n

unzip 10201_database_linux32.zip
\n<\/em><\/strong>
\nStarting Database Installation <\/strong><\/p>\n

———————————————
\nStart Oracle Universal Installer (OUI) by running.\/runInstaller (from location where you unzipped database) *Use operating system user like oracle or orainstall (don\u2019t execute runInstaller from root user)<\/span><\/p>\n

<\/span><\/p>\n

<\/a> 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.<\/a>
\nAgain 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)<\/p>\n

<\/a> This is important detail which is prompting for Database ORACLE_HOME Name and Destination Path.<\/p>\n

ORACLE_HOME<\/strong> is always unique per system which identifies oracle software installed (Oracle Software can be database, application server or various other oracle software)
\nPATH<\/strong> is directory where your oracle database software will be installed (Please note Oracle Software is not same as Oracle Data files)<\/p>\n

<\/a>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)<\/p>\n

<\/a><\/p>\n

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)<\/p>\n

<\/a>Leave default General Purpose in above screen<\/p>\n

<\/a>
\nIf you have selected \u201cCreate a Database\u201d 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 \u201corcl\u201d SID or change like \u201cSOADEV\u201d to uniquely identify this database that it is going to be used with SOA Suite)<\/a>Leave default \u201cDatabase Control Management\u201d or choose option 1 if you have Grid Control Agents installed on machine on which you are trying to install this database.<\/p>\n

<\/a>
\nHere 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)<\/p>\n

<\/a><\/a>Choose password for your various schema (For security reasons, don\u2019t choose same password for all accounts on production instance)<\/p>\n

<\/a>Click on \u201cInstall\u201d button to start your installation (Installation may take 30 minutes to 3 hours depending on your machine)<\/p>\n

<\/a><\/a><\/a><\/a>If you wish to unlock non system accounts click on \u201cPassword Management\u201d or click \u201cOK\u201d for unlocking them later. (For SOA Suite Installation, you can leave them locked)<\/p>\n

<\/a>execute command root.sh from root user as shown blow<\/p>\n

<\/a><\/a><\/a><\/p>\n

This will complete your database installation for SOA Suite Installation.<\/p>\n

If you wish to start\/stop oracle database installed above
\n<\/em><\/strong><\/p>\n

Set PATH, ORACLE_HOME, ORACLE_SID like
\nexport ORACLE_HOME = \/home\/oracle\/product\/10.2.0\/db <\/em><\/strong>
\nexport ORACLE_SID = SOADEV
\nexport PATH = $PATH:$ORACLE_HOME\/bin
\n<\/em><\/strong>
\n(Where ORACLE_HOME and ORACLE_SID we entered above while installing database)<\/p>\n

Stopping database services <\/strong>
\n—————————————
\n<\/strong>sqlplus \u201c\/as sysdba\u201d
\nSQL> shutdown immediate
\nlsnrctl stop<\/p>\n

Starting database services <\/strong>
\n—————————————
\n<\/strong>lsnrctl start
\nsqlplus \u201c\/as sysdba\u201d
\nSQL> start<\/p>\n

For SOA<\/span> Suite installation stay tuned (coming soon…)<\/span><\/strong>
\n
\n<\/span><\/strong>You can also subscribe to email feeds on right menu of this page for updates on this Apps DBA<\/span> blog.<\/span>
\n<\/span><\/p>\n

http:\/\/teachMeOracle.com\/forum<\/p>\n","protected":false},"excerpt":{"rendered":"

In next few posts I\u2019ll cover installation of SOA Suite (Service Oriented Architecture Suite) which is one of the components […]<\/p>\n","protected":false},"author":115,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[38],"tags":[18,21,463],"class_list":["post-155","post","type-post","status-publish","format-standard","hentry","category-soa","tag-database","tag-fusion","tag-soa"],"yoast_head":"\nOracle SOA Suite Installation Part I : Database Installation -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/13\/oracle-soa-suite-installation-part-i-database-installation\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle SOA Suite Installation Part I : Database Installation -\" \/>\n<meta property=\"og:description\" content=\"In next few posts I\u2019ll cover installation of SOA Suite (Service Oriented Architecture Suite) which is one of the components […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/13\/oracle-soa-suite-installation-part-i-database-installation\/\" \/>\n<meta property=\"article:published_time\" content=\"2007-06-13T18:56:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2007-12-30T07:26:07+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/bp0.blogger.com\/_LrtEX0cTLgI\/RnBQjyZnReI\/AAAAAAAAAmA\/p8gj9ugxxAg\/s400\/db_kernel.jpg\" \/>\n<meta name=\"author\" content=\"Masroof Ahmad\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Masroof Ahmad\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/13\/oracle-soa-suite-installation-part-i-database-installation\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/13\/oracle-soa-suite-installation-part-i-database-installation\/\",\"name\":\"Oracle SOA Suite Installation Part I : Database Installation -\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/13\/oracle-soa-suite-installation-part-i-database-installation\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/13\/oracle-soa-suite-installation-part-i-database-installation\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/bp0.blogger.com\/_LrtEX0cTLgI\/RnBQjyZnReI\/AAAAAAAAAmA\/p8gj9ugxxAg\/s400\/db_kernel.jpg\",\"datePublished\":\"2007-06-13T18:56:00+00:00\",\"dateModified\":\"2007-12-30T07:26:07+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/13\/oracle-soa-suite-installation-part-i-database-installation\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/13\/oracle-soa-suite-installation-part-i-database-installation\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/13\/oracle-soa-suite-installation-part-i-database-installation\/#primaryimage\",\"url\":\"http:\/\/bp0.blogger.com\/_LrtEX0cTLgI\/RnBQjyZnReI\/AAAAAAAAAmA\/p8gj9ugxxAg\/s400\/db_kernel.jpg\",\"contentUrl\":\"http:\/\/bp0.blogger.com\/_LrtEX0cTLgI\/RnBQjyZnReI\/AAAAAAAAAmA\/p8gj9ugxxAg\/s400\/db_kernel.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/13\/oracle-soa-suite-installation-part-i-database-installation\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle SOA Suite Installation Part I : Database Installation\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineappsdba.com\/#website\",\"url\":\"https:\/\/onlineappsdba.com\/\",\"name\":\"\",\"description\":\"Oracle Implementation & Training Experts\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineappsdba.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\",\"name\":\"Masroof Ahmad\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"caption\":\"Masroof Ahmad\"},\"url\":\"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle SOA Suite Installation Part I : Database Installation -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/13\/oracle-soa-suite-installation-part-i-database-installation\/","og_locale":"en_US","og_type":"article","og_title":"Oracle SOA Suite Installation Part I : Database Installation -","og_description":"In next few posts I\u2019ll cover installation of SOA Suite (Service Oriented Architecture Suite) which is one of the components […]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/13\/oracle-soa-suite-installation-part-i-database-installation\/","article_published_time":"2007-06-13T18:56:00+00:00","article_modified_time":"2007-12-30T07:26:07+00:00","og_image":[{"url":"http:\/\/bp0.blogger.com\/_LrtEX0cTLgI\/RnBQjyZnReI\/AAAAAAAAAmA\/p8gj9ugxxAg\/s400\/db_kernel.jpg","type":"","width":"","height":""}],"author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/13\/oracle-soa-suite-installation-part-i-database-installation\/","url":"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/13\/oracle-soa-suite-installation-part-i-database-installation\/","name":"Oracle SOA Suite Installation Part I : Database Installation -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/13\/oracle-soa-suite-installation-part-i-database-installation\/#primaryimage"},"image":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/13\/oracle-soa-suite-installation-part-i-database-installation\/#primaryimage"},"thumbnailUrl":"http:\/\/bp0.blogger.com\/_LrtEX0cTLgI\/RnBQjyZnReI\/AAAAAAAAAmA\/p8gj9ugxxAg\/s400\/db_kernel.jpg","datePublished":"2007-06-13T18:56:00+00:00","dateModified":"2007-12-30T07:26:07+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/13\/oracle-soa-suite-installation-part-i-database-installation\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2007\/06\/13\/oracle-soa-suite-installation-part-i-database-installation\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/13\/oracle-soa-suite-installation-part-i-database-installation\/#primaryimage","url":"http:\/\/bp0.blogger.com\/_LrtEX0cTLgI\/RnBQjyZnReI\/AAAAAAAAAmA\/p8gj9ugxxAg\/s400\/db_kernel.jpg","contentUrl":"http:\/\/bp0.blogger.com\/_LrtEX0cTLgI\/RnBQjyZnReI\/AAAAAAAAAmA\/p8gj9ugxxAg\/s400\/db_kernel.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2007\/06\/13\/oracle-soa-suite-installation-part-i-database-installation\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"Oracle SOA Suite Installation Part I : Database Installation"}]},{"@type":"WebSite","@id":"https:\/\/onlineappsdba.com\/#website","url":"https:\/\/onlineappsdba.com\/","name":"","description":"Oracle Implementation & Training Experts","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineappsdba.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb","name":"Masroof Ahmad","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","caption":"Masroof Ahmad"},"url":"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/155","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/users\/115"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/comments?post=155"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/155\/revisions"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=155"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=155"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=155"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}