Installing the IBM Security Identity Governance and Intelligence database on the Oracle server

These are the steps to install a new IBM® Security Identity Governance and Intelligence database on the Oracle server.

1. Configure the tnsnames.ora file.
   1. Log in with root privileges.

      sudo su -

   2. Switch to the oracle user.

      sudo su oracle

   3. Set the env variables:

      . /usr/bin/oraenv

   4. Start listener.

      lsnrctl start

   5. Start the database.
   6. Browse to the tnsnames.ora file.
      For example, oracle_home/db/network/admin
   7. Open the file in a text editor.
      For example, vi
   8. If the network instance is not configured correctly, add the following section:

      <IdeasSID> =
        (DESCRIPTION =
          (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = <DBserver>)(PORT = <DBport>))
          )
          (CONNECT_DATA =
            (SERVICE_NAME = <IdeasSID>)
          )
        )

   9. Verify that the configuration is working by connecting to the database with the following command:

      sqlplus system/<password>@<IdeasSID>

      The <password> is the administrative password that was supplied when the Oracle database was created.

2. Follow these steps to download the Identity Governance and Intelligence database installation files:
   1. Find in the product package image or DVD in Passport Advantage the zip file that corresponds to the IBM Security Identity Governance v5.2.6.x Database Installation Scripts and Tools eAssembly. Copy the file to your database server and unpack it.
      The DB_Tools directory is unpacked.
   2. In the DB_Tools directory, find and unpack file SEC_IDNTY_GVN_INTL_xxx_V5.2.6.x_DT_IN_.zip (where xxx can be CMP, ANL, LFC, or IEE, depending on the license under which you are using the product, and x corresponds to the fix pack number).
      Amongst the unzipped files, you find the db2 directory.
   3. Change path to the oracle directory and unpack file oracle_installation.zip.
3. On Unix or Linux, run the chmod -R 777 * command.
4. Install the Identity Governance and Intelligence database on the Oracle server. Follow these steps:
   1. Find file oracle_install.bat (Windows) or oracle_install.sh (Unix or Linux) amongst the files that were unpacked when you unzipped file oracle_installation.zip.
      This file first installs the Identity Governance and Intelligence Version 5.2.6 database, and then upgrades it to any fix pack of this version that might have been released.
   2. Open the file with a text editor and type values in the following statements, replacing the brackets and the text within after the equal sign (=)

      set (export) IGI_DB	The name of the oracle instance that is the database name. For example, IGI526
      set (export) TABLESPACE_PATH	The location of the Identity Governance and Intelligence database. For example, '/home/orainst1/orainst1/IGI_DB'
      set (export) TABLESPACE_SIZE	The initial size of the files that contain the Identity Governance and Intelligence table spaces (small=2GB, medium=4GB, or large=8GB). Any character other than S, M, or L defaults to M.
      set (export) TABLESPACE_MAXSIZE	The maximum size that can be reached by the files that contain the Identity Governance and Intelligence permanent table spaces. The default and minimum size is 8 GB.
      set (export) TABLESPACE_TEMP_MAXSIZE	The maximum size that can be reached by the files that contain the Identity Governance and Intelligence temporary table spaces. The default and minimum size is 2 GB.
      set (export) INSTOWNER_USER	The Oracle database instance owner of the Identity Governance and Intelligence database instance
      set (export) INSTOWNER_PWD	The password of the instance owner
      set (export) ORACLE_BASE	The root of the Oracle Database directory tree. For example, c:\oracle\121 or /home/oracle

   3. Save the file
   4. On Unix or Linux, run dos2unix oracle_install.sh.
   5. Run oracle_install.bat or oracle_install.sh to install the Identity Governance and Intelligence on the Oracle server.
      The process creates two log files, one for the installation of the Version 5.2.6 database, and one for the upgrade of the database to any fix pack to the same version that might have been released. You can retrieve the log files in the following locations:

      • Installation step

        UNIX or Linux systems

        ../DB_INSTALLATION/

        Windows systems

        ..\DB_INSTALLATION\

      • Upgrade step

        UNIX or Linux systems

        ../upgrade_fixpack/

        Windows systems

        ..\upgrade_fixpack\