Install Identity Management Database

Install Identity Management Database

Installing Oracle Fusion Applications > Setting up Identity and Access Management Node > Install Oracle 11g Database (Identity management Database)

Previous: Install Fusion Applications Provisioning Framework on IDM Host

Fusion applications 11.1.8 also ships with Oracle 11g (11.2.0.3.0) database. Can either install it separately (if you want to install RAC database) or use Fusion provisioning Wizard to create one .

Important Note: In the Future Identity Management Provisioning Wizard would have the separate option to install the identity Management database but Si NCE currently that option was unavailable in IDM Wizard, we'll use the the The Fusion Provisioning Wizard only to create this Database.

To install applications transactional Database We need to run Oracle Fusion applications Provisioning Wizard from <fram Ework_location>/provisioning/bin

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

[Email protected] ~]$ cd/app/fusion/provisioning/bin/

We need to temporarily set Java_home to Jdk6 directory shipped with the installation media

[Email protected] bin]$ export JAVA_HOME=/STAGE/JDK6

[Email protected] bin]$./provisioningwizard.sh

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: 1531 (we have changed the default port to avoid, port conflict if you want to move it in future to another D Atabase host)

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

Oracle Base: /app/database

Software Location:will be populated automatically

OSDBA Group: dba

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

Password: Oracle123 (We have used Oracle123 for any passwords during the installation since it satisfies all requ Irements during this installation. Can keep any complex password you want)

You might see some warning related to memory if your is using less than-GB memory for this host. You can ignore this since we is going to reduce the memory target after installation.

Click Next

Once Prerequisites Check is successful, click Next. Save Summary if required

Once installation completes (20% progress), it'll prompt as follows.

Open another window and run the following script as root user.

[Email protected] ~]#/app/database/product/11.2.0/dbhome_1/root.sh

Check/app/database/product/11.2.0/dbhome_1/install/root_idmhost.paramlabs.com_2013-11-01_18-46-02.log for the Output of root script

[Email protected] ~]# more/app/database/product/11.2.0/dbhome_1/install/root_idmhost.paramlabs.com_2013-11-01_ 18-46-02.log

Performing root user operation for Oracle 11g

The following environment variables is set as:

Oracle_owner= Fusion

Oracle_home=/app/database/product/11.2.0/dbhome_1

Creating/etc/oratab file ...

Entries'll 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 would be performed.

Finished product-specific root actions.

Click OK

Once installation till validation is complete, click Next

Click Close to complete the installation

Let us install the JDK6 as well, the we can set Java_home to the permanent location.

[Email protected] ~]$ cd/app/fusion/

[Email protected] fusion]$ Unzip/stage/installers/jdk/jdk6.zip

Append in. Bash_profile of fusion User

Oracle_home=/app/database/product/11.2.0/dbhome_1

Export Oracle_home

Path= $PATH: $ORACLE _home/bin

Export PATH

Oracle_sid=idmdb

Export Oracle_sid

Java_home=/app/fusion/jdk6

Export Java_home

Ant_home=/app/fusion/provisioning/ant

Export Ant_home

Reduce Memory size of database

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

Important Note: We is reducing the SGA and PGA (from 10GB to 2GB). We is doing this since we is running on lesser RAM than required. This isn't recommended for production installation but since it's only a demo/development installation, can safely Do this. If you wish to keep it 10GB your can do it it's but this would increase the swap usage exponentially.

[Email protected] bin]$ Sqlplus/as SYSDBA

Sql> Show Parameter PGA

NAME TYPE VALUE

———————————— ———– ——————————

Pga_aggregate_target Big Integer 4G

Sql> Show Parameter SGA

NAME TYPE VALUE

———————————— ———– ——————————

LOCK_SGA Boolean FALSE

PRE_PAGE_SGA Boolean FALSE

Sga_max_size Big Integer 9G

Sga_target Big Integer 9G

Sql> create Pfile from SPFile;

File created.

Sql> shut immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

[Email protected] ~]$ cd/app/database/product/11.2.0/dbhome_1/dbs/

[Email protected] dbs]$ CP-PR Initidmdb.ora Initidmdb.ora.bak

[Email protected] dbs]$ VI Initidmdb.ora

Edit the values as follows and add last line as Memory_target

#idmdb. __db_cache_size=7482638336

#idmdb. __java_pool_size=67108864

#idmdb. __large_pool_size=33554432

Idmdb.__oracle_base= '/app/database ' #ORACLE_BASE set from environment

#idmdb. __pga_aggregate_target=4294967296

#idmdb. __sga_target=9663676416

#idmdb. __shared_io_pool_size=536870912

#idmdb. __shared_pool_size=1442840576

#idmdb. __streams_pool_size=33554432

#*.pga_aggregate_target=4294967296

#*.sga_target=9663676416

*.memory_target=3g

Let's recreate spfile using this pfile.

Sql> create SPFile from Pfile;

File created.

Sql> Startup

Also change the value of open_cursors parameter to 800

Sql> Show Parameter Open_cursors

NAME TYPE VALUE

———————————— ———– ——————————

Open_cursors Integer 500

Sql> alter system set open_cursors=800 scope=both sid= ' * ';

System altered.

Sql> Show Parameter Open_cursors

NAME TYPE VALUE

———————————— ———– ——————————

Open_cursors Integer 800

Install Identity Management Database