Articles on Emerging Technologies, Cloud Computing and Cyber Security

Thursday, December 27, 2018

Oracle Fusion Applications 11.1.2.9 Installation Part 4

 Oracle Fusion Applications 11.1.2.9 Installation Part 4 Installing Database for Oracle Identity Management and Oracle Fusion Applications Transaction Database

When determining your database configuration, consider the required instances, the required patching, listener configurations, schema and password requirements, and RCU directories.

Note:
Two databases are recommended for Oracle Internet Directory and Oracle Access Manager/Oracle Identity Manager because they are likely to have different configuration requirements. If desired, they can be combined into a single database.
Download p13390677_112040_Linux-x86-64_1of7.zip and unzip
Login to host dbnode01 with orafa user
cd /u02/ofa_soft/11.2.4.0/database
./runInstaller
Proceed with the installation of your choice. 
There are no additional patchsets required for 11.2.0.4 database. Hence continue with below configuration

 4.1 Minimum Initialization Parameters for Oracle Identity Management Database

Parameter
Value
aq_tm_processes
1
dml_locks
200
job_queue_processes
10
open_cursors
1500
session_max_open_files
50
sessions
500
processes
2500
sga_target
512M
pga_aggregate_target
100M
sga_max_size
4G
session_cached_cursors
500





















4.2 Preparing the Oracle Identity Management Database for the Oracle Fusion Middleware RCU

Execute the following commands to create XATRANS Views:
cd $ORACLE_HOME/rdbms/admin
sqlplus / as sysdba
@xaview.sql

4.3 Running the Oracle Fusion Middleware RCU for Oracle Identity Management

The Oracle Fusion Middleware RCU needs to be set up for the following components: ODS, OIF, OIM, OAM. You must use FA as the prefix for the schema names.
You must select a single password for all the schema while running the Oracle Fusion Middleware RCU.
Unzip the Oracle Fusion Middleware RCU zip file
Linux: REPOSITORY_LOCATION/installers/fmw_rcu/linux/rcuHome.zip

Start the Oracle Fusion Middleware RCU by issuing this command:
cd /u02/ofa_soft/installers/fmw_rcu/
mkdir rcu
unzip ../linux/rcuHome.zip
cd bin
./rcu
On the Welcome screen, click Next.
On the Create Repository screen, select the Create operation to load component schemas into a database. Then click Next.
On the Database Connection Details screen, provide the information required to connect to an existing database. For example:
Database Type: Oracle Database
o    Host Name: Enter one of the Oracle RAC nodes. Enter the VIP address of one of the RAC database nodes or the database SCAN address, for example: DB-SCAN.mycompany.com
o    Port: The port number for the database listener (DB_LSNR_PORT). For example: 1521
o    Service Name: The service name of the database. For example OIDEDG.mycompany.com.
o    Username: sys
o    Password: The sys user password
o    Role: SYSDBA
Click Next.
On the Check Prerequisites screen, click OK after the prerequisites have been validated.
On the Select Components screen, provide the following values:
Create a New Prefix: Enter a prefix to be added to the database schemas, for example, enter FA.
Components: Select the schemas shown in the following table:
Product
Oracle Fusion Middleware RCU Option
Service Name
Comments
Oracle Internet Directory
Identity Management–Oracle Internet Directory
Oracle Fusion Applications Installation Workbook - Database tab ->
IDM DB -> Service name (if not using a separate OID DB)
OID DB -> Service Name (if using a separate OID DB)

Oracle Access Manager
Identity Management–Oracle Access Manager
Oracle Fusion Applications Installation Workbook - Database tab -> IDMDB -> Service name
Audit Services will also be selected.
Oracle Identity Manager
Identity Management–Oracle Identity Manager
Oracle Fusion Applications Installation Workbook - Database tab -> IDMDB -> Service name
Metadata Services, SOA infrastructure, and User Messaging will also be selected.
Oracle Identity Federation
Identity Management–Oracle Identity Federation
Oracle Fusion Applications Installation Workbook - Database tab -> IDMDB -> Service name

Click Next.
On the Check Prerequisites screen, click OK after the prerequisites have been validated.
 On the Schema Passwords screen, enter the passwords for the schemas. You can choose to use           either the same password for all the schemas or different passwords for each of the schemas.       Oracle recommends choosing different passwords for different schema's to enhance security
   Click Next.
