{"id":1292,"date":"2012-12-25T10:46:35","date_gmt":"2012-12-25T10:46:35","guid":{"rendered":"http:\/\/www.oratraining.com\/blog\/?p=1292"},"modified":"2013-03-20T10:50:32","modified_gmt":"2013-03-20T10:50:32","slug":"install-oracle-11g-database-applications-transactional-database","status":"publish","type":"post","link":"https:\/\/www.oratraining.com\/blog\/2012\/12\/install-oracle-11g-database-applications-transactional-database\/","title":{"rendered":"Oracle Fusion Applications Installation: Install Oracle 11g Database (Applications Transactional Database)"},"content":{"rendered":"

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

Fusion Applications 11.1.5 ships with Oracle 11g (11.2.0.3.0) database. You can either install it saperately (if you want to install RAC database) or use Fusion provisioning Wizard to create one.\u00a0<\/span><\/p>\n

To install Applications Transactional Database we need to run\u00a0Oracle Fusion Applications Provisioning Wizard<\/strong>\u00a0from\u00a0<framework_location>\/provisioning\/bin<\/em><\/strong>
\n<\/span><\/p>\n

<framework_location>\u00a0<\/em>is same where we installed the framework in previous post. i.e.\u00a0\/app\/fusion<\/strong><\/em>
\n<\/span><\/p>\n

-bash-3.2$ cd \/app\/fusion\/provisioning\/bin\/<\/span><\/p>\n

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

-bash-3.2$ export JAVA_HOME=\/u02\/stage\/jdk6<\/span>
\n<\/span><\/p>\n

-bash-3.2$ .\/provisioningWizard.sh<\/span><\/p>\n

\"\"<\/p>\n

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

\"\"<\/p>\n

Select “Install an Applications Transactional Database” option. Click Next<\/strong><\/p>\n

\"\"<\/p>\n

Deselect the checkbox if you wish and click Next
\n<\/strong><\/p>\n

\"\"<\/p>\n

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

\"\"<\/p>\n

Enter values as mentioned here and click Next.
\n<\/strong><\/p>\n

Port: 1521<\/strong> (we have kept it default, you can change it)<\/p>\n

Installers directory location: \/u02\/stage<\/strong> (directory where we created the stage)<\/p>\n

Oracle Base: \/app\/fusion\/database
\n<\/strong><\/p>\n

Software Location: Will be populated automatically<\/strong><\/p>\n

OSDBA group: dba<\/strong><\/p>\n

Global Database Name: fusiondb<\/strong> (you can keep any name you want)<\/p>\n

Password: Oracle123<\/strong> (We have used Oracle123 for any passwords during the installation since it satisfies all requirements during this installation. You can keep any complex password you want)<\/p>\n

\"\"<\/p>\n

Once prerequisites check is successful, click Next<\/strong><\/p>\n

\"\"Verify summary and click Install <\/strong>to start 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

Once Installation completes (20% progress), it will prompt as follows.<\/p>\n

\"\"<\/p>\n

Open another window and run the following scripts.<\/p>\n

root@ad002aph01 # \/app\/fusion\/database\/product\/11.2.0\/dbhome_1\/root.sh<\/span><\/p>\n

Check \/app\/fusion\/database\/product\/11.2.0\/dbhome_1\/install\/root_ad002aph01_2012-12-18_12-08-54.log for the output of root script<\/p>\n

root@ad002aph01 # tail -f \/app\/fusion\/database\/product\/11.2.0\/dbhome_1\/install\/root_ad002aph01_2012-12-18_12-08-54.log
\n<\/span><\/p>\n

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

ORACLE_OWNER= fusion<\/p>\n

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

Creating \/var\/opt\/oracle\/oratab file…<\/p>\n

Entries will be added to the \/var\/opt\/oracle\/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>\n

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

\"\"<\/p>\n

Once installation till validation is complete, click Next<\/strong><\/p>\n

\"\"<\/p>\n

Review the summary and click Close<\/strong><\/p>\n

Reduce memory size of database
\n<\/strong><\/span><\/p>\n

We will reduce the size of SGA and PGA to avoid getting out of memory in server since fusion requires too much memory.<\/p>\n

Important Note:\u00a0<\/strong>We are reducing the SGA and PGA (from 10GB to 2GB). We are doing this since we are running on lesser RAM than required. 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>
\n<\/span><\/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>
\n<\/span><\/span><\/p>\n

-bash-3.2$ export ORACLE_HOME=\/app\/fusion\/database\/product\/11.2.0\/dbhome_1
\n<\/span><\/p>\n

-bash-3.2$ export ORACLE_SID=fusiondb
\n<\/span><\/p>\n

-bash-3.2$ export PATH=$PATH:$PATH:$ORACLE_HOME\/bin
\n<\/span><\/p>\n

-bash-3.2$ sqlplus \/ as sysdba
\n<\/span><\/p>\n

SQL> create pfile from spfile;<\/span><\/p>\n

File created.<\/p>\n

SQL> shut immediate;<\/span><\/p>\n

-bash-3.2$ more \/app\/fusion\/database\/product\/11.2.0\/dbhome_1\/dbs\/initfusiondb.ora<\/span><\/p>\n

#fusiondb.__db_cache_size=7516192768<\/p>\n

#fusiondb.__java_pool_size=33554432<\/p>\n

#fusiondb.__large_pool_size=33554432<\/p>\n

fusiondb.__oracle_base=’\/app\/fusion\/database’#ORACLE_BASE set from environment<\/p>\n

#fusiondb.__pga_aggregate_target=4294967296<\/p>\n

#fusiondb.__sga_target=9663676416<\/p>\n

#fusiondb.__shared_io_pool_size=536870912<\/p>\n

#fusiondb.__shared_pool_size=1442840576<\/p>\n

#fusiondb.__streams_pool_size=33554432<\/p>\n

#*.pga_aggregate_target=4294967296<\/p>\n

#*.sga_target=9663676416<\/p>\n

*.memory_target=2147483648
\n<\/strong><\/span><\/p>\n

-bash-3.2$ sqlplus \/ as sysdba<\/p>\n

Connected to an idle instance.<\/p>\n

SQL> create spfile from pfile;
\n<\/span><\/p>\n

File created.<\/p>\n

SQL> startup<\/span><\/p>\n

ORACLE instance started.<\/p>\n

Total System Global Area 2138521600 bytes<\/p>\n

Fixed Size 2161024 bytes<\/p>\n

Variable Size 1795163776 bytes<\/p>\n

Database Buffers 335544320 bytes<\/p>\n

Redo Buffers 5652480 bytes<\/p>\n

Database mounted.<\/p>\n

Database opened.<\/p>\n

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

    \n
  1. \n
  2. \n
  3. \n
  4. \n
    Create another database for Oracle Identity Management Infrastructure (optional)<\/div>\n<\/li>\n
  5. \n
  6. \n
  7. \n
  8. \n
  9. \n
  10. \n
  11. \n
    Provision an Applications Environment<\/a><\/div>\n<\/li>\n<\/ol>\n

    Next: <\/strong>Run Oracle Fusion Applications Repository Creation Utility (Applications RCU)<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

    Previous: Install Fusion Applications Provisioning Framework Fusion Applications 11.1.5 ships with Oracle 11g (11.2.0.3.0) database. You can either install it saperately (if you want to install RAC database) or use Fusion provisioning Wizard to create one.\u00a0 To install Applications Transactional Database we need to run\u00a0Oracle Fusion Applications Provisioning Wizard\u00a0from\u00a0<framework_location>\/provisioning\/bin <framework_location>\u00a0is same where we installed the […]<\/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":[25,30,32,36,4,5,6,7,8,10,12,150,1],"tags":[],"class_list":["post-1292","post","type-post","status-publish","format-standard","hentry","category-oracle-application-server","category-database-performance-tuning","category-fusion-applications-provisioning","category-installing-oracle-applications","category-oracle","category-applications","category-oracle-applications-dba","category-oracle-applications-issues","category-database","category-oracle-dba","category-oracle-fusion-applications","category-oracle-fusion-applications-installation-fusion-applications-provisioning","category-uncategorized"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/posts\/1292","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=1292"}],"version-history":[{"count":0,"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/posts\/1292\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/media?parent=1292"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/categories?post=1292"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/tags?post=1292"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}