{"id":3320,"date":"2013-11-03T00:15:48","date_gmt":"2013-11-03T00:15:48","guid":{"rendered":"http:\/\/www.oratraining.com\/blog\/?p=3320"},"modified":"2015-09-20T06:14:22","modified_gmt":"2015-09-20T06:14:22","slug":"install-oracle-11g-database-fusion-apps-database-2","status":"publish","type":"post","link":"https:\/\/www.oratraining.com\/blog\/2013\/11\/install-oracle-11g-database-fusion-apps-database-2\/","title":{"rendered":"Install Oracle 11g Database (Fusion Apps Database)"},"content":{"rendered":"

Installing Oracle Fusion Applications > Setting up Fusion Applications Node > Install Oracle 11g Database (Fusion Apps Database)
\n<\/strong><\/p>\n

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

\n

Pro\u00a0Oracle Fusion Applications – Installation and Administration<\/strong><\/p>\n

Now you can buy the first and only\u00a0comprehensive book on Oracle Fusion Applications Installation and Administration which covers end to end\u00a0information on introduction, planning, installation and troubleshooting guides for implementing\u00a0Fusion Applications on premise. Buy it now from any of the following stores.<\/p>\n

http:\/\/www.amazon.com\/Pro-Oracle-Fusion-Applications-Administration\/dp\/1484209842<\/a><\/p>\n

http:\/\/www.barnesandnoble.com\/w\/pro-oracle-fusion-applications-tushar-thakker\/1121094340<\/a><\/p>\n

http:\/\/www.apress.com\/9781484209844<\/a><\/p>\n

http:\/\/www.springer.com\/us\/book\/9781484209844<\/a><\/p><\/blockquote>\n

Let us first install JDK6 since we will need this to be on a permanent location.<\/p>\n

[fusion@fahost ~]$ cd \/app\/fusion\/
\n<\/span><\/p>\n

[fusion@fahost fusion]$ unzip \/stage\/installers\/jdk\/jdk6.zip
\n<\/span><\/p>\n

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

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

[fusion@fahost ~]$ cd \/app\/fusion\/provisioning\/bin\/
\n<\/span><\/p>\n

[fusion@fahost bin]$ export JAVA_HOME=\/app\/fusion\/jdk6
\n<\/span><\/p>\n

[fusion@fahost bin]$ .\/provisioningWizard.sh &
\n<\/span><\/p>\n

\"\"<\/p>\n

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

\"\"<\/p>\n

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

\"\"<\/p>\n

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

\"\"<\/p>\n

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

\"\"<\/p>\n

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

Port:\u00a01521<\/strong>\u00a0(change it I you need)<\/p>\n

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

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

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

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

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

Password:\u00a0Oracle123<\/strong>\u00a0(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

You might see some warning related to memory if you are using less than 26 GB memory for this host. You can ignore this since we are going to reduce the memory target after installation.<\/p>\n

\"\"<\/p>\n

Once prerequisites check is successful, click Next<\/strong>. Save summary if required<\/p>\n

\"\"<\/p>\n

Once Installation completes (20% progress), it will prompt as above. Open another window and run the following script as root user.<\/p>\n

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

Check \/app\/database\/product\/11.2.0\/dbhome_1\/install\/root_fahost.paramlabs.com_2013-11-01_16-43-36.log for the output of root script<\/p>\n

[root@fahost fusion]# more \/app\/database\/product\/11.2.0\/dbhome_1\/install\/root_fahost.paramlabs.com_2013-11-01_16-43-36.log
\n<\/span><\/p>\n

Performing root user operation for Oracle 11g<\/p>\n

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

ORACLE_OWNER= fusion<\/p>\n

ORACLE_HOME= \/app\/database\/product\/11.2.0\/dbhome_1<\/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>\n

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

\"\"<\/p>\n

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

\"\"<\/p>\n

Click\u00a0Close<\/strong>\u00a0to complete the installation<\/p>\n

Reduce memory size of database<\/strong><\/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:<\/strong>\u00a0We 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.<\/p>\n

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

export ORACLE_HOME<\/p>\n

PATH=$PATH:$ORACLE_HOME\/bin<\/p>\n

export PATH<\/p>\n

ORACLE_SID=fusiondb<\/p>\n

export ORACLE_SID<\/p>\n

[fusion@fahost bin]$\u00a0sqlplus \/ as sysdba
\n<\/span><\/p>\n

SQL> show parameter pga
\n<\/span><\/p>\n

NAME TYPE VALUE<\/p>\n

———————————— ———– ——————————<\/p>\n

pga_aggregate_target big integer 4G<\/p>\n

SQL> show parameter sga
\n<\/span><\/p>\n

NAME TYPE VALUE<\/p>\n

———————————— ———– ——————————<\/p>\n

lock_sga boolean FALSE<\/p>\n

pre_page_sga boolean FALSE<\/p>\n

sga_max_size big integer 9G<\/p>\n

sga_target big integer 9G<\/p>\n

SQL> show parameter memory
\n<\/span><\/p>\n

NAME TYPE VALUE<\/p>\n

———————————— ———– ——————————<\/p>\n

hi_shared_memory_address integer 0<\/p>\n

memory_max_target big integer 0<\/p>\n

memory_target big integer 0<\/p>\n

shared_memory_address integer 0<\/p>\n

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

Database closed.<\/p>\n

Database dismounted.<\/p>\n

ORACLE instance shut down.<\/p>\n

[fusion@fahost dbs]$ cp -pr initfusiondb.ora initfusiondb.ora.bak
\n<\/span><\/p>\n

[fusion@fahost dbs]$ vi initfusiondb.ora
\n<\/span><\/p>\n

Edit the values as follows and add last line as memory_target<\/p>\n

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

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

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

fusiondb.__oracle_base=’\/app\/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=3G
\n<\/strong><\/p>\n

Let’s recreate spfile using this pfile.<\/p>\n

[fusion@fahost dbs]$ sqlplus \/ as sysdba
\n<\/span><\/p>\n

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

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

File created.<\/p>\n

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

Also change the value for open_cursors parameter to 800<\/p>\n

SQL> show parameter open_cursors
\n<\/span><\/p>\n

NAME TYPE VALUE<\/p>\n

\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014 \u2014\u2014\u2014\u2013 \u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014<\/p>\n

open_cursors integer 500<\/p>\n

SQL> alter system set open_cursors=800 scope=both sid=’*’;
\n<\/span><\/p>\n

System altered.<\/p>\n

SQL> show parameter open_cursors
\n<\/span><\/p>\n

NAME TYPE VALUE<\/p>\n

\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014 \u2014\u2014\u2014\u2013 \u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014<\/p>\n

open_cursors integer 800<\/p>\n

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

 <\/p>\n

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

A. Setting up Identity and Access Management Node
\n<\/strong><\/p>\n

1. Install Fusion Applications Provisioning Framework<\/a><\/p>\n

2. Install Oracle 11g Database (Identity management database)<\/a><\/p>\n

3. Run Repository Creation Utility (RCU) for Oracle Identity Management components<\/a><\/p>\n

4. Install Identity Management Provisioning Wizard<\/a><\/p>\n

5. Create IDM provisioning Response File<\/a><\/p>\n

6. Provision Identity Management<\/a><\/p>\n

7. Perform Post-Provisioning Configuration<\/a><\/p>\n

B. Setting up Fusion Applications Node
\n<\/strong><\/p>\n

1. Install Fusion Applications Provisioning Framework<\/a><\/p>\n

2. Install Oracle 11g Database (Fusion Apps Database)<\/p>\n

3. Run Oracle Fusion Applications Repository Creation Utility (Applications RCU)<\/a><\/p>\n

4. Create new Applications Provisioning Response File<\/a><\/p>\n

5.\u00a0Provision an Applications Environment<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Installing Oracle Fusion Applications > Setting up Fusion Applications Node > Install Oracle 11g Database (Fusion Apps Database) Previous: Install Fusion Applications Provisioning Framework Pro\u00a0Oracle Fusion Applications – Installation and Administration Now you can buy the first and only\u00a0comprehensive book on Oracle Fusion Applications Installation and Administration which covers end to end\u00a0information on introduction, planning, […]<\/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":[1],"tags":[],"class_list":["post-3320","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/posts\/3320","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=3320"}],"version-history":[{"count":2,"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/posts\/3320\/revisions"}],"predecessor-version":[{"id":3703,"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/posts\/3320\/revisions\/3703"}],"wp:attachment":[{"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/media?parent=3320"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/categories?post=3320"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/tags?post=3320"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}