On the Map Tablespaces screen, accept the defaults and click Next.
On the confirmation screen, click OK to allow the creation of the tablespaces.
On the Creating tablespaces screen, click OK to acknowledge creation of the tablespaces.
On the Summary screen, the summary and verify that the details provided are accurate. Click Create to start the schema creation process.
On the Completion summary screen, verify that the schemas were created.
Click Close to exit.

4.4 Minimum Initialization Parameters for Oracle Fusion Applications Database

Parameter
DB Default Value
Recommended Value for Oracle Fusion Applications
audit_trail
DB
NONE
plsql_code_type
INTERPRETED
NATIVE
nls_sort
Derived from NLS_LANGUAGE
BINARY
_b_tree_bitmap_plans
(Hidden Parameter. Use below command to change the value
ALTER SYSTEM SET "_b_tree_bitmap_plans"=false SCOPE=SPFILE;)
TRUE
FALSE
db_securefile
PERMITTED
ALWAYS
_ACTIVE_SESSION_LEGACY_BEHAVIOR
FALSE
TRUE                       
_fix_control 
(alter system set "_fix_control"= '5483301:OFF', '6708183:ON' scope=spfile;)
5483301:ON,6708183:OFF
5483301:OFF,6708183:ON


Increase Redo Log Group 
At-least three 2 GB

























4.5 Running the Oracle Fusion Middleware RCU for Oracle Fusion Applications

Create directories in the file system accessible by the database which will be referenced by the DBA directories used by Oracle Fusion Applications. These directories are specified in the Oracle Fusion Applications Installation Workbook - Database tab -> FA transaction Database table and they are:
Linux: REPOSITORY_LOCATION/installers/apps_rcu/linux/rcuHome_fusionapps_linux.zip

4.6 Make dmp Files Available on the Database Server

  • Locate the file APPS_RCU_HOME/rcu/integration/fusionapps/export_fusionapps_dbinstall.zip.
  • Unzip export_fusionapps_dbinstall.zip to the directory you specified for FUSIONAPPS_DBINSTALL_DP_DIR.
  • Go to APPS_RCU_HOME/rcu/integration/biapps/schema and locate the otbi.dmp file.
  • Copy otbi.dmp to OTBI_DBINSTALL_DUMP_DIR.

4.7 Running the Oracle Fusion Applications Repository Creation Utility using the Wizard

Start the Oracle Fusion Middleware RCU by issuing this command:
cd /u02/ofa_soft/installers/apps_rcu/
mkdir rcu
unzip ../linux/rcuHome_fusionapps_linux.zip
cd bin
./rcu
No action is necessary on this read-only screen. Click Skip this Page Next Time if you do not want to see it the next time you log in to the Oracle Fusion Applications RCU.
Click Next to continue.
Select Create to create and load component schemas into the database 
Click Next to continue.
Specify the database connection details. 
Click Next to continue.
Click OK
The Oracle Fusion Applications RCU retrieves the names of the Oracle Fusion Middleware and the Oracle Fusion Applications components. You cannot change the schema owner names. By default, all components are checked so that they are included in the prerequisite check process. 
Click Next to begin the process.
Click OK prerequisite check process
Specify the passwords for main and additional (auxiliary) schemas. Passwords must have a minimum length of eight characters and contain alphabetic characters combined with numbers or special characters.
  • Use same passwords for all schemas: Specify a single password for both schemas. Retype to Confirm.
  • Use main schema passwords for auxiliary schemas: Specify a different password to use for each main schema and for the associated auxiliary schema. Only the main schemas are visible. Retype the password to Confirm.
  • Specify different passwords for all schemas: Specify a unique password for each main schema and its auxiliary schema. All schemas are visible. Retype to Confirm.
Note the passwords you enter. You must supply them when you create a response file.
Click Next to continue.
Each Oracle Database directory object has a value represented by a physical directory on the database server. Custom variables are pre-defined, platform-specific directory objects that the Oracle Fusion Applications RCU creates. In the Value column, you specify a pre-existing physical directory (located on the database server) for each custom variable. 
Click Next to continue.
If you want to start the tablespace create process without making any changes, click Next on this screen. 
Click OK to create the tablespaces. 
Click OK when the operation is complete.
Review the information and click Create. While the schemas are being created, the utility displays the Repository Creation Utility – Create screen, showing the creation progress.
The Logfile column lists log file names.
If errors are encountered during the Create operation, or if a Create operation fails for any component, the Cleanup for failed components checkbox appears on this page and is selected by default. If the checkbox is selected, the Oracle Fusion Applications RCU will perform cleanup operations for the components that failed. 
Click Close to dismiss the screen.


0 Comments: