Oracle by Example brandingCreating a Database for Oracle Identity Governance 12c

section 0Before You Begin

This tutorial shows you how to create an Oracle Database instance for use with Oracle Identity Governance 12c. This tutorial takes approximately 15 minutes to complete.

This tutorial is part of the series Getting Started with Oracle Identity Governance 12c. Read them sequentially.

Background

As part of the Oracle Identity Governance 12c installation, the Repository Creation Utility creates the necessary schema to store the metadata. A database instance needs to be created for this using the Database Creation Assistant.

What Do You Need?

  • An environment with:
    • At least 16 GB of physical memory
    • Oracle Enterprise Linux 6.6 or later with access to the Internet
    • Super-user (root) credentials
    • Oracle Database 12c Release 2 software installed
  •  A basic understanding of Linux

section 1Create a Database

After installing the Oracle Database software in Node 1(host01.example.com), you must run the Database Configuration Assistant (dbca) utility to create a database.

  1. Launch a terminal window as oracle and run the following command:
    $ cd /u01/app/oracle/product/12.2.0/dbhome_1/bin
    $ ./dbca
  2. Follow the table below to guide you through the installation screens:
    Step Window Description Choices or Values
    1 Database Operation
    		 Create a database
    2 Creation Mode
    		 Advanced configuration
    3 Deployment Type
    		 General Purpose or Transaction Processing
    4 Database Identification Global database name: orcl.example.com
    SID: orcl

    De-select Create as Container database
    5 Storage Option Use template file for database storage attributes
    6 Fast Recovery Option Click Next
    7 Network Configuration Click Next
    8 Data Vault Option Click Next
    9 Configuration Options Select Character Sets tab
    Select Use Unicode (AL32UTF8)
    10 Management Options De-select Configure Enterprise Manager (EM) database express
    11 User Credentials Use the same administrative password for all accounts
    Password: Welcome1
    Confirm Password: Welcome1
    12 Creation Option Click Create Database

    Click All initialization Parameters
    Click Show advanced parameters

    Click in the Value field and update the corresponding values:
    db_files: 600
    open_cursors: 800
    processes: 500
    session_cached_cursors: 100

    (These parameters are set as per the Oracle® Fusion Middleware System Requirements and Specifications 12c)

    Click Close and Next
    13 Summary Click Finish.
    The Progress page will display
    14 Finish Click Close

section 2Perform Post-Configuration Tasks

To configure the environment variables, perform the following tasks:

  1. Launch a terminal window as oracle and enter the command:
    $ vi $HOME/.bash_profile
  2. Enter the following variables and save the .bash_profile:
    export ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1
    export ORACLE_SID=orcl
    export PATH=$ORACLE_HOME/bin:$PATH
  3. Repeat steps 1 and 2 to include the environment variables in the $HOME/.bashrc file and close the terminal.

section 3Test the Database

Perform the following steps to test the database installation:

  1. Launch a terminal window as oracle and enter the following commands to confirm the database variables are in place:
     
    $ echo $ORACLE_HOME
    $ echo $ORACLE_SID
    The terminal should display the following respectively:
    /u01/app/oracle/product/12.2.0/dbhome_1
    orcl
    Note: If terminal displays a blank line after you enter the environment variable, return to section Perform Post-Configuration Tasks to troubleshoot the environment variables configuration.
  2. In the terminal, enter the command which sqlplus to locate where the sqlplus utility is available:
    $ which sqlplus
/u01/app/oracle/product/12.2.0/dbhome_1/bin/sqlplus
  3. Execute the following command to check whether the database is running: 
    $ sqlplus / as sysdba; 
    SQL> select 1 from dual;
    SQLPlus returns 1. This signifies that the database is running.
  4. Enter the command exit to close SQLPlus.
  5. In the terminal window, enter the command tnsping localhost to test the database listener. If the command returns OK, it signifies that the database listener is running and is correctly configured.

section 4Stop the Database

Perform the following steps to stop the database and the listener:

  1. In a terminal window, enter the command lsnrctl stop to stop the database listener.
  2. In a terminal window, enter the command sqlplus / as sysdba; to start SQLPlus.
  3. At the SQLPlus prompt, enter the command shutdown immediate; to stop the database.
  4. Enter the command exit to close the SQLPlus.

section 5Start the Database

Perform the following steps to start the database and the listener:

  1. In a terminal window, enter the command sqlplus / as sysdba; to start SQLPlus.
  2. In SQLPlus prompt, enter the command startup; to start the database.
  3. Enter the command exit to close SQLPlus.
  4. In a terminal window, enter the command lsnrctl start to start the database listener.
  5. Optionally, perform the instructions in the section Testing the database to confirm that database and listener are running correctly.

next stepNext Tutorial

Installing Oracle Identity Governance 12c