Updating the Oracle database for Version 5.2.5

If IBM® Security Identity Governance and Intelligence is connected to an Oracle database, you must update the database by configuring it for the new version of Identity Governance and Intelligence.

1. Stop the Security Identity Governance and Intelligence server from the virtual appliance dashboard.
2. Configure the tnsnames.ora file.
   1. Browse to the tnsnames.ora file.
      For example,

      oracle_home/db/network/admin 

   2. Edit the file in a text editor such as vi or Notepad.
   3. If the network instance is not configured correctly, add the following section.

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

      Example 1

      XE =
        (DESCRIPTION =
          (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.0)(PORT = <1521>))
          )
          (CONNECT_DATA =
            (SERVICE_NAME = <XE>)
          )
        )

      Example 2

      MYDB =
        (DESCRIPTION =
          (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = <oracle_server_ip>)(PORT = <1521>))
          )
          (CONNECT_DATA =
            (SERVICE_NAME = <MyDB_service_name>)
          )
        )

3. On UNIX and Linux systems, change the file permissions in the installation directory.
   1. Use the following command to change directory to <UPDSCRIPTDIR>:

      cd <your_path>/<UPDSCRIPTDIR>

   2. Use the following command to ensure that the database user has write permission to access the log file output:

      chmod -R 777 *

4. Set the ORACLE_HOME variable in accordance with your specific Oracle client or server installation. All the next steps in the procedure assume that the sqlplus executable is located in the <ORACLE_HOME>/bin directory.
   Enter the following command to connect to the database and to check that the configuration works:

   • On UNIX/Linux:

     $ORACLE_HOME/bin/sqlplus system/<password>@<IgiSID>

   • On Windows:

     %ORACLE_HOME%\bin\sqlplus system/<password>@<IgiSID>

   If the connection test ended successfully, you can exit from the sqlplus with the following command:

   exit

5. Configure the oracle_update_xxx.sh or oracle_update_xxx.bat file.
   1. Locate the folder that contains the oracle_update_xxx file.

      cd <your_path>/<UPDSCRIPTDIR>/oracle/migration

   2. With a text editor, open the oracle_update_xxx file that matches your upgrade path as explained in section About this task.
   3. Modify the ORACLE_BASE and ORACLE_HOME variables according to your installation.

      These variables are necessary for sqlplus to work.

   4. Modify the ORACLE_SERVER variable with the value of IgiSID previously configured in the tnsnames.ora file.
   5. If you changed the default product password from ideas, update it in the SCHEMA_PWD variable.
6. Connect as the Oracle instance owner (for example, oracle), run the update script that you just edited, and record the results in the log file.
   For example, on UNIX and Linux systems:

   find . -name \*.sh -exec dos2unix {} \;
   ./oracle_update_from522.sh > upgrade.log

   On Windows systems:

   oracle_update_from522.bat > upgrade.log

   During the migration procedure, for some particular conditions, these diagnostic messages can be present in the log file.

   "NO FLOW <something> FOUND".

   and

   ERROR near line 10:
   SQL0438N  Application raised error or warning with diagnostic text: "DEFAULT PRIORITY UNDEFINED".

   These messages do not identify an error of the procedure and can be ignored.
7. If you upgrade to Fix Pack 1, among the directories that were unpacked from DBupdate.zip, find the ..\schemas\script\oracle\upgrade_fixpack\cumulative_patch.sql script and run it with the sqlplus command.
8. Start the Security Identity Governance and Intelligence server from the virtual appliance dashboard.