Introduction

EBS SSO infrastructure consists a range of Oracle product components. They are Oracle Database, Oracle Internet Directory (OID), Oracle Directory Integration Platform (DIP), Oracle Weblogic Application Server (WLS) and Oracle AccessGate (OAG).

In order to install the Oracle Oracle Internet (OID) Directory service, which serves as the backbone of the Oracle EBS Single Sign On infrastructure, we must first install the Oracle Database, which is used by OID extensively to store all the necessary information.

In this white paper, we will show how to install a basic version of the Oracle Database on a Linux 6.X server. The database is installed as a standalone service, there is no HA configuration involved in this installation.

Database Installation

The database installation consists of 3 main processes.

  1. Prepare the Server Environment

  2. Install the Product

  3. Validate the installation

Prepare the Server Environment

Here are the DB version and Server requirement for this installation Server OS: Oracle Linux 6.8 UEK4 Server Memory: 4G Server DiskSpace: 60G Server CPU Core: 4 DB Version: 12.1.0.2

  1. To install all required packages, for the Oracle Datebase Enviornment, Run:
yum install oracle-rdbms-server-12cR1-preinstall
  1. To install xTerm for display, Run:
yum install xterm

Install the Product

  1. To install the Oracle Database, Navigate to the production installation directory and Run:
./runInstaller
  1. Unselect the Update Checkbox below.
  1. Select the Create and Configure button.
  1. Select the Desktop Class button.

Figure 4 below shows the Character set is selected as Unicode, container db checkbox is not checked. The reason being if we choose the default char set (Non Unicode), the Oracle RCU will not create schema with it. If we choose the the container Db option, OID will not install against it because it needs a stand alone Database, not a container DB.

The Oracle Inventory contains the metadata of the Oracle products installed on this server. Please feel free to view the content of inventory.xml file in this directory for detailed products installed.

  1. Execute root.sh as root. This will assign the proper directory access for the rest of the installation.
  1. After the Database Configuration Assistant creates the database, Navigate to https://localhost:5500/em as a SYS user to manage the database using Enterprise Manager Database Express.

  2. Click Password Management to Unlock Accounts. Then, Click OK to continue.

  1. Click close to Complete the installation.

Validate the installation

Once the Database installation is successfully completed, validate the environment with the following commands.

  1. Run sql command, this will log into the Database as the sysadmin account.
sqlplus / as sysdba to issue a startup command
  1. Run sql command, this will display the current Database Meta information. (ie: instance name, version, status)
select instance_name, version, status, con_id from v$instance;
  1. Run command lsnrctl, this shows the Database listener status. We can also use this command to start/stop the listener.
lsnrctl status
lsnrctl start
lsnrctl stop