Oracle Fusion Applications Installation: Install Oracle 11g Database (Applications Transactional Database)

Previous: Install Fusion Applications Provisioning Framework

Fusion Applications 11.1.6 ships with Oracle 11g (11.2.0.3.0) database. You can either install it separately (if you want to install RAC database) or use Fusion provisioning Wizard to create one.

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

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

[fusion@fmwhost Disk1]$ cd /app/fusion/provisioning/bin/

We need to temporarily set JAVA_HOME to jdk6 directory shipped with the installation media

[fusion@fmwhost bin]$ export JAVA_HOME=/mnt/hgfs/setup/jdk6

[fusion@fmwhost bin]$ ./provisioningWizard.sh – ignoreSysPrereqs true &

Please use “ignoreSysPrereqs true” flag since you might need to skip some memory prerequisite warnings if required.

Click Next

Select “Install an Applications Transactional Database” option. Click Next

Deselect the checkbox if you wish and click Next

Click Yes

Enter values as mentioned here and click Next.

Port: 1521 (we have kept it default, you can change it)

Installers directory location: /mnt/hgfs/stage (directory where we created the stage)

Oracle Base: /app/fusion/database

Software Location: Will be populated automatically

OSDBA group: dba

Global Database Name: fusiondb (you can keep any name you want)

Password: Oracle123 (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)

Once prerequisites check is successful, click Next. Save summary if required

Save summary if required.

Once Installation completes (20% progress), it will prompt as follows.

Open another window and run the following script.

root@fmwhost # /app/fusion/database/product/11.2.0/dbhome_1/root.sh

Check /app/fusion/database/product/11.2.0/dbhome_1/install/root_fmwhost.paramlabs.com_2013-02-28_17-06-18.log for the output of root script

[root@fmwhost ~]# tail -f /app/fusion/database/product/11.2.0/dbhome_1/install/root_fmwhost.paramlabs.com_2013-02-28_17-06-18.log

The following environment variables are set as:

ORACLE_OWNER= fusion

ORACLE_HOME= /app/fusion/database/product/11.2.0/dbhome_1

Creating /etc/oratab file…

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Finished product-specific root actions.

Click OK

Once installation till validation is complete, click Next. If you get minimum memory related warning, you can ignore here, provided you have used “ignoreSysPrereqs true” flag

Click Close to complete the installation.

Reduce memory size of database

We will reduce the size of SGA and PGA to avoid getting out of memory in server since fusion requires too much memory.

Important Note: 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.

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.

[fusion@fmwhost bin]$ export ORACLE_HOME=/app/fusion/database/product/11.2.0/dbhome_1

[fusion@fmwhost bin]$ export ORACLE_SID=fusiondb

[fusion@fmwhost bin]$ export PATH=$PATH:$PATH:$ORACLE_HOME/bin

[fusion@fmwhost bin]$ sqlplus / as sysdba

SQL> create pfile from spfile;

File created.

SQL> shut immediate;

[fusion@fmwhost bin]$ more /app/fusion/database/product/11.2.0/dbhome_1/dbs/initfusiondb.ora

#fusiondb.__db_cache_size=7516192768

#fusiondb.__java_pool_size=33554432

#fusiondb.__large_pool_size=33554432

fusiondb.__oracle_base=’/app/fusion/database’#ORACLE_BASE set from environment

#fusiondb.__pga_aggregate_target=4294967296

#fusiondb.__sga_target=9663676416

#fusiondb.__shared_io_pool_size=536870912

#fusiondb.__shared_pool_size=1442840576

#fusiondb.__streams_pool_size=33554432

#*.pga_aggregate_target=4294967296

#*.sga_target=9663676416

*.memory_target=2147483648

-bash-3.2$ sqlplus / as sysdba

Connected to an idle instance.

SQL> create spfile from pfile;

File created.

SQL> startup

ORACLE instance started.

Total System Global Area 2138521600 bytes

Fixed Size 2161024 bytes

Variable Size 1795163776 bytes

Database Buffers 335544320 bytes

Redo Buffers 5652480 bytes

Database mounted.

Database opened.

Next: Run Oracle Fusion Applications Repository Creation Utility (Applications RCU)

Installing Oracle Fusion Applications – steps

Install Fusion Applications Provisioning Framework
Install Oracle 11g Database (Applications Transactional Database)
Run Oracle Fusion Applications Repository Creation Utility (Applications RCU)
Create another database for Oracle Identity Management Infrastructure (optional)
Run Repository Creation Utility (RCU) for Oracle Identity Management components
Install Oracle Identity and Access Management Components
Apply mandatory Patches
Configure Oracle Identity and Access Management components
Integrate Oracle Identity Manager (OIM) and Oracle Access Manager (OAM)
Install provisioning framework on Node 2
Create new Response File
Provision an Applications Environment (Editing in progress, this link currently points to 11.1.5 counterpart)

Ora Training Blog

Oracle Fusion Applications Installation: Install Oracle 11g Database (Applications Transactional Database)

Leave a comment

Hot topics

Categories

Recent Posts

Recent Comments

Archives