IBM® Security Identity Adapter for Oracle Database 7.1.24 - Release notes

IBM Security Identity Adapter for Oracle Database 7.1.24 is available. Compatibility, installation, and other getting-started issues are addressed.




Welcome to the IBM Security Identity Adapter for Oracle Database.

These Release Notes contain information for the following products that was not available when the IBM Security Identity Server manuals were printed:


Adapter Features and Purpose

The Oracle Database Adapter is designed to create and manage accounts on an Oracle Database. The adapter runs in "agentless" mode and communicates using JDBC to the systems being managed. IBM recommends the installation of this adapter (and the prerequisite IBM Security Directory Integrator, previously known as IBM Tivoli Directory Integrator) on each node of an IBM Security Identity Server WAS cluster. A single copy of the adapter can handle multiple IBM Security Identity Server Services. 

The deployment configuration is based, in part, on the topology of your network domain, but the primary factor is the planned structure of your IBM Security Identity Server Provisioning Policies and Approval Workflow process. Please refer to the IBM Knowledge Center for a discussion of these topics.

The IBM Security Identity adapters are powerful tools that require Administrator Level authority. Adapters operate much like a human system administrator, creating accounts, permissions and home directories. Operations requested from the IBM Security Identity server will fail if the adapter is not given sufficient authority to perform the requested task. IBM recommends that this adapter run with administrative (root) permissions.



Service Groups Management

IBM Security Identity Server has the ability to manage service groups. By service groups, IBM Security Identity Server is referring to any logical entity that can group accounts together on the managed resource.

Managing service groups implies the following:

     Create service groups on the managed resource.
      Modify attribute of a service group.
      Delete a service group.

Note: Service group name change is not supported.

The Oracle Database Adapter does not support management of service groups.


License Agreement

Review and agree to the terms of the IBM Security Identity Adapter license prior to using this product. The license can be viewed from the     

"license" folder included in the product package.


Contents of this Release

Adapter Version



Build Date

2017 December 06 05.45.35

Adapter Version


Component Versions

Adapter build:



Dispatcher 7.0.32 (packaged separately)


The following guides are available in the IBM Knowledge Center: 

  Oracle Database Adapter Installation and Configuration Guide

New Features

Enhancement # (FITS)



Items included in current release(7.1.24)

RTC 167831

US - As an Oracle DB adapter developer, I must support the latest Oracle 12.2 features



Items included in release(7.1.23)

RTC 151773

Add support for IGI 5.2.2

This adapter is now designed for use with IBM Security Identity Manager, Privileged Identity Manager, and Identity Governance and Intelligence.


Items included in release(7.0.22)

42054 (84786) 

ISIM v6.0 Oracle Database adapter support of Oracle 12c CDB databases

Usage instructions for Oracle 12c support



Items included in 7.0.21 release

39182 (77959)

Oracle Database account Provisioning in ISIM 6.0 (Default Profile)

Adapter will now assign the profile during user creation.



Items included in 7.0.20 release

71947 (36726)

Include an option to enable/disable the use of cascade when removing a oracle user

71039 (36376)

Oracle adapter jdbc:thin client should support Oracle network encryption


Items included in 7.0.19 release




Items included in 7.0.18 release



Closed Issues



PMR# / Description



Items closed in current release.(7.1.24)







Items closed in release.(7.1.23)

Bugz 2152/ 2202 RTC153511/ 153512


Connect credential / Search operation fails for Oracle 11G

Test connection and Reconciliation fail on 11g

Bugz 2194 RTC153513


Oracle profile does not contain RMI status attributes for service form



Missing value for conEmpty leads to NullPointerException on FP14



Items closed in release.(7.0.22)

Bugz 2041/ 2066
RTC 145427


Oracle adapter Tablespace quota not reconciled

ISPIM Oracle DB adapter not retrieving Tablespace quotas

Customizing tablespace quota Sizes



Items closed in 7.0.21 release


RTC 137359




Oracle DB Adapter - encryption issue.

The JDBC Thin Client Properties File, follows a standard format, the first line is always comment line or a blank newline , followed by each property set on new line;  comment line begins with #



Items closed in 7.0.20 release



Number of attributes completely failed and partially completed

In some cases of change operation, like adding a role which does not exist, the log may have inconsistent update of number of attributes completely failed and number of attributes partially completed. In this scenario, ISIM may show incorrect status code but ISIM LDAP is updated correctly.



Items closed in 7.0.19 release



Warning on eroraroles adds still causes ITIM Server LDAP to update.

RTC 123371


Stored procedures not installed/updated correctly by adapter

From this version of adapter, New store procedure will get installed and old stored procedures will get uninstalled from the database.


Note: - The adapter appends the adapter version to the name of the procedure when installing. While uninstalling the adapter will first check whether the isim versions of the new and old stored procedures are same and then will uninstall only those stored procedures whose version is lower than the version currently being installed.

Once you have installed store procedures on resource, you can remove store procedure of that version from timsol folder.



