Step - 1 Installation and Configuration of Oracle Database 12c for OIG - OAM

Oracle database 12c 

This blog is to install and configure Oracle Database 12c for OIG(OIM12c) and OAM 12c. This is part of bigger series.  Please check Parent Series here.

This blog is part of bigger series.  I have divided OIM-OAM installation in 5 posts.  It is 1st post of this series. 

Below are the steps 

1.Installation and Configuration of Oracle Database 12c for OIG - OAM

2.  Download binaries, install JDK, setup env variables and run quick installer for WebLogic-SOA-OIM-OAM infra

3. Run RCU and Create domain.

4. Post installation configurations

5. Start Services and issue faced

This blog has 4 sections:-

A. Installation

B. Configuration

C. Start, Stop and environment variables

D. Test connection via Sqldeveloper

A. Installation

1. Download Oracle Database 12c. For this POC  I have downloaded Oracle DB 12.2.1. I recommend to use same version of binaries if you are setting this environment for POC. It would over any software or version specific issue and same setup is tested by time. 

You may download Oracle Database 12C (12.2.0.1.0)  from below link https://www.oracle.com/database/technologies/oracle-database-software-downloads.html

In case Oracle has removed 12c setup as it has released other versions above this, you may check links of old versions from footer.

For windows it would be single file of 2.8 GB, name would be like V839963-01.zip

2. Unzip the zip and go to folder(default name is Database).

3.  right click on Setup and run as administrator.  Make sure you run all binaries with admin rights else you may get permission issues.

4.  Welcome screen, uncheck I want to receive security updates else provide email address(prefer uncheck), it will show warning if you uncheck box, ignore that

5. Select Install Database Software only - We will do configuration manually.  

6. Select Single instance database installation

7. Select Enterprise Edition else our OIM would not work

8.  Oracle Home user - you may use Virtual account, your windows login or Virtual account, I did it via Virtual account and it will also not a issue.

9. Installation location - Change it from C to other directory where you have 100 gb space available. 

10. Summary - Click Next

11. Finish and close

B. Configuration

1. Go to Oracle database home (Location of same we selected in step 9 above), got to bin directory of same and run dbca as adminstrator

2. Select create a database

3. Advance Configuration

4.  Database Type- Oracle Single Instance database and General purpose or Transaction Processing

5. Global database name and SID  - Better give same string in both the fields.

6. Use template file for database storage attributes

7. Choose the recovery options for the database - select Specify Fast Recovery Area and keep the default.

8. Create  a new Listener - Give any name, service related the same would be available in window services.

9. Data Vault Option - Keep default and click next

10. Configuration Options - for OIM we need to change some DB parameters, We will change processes value here, rest will do later in same configuration, here do following 

processes with 500 and more

Unicode - AL32UTF8

11. Management Options - Uncheck EM server as we will use it for OIM-OAM.

12. Select Password - Better select simple password like Password1 and use it in all the places as if it is just for POC, this password would work in all out setup and you will not face forgot password related issue later.

13. Click on All initialization Parameters

Session Cache cursors- 100

Open cursors - 800

Db files - 600

14. Summary

15. Progress Page

16. Finish

C. Start, Stop and environment variables

To start and stop services, Oracle_HOME, ORACLE_SID and PATh need to set, so one way is via environment variable but my suggestion is do via export/set option as same machine is being used for other oracle components so setting environment  variable level may create issue later. Prepare your strings as

set ORACLE_HOME="<path of dbhome_1 defined in step 9 of installation>"

set ORACLE_SID=<SID>

set PATH=%ORACLE_HOME%\bin;%PATH%

Oracle DB and listener services are available in window services -> Run as administrator

Here services are OracleService<SID> and OracleOraDB12Home1Listner<listnerName> as below, start them if want to start database. Better changes these services manually so it start only when we need them.

Once services are started. open cmd as administrator. 

Set variables mentioned above and connect to database as

>sqlplus

username:- sys as sysdba

Password:- XXXX

Once connected you may stop database via shutdown command and start via startup command.

D. Test connection via Sqldeveloper

This is optional step, you may verify if your database and listner working fine,  you may install client like sqldeveloper. 

Download it from - select Windows 64-bit with JDK 8 included

https://www.oracle.com/tools/downloads/sqldev-downloads.html

It will be 423 MB file, unzip it and run sqldeveloper exe as administrator

Once installed you may add connection of your database and do test as I did, Make sure you get success response, in case get any other response, restart services as mentioned in above stage.

That is from this post. Please comment if you have any query, click herefor next step.