INSTALLING FUSION APPLICATIONS DATABASE WITH RCU IN LINUX 84x64 [Part1]
We need to install oracle 11gR2 [11.2.0.3] database .. to install the Fusion applications Release 5[rup4].. oracle fusion applications can be architecture with four database
[1] fusion applications transaction database,[FADB]
[2]OID database[OIDDB]
[3] OAM database[OAMDB]
[4] data warehouse database for fusion BI [the 4 data ware house database is optional need to installed if we are using the BI] ..
Here we have explained the steps to install the fusion applications transitional database...which holds the all the transitional data of the fusion applications ..
[1] preparing the Linux box to install the database
[2] installing the database binaries
[3] configuring the database for fusion applications with necessary patches
[4] Running Rcu to create the fusion schema's
[1] Preparing Linux 86x64 box for installing fusion applications transitional database
Step 1
Install the Necessary Rpm's
1] binutils-2.17.50*
2] compat-libstdc++-33-3.2.3-61*
3] elfutils-libelf-*
4] glibc-2.5-81.el5_8.2.
5] glibc-common-2.5-81.el5_8.2.
6] ksh-20100621-5.el5_8.1
7] libaio-0.3.106-5.x86_64
8] libgcc-4.1.2-52.el5_8.1
9] libstdc++-4.1.2-52.el5_8.1
10]libstdc++44-devel.x86_64
11]glibc-headers-2.5-81.el5_8.2.x86_64
12] sysstat-7.0.2-11.el5.x86_64
13] unixODBC-devel-2.2.11-10.el5
14]unixODBC-2.2.11-10.el5
15]unixODBC-libs-2.2.11-10.el5
16]gcc-c++-4.1.2-52.el5_8.1.x86_64
17]kernel-headers.x86_64
18]glibc-devel-2.5-81.el5_8.2.
19]libgomp-4.4.6-3.el5.1
20]make-3.81-3.el5.x86_64
21]openmotif22-2.2.3-20
22]openmotif-2.3.1-6.1.el5_8
23]xorg-x11-utils
Step 2
Create the username and group in O/S
[root@fah ~]# groupadd orafusion
[root@fah ~]# groupadd oper
[root@fah ~]#useradd orafadb -g orafusion -G oper
-g is the primary group's name
-G is the secondary group's name
[root@fah ~]# id orafadb
uid=54326(orafadb) gid=54324(orafusion) groups=54324(orafusion),54323(oper)
Step 3
Create directory and give necessary permissions to the directory
we have created the mount point and mounted in the /u03/app and navigate to /u03/app/ and create the directory
[root@fah app] #mkdir oracle
[root@fah app] #chown orafadb:orafusion oracle
[root@fah app]#chmod -R g+w oracle
Step 4
LIMITS.CONF VALUES FOR THE FUSION TRANSACTION DATABASE O/S USER
Navigate to limit's.conf which is located in /etc/security
orafadb soft nofile 327679
orafadb hard nofile 327679
orafadb soft nproc 131072
orafadb hard nproc 131072
orafadb soft stack 131072
orafadb soft core unlimited
orafadb hard core unlimited
orafadb soft memlock 50000000
orafadb hard memlock 50000000
Legends for <type> in limits.conf file
hard
Hard is used for enforcing hard resource limits. These limits are set by the superuser and enforced by the Kernel. The user cannot raise his requirement of system resources above such values
Soft
Soft is used for enforcing soft resource limits. These limits are ones that the user can move up or down within the permitted range by any pre-existing hard limits.
Legends for <item> in limits.conf file
core
limits the core file size
memlock maximum locked-in-memory address space
nproc maximum number of processes
nofile maximum number of open files
stack maximum stack size
Step 5
Create the environmental variables in the .bash_profile for the database
Edit the .bash_profile which is located under the ~ [home directory ] of the user and add the Environmental variables listed below
Change the database_sid and basepath according to the environment
export PATH
ORACLE_SID=<database_sid>; export ORACLE_SID
ORACLE_BASE=<base path of the oracle binaries>; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN
PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin
PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
export PATH=$PATH:$ORACLE_HOME/OPatch
export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib
export CLASSPATH
export TEMP=/tmp
Legends
database_ sid = Database Name [ ORCL]
base path = The path where we are going to install the oracle binary's and it will be before the products directory for ex [/u03/app/oracle]
Step 6
KERNAL PARAMETER VALUES FOR THE FUSION APPLICATIONS DATABASE
Edit the /etc/syscctl.conf file for modifying the Kernel Parameter's
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
fs.file-max = 6815744
kernel.msgmni = 2878
kernel.msgmax = 8192
kernel.msgmnb = 65536
kernel.sem = 250 32000 100 142
kernel.shmmni = 4096
kernel.shmall = 4294967296
kernel.shmmax = 88046829568
kernel.sysrq = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
fs.aio-max-nr = 3145728
net.ipv4.ip_local_port_range = 9000 65500
vm.min_free_kbytes = 51200
net.ipv4.tcp_wmem = 262144 262144 262144
net.ipv4.tcp_rmem = 4194304 4194304 4194304
Once the file is saved check the configuration by using sysctl -p
To check the semaphore configuration
[root@fah ~]# ipcs -ls
------ Semaphore Limits --------
max number of arrays = 142
max semaphores per array = 250
max semaphores system wide = 32000
max ops per semop call = 100
semaphore max value = 32767
To check the shared memory configuration
[root@fahtestdb ~]# ipcs -lm
------ Shared Memory Limits --------
max number of segments = 4096
max seg size (kbytes) = 85983232
max total shared memory (kbytes) = 17179869184
min seg size (bytes) = 1
Legends
kernel.core_uses_pid If the parameter's the value 0, then a core dump file is simply named as core. If it is nonzero value, then the core dump file includes the process ID while naming the core file like core.PID
kernel.msgmni :This Parameter is used for system-wide limit on the number of message queue identifiers
kernel.msgmax :This parameter defines a system-wide limit specifying the maximum number of bytes in a single message written on a System V message queue
kernel.msgmnb :This parameter defines a system-wide parameter used to initialize the msg_qbytes setting for subsequently created message queues. The msg_qbytes setting specifies the maximum number of bytes that may be written to the message queue.
kernel.sem : This parameter contains 4 numbers defining limits for System IPC semaphores
[1]SEMMSL The maximum semaphores per semaphore set
[2]SEMMNS A system-wide limit on the number of semaphores in all semaphore sets
[3]SEMOPM The maximum number of operations that may be specified in a call.
[4]SEMMNI A system-wide limit on the maximum number of semaphore identifiers
kernel.shmmni This parameter defines the number of shared memory segment identifiers in the system
kernel.shmall This parameter specifies the total amount of shared memory[pages] that the system can use at one time
kernel.shmmax we need to specify the value of 1/2 of physical RAM
kernel.sysrq This parameter controls the functions allowed to be invoked by the SysRq Ke if the value is 1 meaning that every possible with SysRq
INSTALLING ORACLE DATABASE BINARY'S FOR FUSION APPLICATION'S DB
Download the Fusion applications binaries from the edelivery.oracle.com and unzip in to the directory
[root@fah ~]# cd /unziped_directory/installers/database/Disk1
Step 1
Run the install to start the gui of the database installer
Step 2
Provide the details MOS or Skip this step
Step 3
Select to install the database software only later we will create the database and configure
Step 5
In this process we had used the single instance so select the single instance to proceed the installation
Step 6
Select the necessary language
Step 7
Click the select options and Select the five components [mandatory] [this five components selection is mandatory if you are missing nay of this components then you will get error's in fusion applications provsioning
Step 8
Specify the ORACLE_BASE location and the ORACLE_HOME location
Step 9
Specify the user group according to o/s user which had been create earlier
Step 10
start the installation of binay's
Step 11
Run the root.sh script for the root user 
Step 12
CREATING DATABASE FOR FUSION APPLICATIONS
Step 1
INIT PARAMETER'S FOR THE FUSION APPLICATIONS TRANSITIONAL DATABASE
[1]AQ_TM_PROCESSES
Purpose: enables time monitoring of queue messages. The times can be used in messages that specify delay and expiration properties. Values from 1 to 10 specify the number of queue monitor processes created to monitor the messages. If AQ_TM_PROCESSES is not specified or is set to 0, then the queue monitor is not created.
Recommended value [aq_tm_processes=10]
[2]AUDIT_TRAIL
Purpose enables or disables database auditing. [we need to disable the audit in the fadb]
Recommended Value audit_trail='NONE'
[3]PGA_AGGREGATE_TARGET
Purpose specifies the target aggregate PGA memory available to all server processes attached to the instance Default value will be 10 MB or 20% of the size of the SGA, whichever is greater
Recommend value pga_aggregate_target=8589934592 [9GB] it can be from [4 GB] to [9 GB] according to your environment
[4]SGA_TARGET
Purpose specifies the total size of all SGA components. If SGA_TARGET is specified, then the components of the SGA is automatically resized :
Recommended Value sga_target=19327352832 [it can be from 9 GB to 18 GB according to the environment ]
[5]DB_FILES
Purpose specifies the maximum number of database files that can be opened for this database
Recommended Value db_files=1024
[6]DB_RECOVERY_FILE_DEST_SIZE
Purpose specifies (in bytes) the hard limit on the total space to be used by target database recovery files created in the flash recovery area
Recommended Value db_recovery_file_dest_size=44040192000 [here we have used 40GB we can specify according to you env ]
[7]DISK_ASYNCH_IO
Purpose controls whether I/O to datafiles, control files, and logfiles is asynchronous (that is, whether parallel server processes can overlap I/O requests with CPU processing during table scans)
Recommended Value disk_asynch_io = FALSE
[8]FAST_START_MTTR_TARGET
Purpose enables you to specify the number of seconds the database takes to perform crash recovery of a single instance
Recommended Value fast_start_mttr_target=3600
[9] FILESYSTEMIO_OPTIONS
Purpose used for the purpose of enable or disable asynchronous I/O or direct I/O on file system files. This parameter is platform-specific and has a default value that is best for a particular platform. It can be dynamically changed to update the default setting.
FILESYTEMIO_OPTIONS can be set to one of the following values:
ASYNCH: enable asynchronous I/O on file system files, which has no timing requirement for transmission.
DIRECTIO: enable direct I/O on file system files, which bypasses the buffer cache.
SETALL: enable both asynchronous and direct I/O on file system files.
NONE: disable both asynchronous and direct I/O on file system files
Recommended Value filesystemio_options='Setall'
[10]JOB_QUEUE_PROCESSES
Purpose specifies the maximum number of processes that can be created for the execution of jobs
Recommended value job_queue_processes=100 [min 10 to max according to your env]
[11]LOG_CHECKPOINTS_TO_ALERT
Purpose writes the checkpoint accordance in the alert log file
. Doing so is useful for determining whether checkpoints are occurring at the desired frequency
Recommended value log_checkpoints_to_alert=TRUE
[12]NLS_SORT
Purpose we we are setting the NLS_SORT rather than BINARY causes a sort to use a full table scan, regardless of the path chosen by the optimizer. BINARY is the exception because indexes are built according to a binary order of keys. Thus the optimizer can use an index to satisfy the ORDER BY clause when NLS_SORT is set to BINARY. If NLS_SORT is set to any linguistic sort, the optimizer must include a full table scan and a full sort in the execution plan Nls_sort is set to Binary for the improved performance of the ORDER BY quires
Recommended Value nls_sort='BINARY'
[13]OPEN_CURSORS
Purpose specifies the maximum number of open cursors (handles to private SQL areas) a session can have at once. You can use this parameter to prevent a session from opening an excessive number of cursors ..no of Cursors open is set to be 500 to 1000 according to you environment
Recommended Value open_cursors=1000
[14]PLSQL_CODE_TYPE
Purpose specifies the compilation mode for PL/SQL library units. .we need to set the value to the NATIVE PL/SQL library units (with the possible exception of top-level anonymous PL/SQL blocks) will be compiled to native (machine) code. Such modules will be executed natively without incurring any interpreter overhead
Recommended Value plsql_code_type='NATIVE'
[15]PROCESSES
Purpose Sets the maximum number of operating system processes that can be connected to Oracle concurrently. The value of this parameter must account for Oracle background processes. SESSIONS parameter is deduced from this value
Recommended Value processes=5000
[16]SESSION_CACHED_CURSORS
Purpose specifies the number of session cursors to cache. Repeated parse calls of the same SQL statement cause the session cursor for that statement to be moved into the session cursor cache. Subsequent parse calls will find the cursor in the cache and do not need to reopen the cursor. Oracle uses a least recently used algorithm to remove entries in the session cursor cache to make room for new entries when needed
Recommended Value session_cached_cursors=1000
[17]TRACE_ENABLED
Purpose it is used to controls tracing of the execution history, or code path, of Oracle
Recommended Value trace_enabled=FALSE
[18]TWO HIDDEN PARAMETERS SHOULD BE SPECIFIED FOR THE RELEASE 5 INSTILLATION
[I] Recommended Value b_tree_bitmap_plans=FALSE
[II] Recommended Value fix_control='5483301:OFF','6708183:ON'
Set the Dispatches to the null
[iii] Recommended Value dispatchers=''
[iv] shared_servers=0
This are the recommended parameter values for the transitional database for the large database setting and you can go through the installation guide for the more details on this parameter's http://docs.oracle.com/cd/E15586_01/fusionapps.1111/e16600/provdbinstall.htm#CIHIAACB
Step 2
Configuring the database using the DBCA
start the from the terminal ./dbca
Step 1Select the Create Database for creating the new database
Step 2
Select the Custom database to Proceed Further
Step 3
Specify the database specify the global database name with the fully qualified value
databasename.domainname
Step 4
Create the Listener if you want to configure the EM or proceed with the next step
Step 5
Use the common Password or specif for all the username which is mentioned [SYS,SYSTEM]
Step 6
provide the fast recover area size here we have provided above 40 GB
Step 7
Step 8
Specify the memory management sizes and the necessary initialization parameter values in this step
we need to select the AL32UTF8 and UTF8 character sets while specifying the character set
Step 9
Add another member to the redo log group and increase the size of of the redo log file to 2 GB and create 3 group's
Step 10
Increase the tablespace size for the below tablespace's
SYSTEM 10GB
SYSAUX 6GB
TEMP 10GB
UNDO 12GB with auto extend on
Step 11
Once the database is installed Successfully apply all the necessary patches for the fusion applications installation
Step 3
Parch the database with the necessary patches according to the release nodes of your version of fusion applications here we have specified the patches for the release 5 of fusion applications
Navigate to the staging directory of the fusion applications and navigate to installers--->database---->patches and you can identify all the related patches ..apply all the patches and do the post installation steps successfully
Totally there will be a 29 patches applied to the database verify the release notes for the additional patches
10263668 12772404 12985184 13365700 13503598 13787482 14029429 14574590
12312133 12880299 13014128 13382280 13508115 13790109 14058884
12358083 12889054 13073340 13404129 13714926 13983131 14110275
12672969 12977501 13257247 13454210 13775960 14019600 14143796
[orafadb@fah patch]$ /u03/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch lsinv -patch_id
Invoking OPatch 11.2.0.1.7
Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation. All rights reserved.
Oracle Home : /u03/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u03/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.7
OUI version : 11.2.0.3.0
Log file location : /u03/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2013-01-22_14-15-43PM.log
Lsinventory Output file location : /u03/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2013-01-22_14-15-43PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.3.0
There are 1 products installed in this Oracle Home.
Interim patches (29) :
;;;;/
check all the 29 patches are applied
Step 4
Navigate to the staging directory and the find the apps_rcu
/<staging dir>/installers/apps_rcu/linux
Find the rcuHome_fusionapps_linux.zip and unzip the file in the apps_rcu directory
Navigate to the
/staging_dir/installers/apps_rcu/rcu/integration/fusionapps/export_fusionapps_dbinstall.zip
mkdir /tmp/rcu
cp export_fusionapps_dbinstall.zip /tmp/rcu
Navigate to the
</Staging_dir>/installers/apps_rcu/rcu/integration/biapps/schema/
cp otbi.dmp /tmp/rcu
Step 1
Navigate to the apps_rcu/bin
Step 2
select the create to create the RCU
Step 3
Specify the Hostname : <host name of the database server>
Port : <port used for the database>
Service Name : <fully qualified host name>
username : <sys>
Password : <password for the sys>
Role : SYSDBA
Step 4
Step 5
Provide the password for all the Schema
Step 6
[1] directory for the database machine where Fusion App... /tmp/rcu
[2]APPLCP_FILE_DIR /u03/app/oracle/diag[create this directory ]
[3]APPLLOG_DIR /u03/app/oracle/diag
[4]OBEE backup directory /tmp/rcu
[5]KEYFLEXCOMBFILTER directory /tmp/rcu
[6]advance compression option NO
[7]Maser repository ID Default value [501]
[8] Supervisor Password provide the password
[10]Work Repository D
[11]Work repository ID Default Value [501]
[12]Work Repository Name Default Value
[13]Work Repository Password Provide the Password
[14]Oracle Transactional BI /tmp/rcu
[15]Activity Graph and Analytics Y
Step 7
Click next to proceed for the next step
Step 8
Step 9
Once the RCU completed go to the next post for Creating the IDM database and the RCU's