Items included in 7.0.18 release




Known Issues



PMR# / Description





Converting between Default and Non-default Roles

It is a two-step process to make a r@ole as a non-default role.

1.     Assign a role to a user by the "GRANT" statement.

2.     Assign the role as non-default by "ALTER USER".

If the "ALTER USER" command fails, then that role will become the default role on the resource. However it will not reflect on the IBM Security Identity Manager side in any of the role lists. You are required to submit the recon operation, so it will appear in the default list or you can submit the request again.

Error on SendOnly Attributes

If the Oracle adapter fails to set the send-only attribute "erOraExpirePwd" on the Oracle database resource for an ADD Operation, then the Oracle Database Adapter will return this attribute in the failed attribute list and the IBM Security Identity Manager will generate an "Object Class Violation" error. This is an IBM Security Identity Manager server defect and will be addressed in the next server fix pack.



Restoring Local Authenticated Accounts

Restoring an account for local authentication is a two-step process.

1.     Change the password for the user.

2.     Restore the account on the resource.

If the step 1 executes successfully and step 2 fails then the password is changed on the resource without the account being restored.

Workaround: the user remains suspended and the account can be restored with a new password.


Installation and Configuration Notes

See the IBM Security Identity Adapter Installation Guide for detailed instructions.



Configuration Notes

The following configuration notes apply to this release:


Corrections to Installation Guide

The following corrections to the Installation Guide apply to this release:

Usage instructions for Oracle 12c support

The Oracle DB adapter can be now used to manage Oracle12C container database. However the CDB and each PDB connected to it, should be managed separately through separate services from ISIM and IGI.

Adapter user account for managing Oracle 12C container database

·         CDB can be managed using common users.

·         PDB can be managed using local users only.

Add/Modify account operation


·         A root container service must create an account for which the name starts with C##. If it tries to create user without C## in username, error is thrown.

·         When common user is creating common user account, the DEFAULT TABLESPACE, TEMPORARY TABLESPACE, QUOTA and PROFILE must all reference objects that exist in all containers. So if the object does not exist in all containers, then it will throw an error.

·         To assign/grant a privilege to common user commonly we need to provide container value as CONTAINER=ALL.


·         A PDB container service must not create an account starting with C##. If it tries to create user with C## in username, error is thrown.

Reconciliation Operations


            We will be managing the common users thr CDB services.


We will be managing only local users thr PDB services.


Customizing TableSpace quota Sizes

Oracle DB adapter has removed the support for user defined tablespace quota sizes specified in Files. Customer can instead have desired TS quota sizes following given steps.


1.   Open OracleAdapter.xml file on TDI

2.   Add desired values for TS quota sizes as follows:

·         Open ‘OracleSearchUserAL’

·         Go to Feed Section. Select ‘conOracleGetTSQuotas’ connector

·         Open ‘Before Selection’ hook

·         Search for following line where array ‘qt’ is defined

var qt = new Array("128K","256K","512K","1M","2M","4M","8M","16M","32M","64M","UNLIMITED");

·         Add desired values in the array ‘qt’.

·         Save the AL.

3.   Build a profile jar with updated OracleAdapter.xml file.

4.   Import the newly built profile jar (OracleAdapterProfilejar) on ISIM or IGI.

5.   Restart the Service for IBM Tivoli Directory Integrator (TDI).


Installing the adapter language pack

The adapters use a separate language package from the IBM Security Identity Server. See the IBM Security Identity Server Knowledge Centre  for information about installing the adapter language pack.

IBM Security Identity Server Knowledge Centre


Customizing or Extending Adapter Features

The IBM Security Identity adapters can be customized and/or extended. The type and method of this customization may vary from adapter to adapter.

Getting Started

Customizing and extending adapters requires a number of additional skills. The developer must be familiar with the following concepts and skills prior to beginning the modifications:

Note: If the customization requires a new IBM Tivoli Directory Integrator connector, the developer must also be familiar with IBM Tivoli Directory Integrator connector development and working knowledge of Java programming language.

IBM Security Identity Server Resources:

            Check the "Training" section of the IBM Knowledge Center for links to training, publications, and demos.

IBM Security Directory Integrator Resources:

            Check the "Training" section of the IBM Security Directory Integrator Support web site for links to training, publications, and demos.

Support for Customized Adapters

The integration to the IBM Security Identity Server "the adapter framework" is supported. However, IBM does not support the customizations, scripts, or other modifications. If you experience a problem with a customized adapter, IBM Support may require the problem to be demonstrated on the GA version of the adapter before a PMR is opened.

Supported Configurations

Installation Platform

The IBM Security Identity Adapter was built and tested on the following product versions.


Adapter Installation Platform:

IBM Tivoli Directory Integrator 7.1 with Fix Pack 5 or higher

IBM Tivoli Directory Integrator 7.1.1 with Fix Pack 2 or higher

Security Directory Integrator 7.2 with Fix Pack 3


