{"id":524,"date":"2012-02-02T11:02:41","date_gmt":"2012-02-02T05:32:41","guid":{"rendered":"http:\/\/www.oratraining.com\/blog\/?p=524"},"modified":"2013-01-07T07:51:37","modified_gmt":"2013-01-07T07:51:37","slug":"installing-transactional-database","status":"publish","type":"post","link":"https:\/\/www.oratraining.com\/blog\/2012\/02\/installing-transactional-database\/","title":{"rendered":"Installing Transactional Database"},"content":{"rendered":"

Oracle Fusion Applications Installation<\/span>: Installing Transactional Database
\n<\/strong><\/span><\/p>\n

Previous: Installing Fusion Applications Provisioning Framework<\/a><\/strong><\/p>\n

Important Note: This is OLD guide for old version 11.1.1.5. Please follow instructions at\u00a0<\/span>http:\/\/www.oratraining.com\/blog\/2012\/12\/oracle-fusion-applications-installation-step-by-step-guide-11-1-5\/<\/a>\u00a0for latest guide for current version i.e. 11.1.5<\/span><\/h3>\n

 <\/p>\n

To install Applications Transactional Database we need to run Oracle Fusion Applications Provisioning Wizard<\/strong> from <framework_location>\/provisioning\/bin<\/em><\/strong>
\n<\/em><\/p>\n

<framework_location> <\/em>is same what we mentioned in previous post. i.e. \/app\/fusion<\/em><\/p>\n

[oracle@fusion $ cd \/app\/fusion\/provisioning\/bin<\/strong><\/p>\n

We need to temporarily set JAVA_HOME to jdk6 directory shipped with the installation media<\/p>\n

[oracle@fusion bin]$ export JAVA_HOME=\/mnt\/fusion\/jdk6<\/strong><\/p>\n

[oracle@fusion bin]$ .\/provisioningWizard.sh<\/strong><\/p>\n

\"\"<\/p>\n

Click Next<\/strong><\/p>\n

\"\"<\/p>\n

Click Next<\/strong><\/p>\n

\"\"<\/p>\n

Deselect security updates notification. Click Next<\/strong>
\n\"\"<\/p>\n

Provide database listener port (default is 1521, if you change this port please note to enter the new port in future screens where we have mentioned 1521)<\/p>\n

Installer directory location will be the same as you created the stage setup or provisioning repository.<\/p>\n

Provide a location for Oracle Base. Press TAB, next values should automatically be populated, if not, go back and click next again.<\/p>\n

Enter dba<\/strong> as OSDBA group.<\/p>\n

We have specified “fusiondb<\/strong>” as our database name. please note that if you are using any other name then don’t forget to change it in further screens whenever we have mentioned fusiondb.<\/p>\n

Try to keep something like “Oracle123<\/strong>” for all passwords so that it will follow requirements for all further passwords and it will be easier for you to remember all passwords in further installations.<\/p>\n

\"\"<\/p>\n

Next it will finish the pre-requisite checks. Click Next<\/strong><\/p>\n

\"\"<\/p>\n

On next page, you can Save<\/strong> the summary. Click Install<\/strong> to start the installation.<\/p>\n

Note: This will install the software as well as create a database named “fusiondb” which we provided earlier.<\/p>\n

\"\"<\/p>\n

At this point it will prompt for running root.sh as root user.<\/p>\n

 <\/p>\n

\"\"<\/p>\n

Do not press Ok until run the following as root user in separate terminal window. Once following is executed, press Ok <\/strong>to continue.<\/p>\n

 <\/p>\n

[root@fusion ~]# \/app\/fusion\/database\/product\/11.2.0\/dbhome_1\/root.sh<\/p>\n

Check \/app\/fusion\/database\/product\/11.2.0\/dbhome_1\/install\/root_fusion_2012-01-1 5_12-29-28.log for the output of root script<\/p>\n

[root@fusion ~]# tail -f \/app\/fusion\/database\/product\/11.2.0\/dbhome_1\/install\/root_fusion_2012-01-15_12-29-28.log<\/p>\n

The following environment variables are set as:<\/p>\n

ORACLE_OWNER= oracle<\/p>\n

ORACLE_HOME= \/app\/fusion\/database\/product\/11.2.0\/dbhome_1<\/p>\n

 <\/p>\n

Creating \/etc\/oratab file…<\/p>\n

Entries will be added to the \/etc\/oratab file as needed by<\/p>\n

Database Configuration Assistant when a database is created<\/p>\n

Finished running generic part of root script.<\/p>\n

Now product-specific root actions will be performed.<\/p>\n

Finished product-specific root actions.<\/p><\/blockquote>\n

 <\/p>\n

\"\"
\n<\/strong><\/p>\n

It may take a few hours (at least on a non-high end host machine) and then installation will finish.<\/p>\n

Important Note: <\/strong>After installation is finished we reduced the SGA and PGA (from 10GB to 2GB). We are doing this since we are running on a VM and have allocated total 2.5 or 3 GB RAM only. This is not recommended for production installation but since this is only a demo\/development installation, you can safely do this. If you wish to keep it 10GB you can do it but this will increase the swap usage exponentially.<\/span><\/p>\n

Since we are reducing the size of SGA and PGA, next step (RCU) may fail in pre-requisite check. So we will need to change the pre-req check xml file to look for lower value. We will explain this in next post.<\/span><\/p><\/blockquote>\n

Next: \u00a0Running Oracle Fusion Applications Repository Creation Utility (Applications RCU)<\/a><\/strong><\/p>\n

Installing Oracle Fusion Applications – steps<\/a><\/strong><\/p>\n

    \n
  1. Installing Fusion Applications Provisioning Framework<\/a>
    \n<\/strong><\/li>\n
  2. Installing Oracle 11g Database (Applications Transactional Database)<\/a>
    \n<\/strong><\/li>\n
  3. Running Oracle Fusion Applications Repository Creation Utility (Applications RCU)
    \n<\/a><\/strong><\/li>\n
  4. Creating another database for Oracle \u00a0Identity Management Infrastructure\u00a0<\/strong>(optional)
    \n<\/strong><\/li>\n
  5. Running Repository Creation Utility (RCU) for Oracle Identity Management components<\/a><\/strong><\/li>\n
  6. Installing Oracle Identity and Access Management Components<\/a>
    \n<\/strong><\/li>\n
  7. Configuring Oracle Identity and Access Management components<\/a>
    \n<\/strong><\/li>\n
  8. Integrate Oracle Identity Manager (OIM) and Oracle Access Manager (OAM)<\/a><\/strong>
    \n<\/strong><\/li>\n
  9. Creating a New Provisioning Plan<\/a>
    \n<\/strong><\/li>\n
  10. Provisioning an Applications Environment<\/a><\/strong><\/li>\n<\/ol>\n


    \n<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

    Oracle Fusion Applications Installation: Installing Transactional Database Previous: Installing Fusion Applications Provisioning Framework Important Note: This is OLD guide for old version 11.1.1.5. Please follow instructions at\u00a0http:\/\/www.oratraining.com\/blog\/2012\/12\/oracle-fusion-applications-installation-step-by-step-guide-11-1-5\/\u00a0for latest guide for current version i.e. 11.1.5   To install Applications Transactional Database we need to run Oracle Fusion Applications Provisioning Wizard from <framework_location>\/provisioning\/bin <framework_location> is same what […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[32,36,4,5,6,8,10,12,14],"tags":[43,47,48,66,78,85,87,196,97,98,198,99,100,103,113,137],"class_list":["post-524","post","type-post","status-publish","format-standard","hentry","category-fusion-applications-provisioning","category-installing-oracle-applications","category-oracle","category-applications","category-oracle-applications-dba","category-database","category-oracle-dba","category-oracle-fusion-applications","category-oracle-rac","tag-11g","tag-administration","tag-applications-transactional-database","tag-fusion-11g","tag-install-oracle-database","tag-installing-oracle-database","tag-installing-oracle-fusion-applications","tag-oracle","tag-oracle-11g","tag-oracle-applications","tag-oracle-applications-dba","tag-oracle-apps","tag-oracle-database","tag-oracle-fusion-applications-2","tag-rac","tag-transactional-database"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/posts\/524","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/comments?post=524"}],"version-history":[{"count":0,"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/posts\/524\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/media?parent=524"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/categories?post=524"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/tags?post=524"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}