Note:  The adapter supports IBM Security Directory Integrator 7.2, which is available only to customers who have the correct entitlement. Contact your IBM representative to find out if you have the entitlement to download IBM Security Directory Integrator 7.2.


Managed Resource:




IBM Security Identity Manager:

      IBM Security Identity Manager 7.0

IBM Security Privileged Identity Manager (ISPIM):

      ISPIM v2.0

      ISPIM v2.1

Identity Governance and Intelligence (IGI):

      IGI v5.2.1

      IGI v5.2.2

      IGI v5.2.3




This information was developed for products and services offered in the U.S.A. IBM may not offer the products, services, or features discussed in this document in other countries. Consult your local IBM representative for information on the products and services currently available in your area. Any reference to an IBM product, program, or service is not intended to state or imply that only that IBM product, program, or service may be used. Any functionally equivalent product, program, or service that does not infringe any IBM intellectual property right may be used instead. However, it is the users responsibility to evaluate and verify the operation of any non-IBM product, program, or service.

IBM may have patents or pending patent applications covering subject matter described in this document. The furnishing of this document does not give you any license to these patents. You can send license inquiries, in writing, to:

IBM Director of Licensing

IBM Corporation

North Castle Drive

Armonk, NY  10504-1785  U.S.A.

For license inquiries regarding double-byte (DBCS) information, contact the IBM Intellectual Property Department in your country or send inquiries, in writing, to:

IBM World Trade Asia Corporation


2-31 Roppongi 3-chome, Minato-ku

Tokyo 106-0032, Japan

The following paragraph does not apply to the United Kingdom or any other country where such provisions are inconsistent with local law: INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES THIS PUBLICATION "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF NON-INFRINGEMENT, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. Some states do not allow disclaimer of express or implied warranties in certain transactions, therefore, this statement may not apply to you.

This information could include technical inaccuracies or typographical errors. Changes are periodically made to the information herein; these changes will be incorporated in new editions of the publication. IBM may make improvements and/or changes in the product(s) and/or the program(s) described in this publication at any time without notice.

Any references in this information to non-IBM Web sites are provided for convenience only and do not in any manner serve as an endorsement of those Web sites. The materials at those Web sites are not part of the materials for this IBM product and use of those Web sites is at your own risk.

IBM may use or distribute any of the information you supply in any way it believes appropriate without incurring any obligation to you.

Licensees of this program who wish to have information about it for the purpose of enabling: (i) the exchange of information between independently created programs and other programs (including this one) and (ii) the mutual use of the information which has been exchanged should contact:

IBM Corporation


11400 Burnet Road

Austin, TX 78758  U.S.A.

Such information may be available, subject to appropriate terms and conditions, including in some cases, payment of a fee.

The licensed program described in this information and all licensed material available for it are provided by IBM under terms of the IBM Customer Agreement, IBM International Program License Agreement, or any equivalent agreement between us.

Any performance data contained herein was determined in a controlled environment. Therefore, the results obtained in other operating environments may vary significantly. Some measurements may have been made on development-level systems and there is no guarantee that these measurements will be the same on generally available systems. Furthermore, some measurements may have been estimated through extrapolation. Actual results may vary. Users of this document should verify the applicable data for their specific environment.

Information concerning non-IBM products was obtained from the suppliers of those products, their published announcements or other publicly available sources. IBM has not tested those products and cannot confirm the accuracy of performance, compatibility or any other claims related to non-IBM products. Questions on the capabilities of non-IBM products should be addressed to the suppliers of those products.


IBM, the IBM logo, and are trademarks or registered trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at

Adobe, Acrobat, PostScript and all Adobe-based trademarks are either registered trademarks or trademarks of Adobe Systems Incorporated in the United States, other countries, or both.

IT Infrastructure Library is a registered trademark of the Central Computer and Telecommunications Agency which is now part of the Office of Government Commerce.

Intel, Intel logo, Intel Inside, Intel Inside logo, Intel Centrino, Intel Centrino logo, Celeron, Intel Xeon, Intel SpeedStep, Itanium, and Pentium are trademarks or registered trademarks of Intel Corporation or its subsidiaries in the United States and other countries.

Linux is a trademark of Linus Torvalds in the United States, other countries, or both.

Microsoft, Windows, Windows NT, and the Windows logo are trademarks of Microsoft Corporation in the United States, other countries, or both.

ITIL is a registered trademark, and a registered community trademark of the Office of Government Commerce, and is registered in the U.S. Patent and Trademark Office.

UNIX is a registered trademark of The Open Group in the United States and other countries.

Java and all Java-based trademarks and logos are trademarks or registered trademarks of Oracle and/or its affiliates.

Cell Broadband Engine is a trademark of Sony Computer Entertainment, Inc. in the United States, other countries, or both and is used under license therefrom.

Linear Tape-Open, LTO, the LTO Logo, Ultrium, and the Ultrium logo are trademarks of HP, IBM Corp. and Quantum in the U.S. and other countries.

Other company, product, and service names may be trademarks or service marks of others.