IBM Security Identity Adapter for Oracle Database 7.1.28 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:
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.
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.
Note: Service group name change is not supported.
The Oracle Database Adapter does not support management of service groups.
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.
Adapter Version
|
Component |
Version |
|
Build Date |
2020 June 11 23.46.56 |
|
Adapter Version |
7.1.28 |
|
Component Versions |
Adapter build: 7.1.28.118 Profile: 7.1.28.118 Connector: 7.1.28.118 Dispatcher 7.1.39 or higher (packaged separately) |
|
Documentation |
The following guides are available in the IBM Knowledge Center: Oracle Database Adapter Installation and Configuration Guide |
New Features
|
Enhancement # (FITS) |
Description |
|
|
Items included in current release(7.1.28) |
|
RTC 186614 |
Oracle Database 19c Certification |
|
|
Items included in release(7.1.27) |
|
|
None |
|
|
Items included in release(7.1.26) |
|
RTC 177624
Bug 2641
RFE 123794 |
Added functionality to display last Login time on IGI
|
|
|
Items included in release(7.1.25) |
|
|
None
|
|
|
Items included in 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 |
|
|
Items included in release(7.0.22) |
|
42054 (84786) |
ISIM v6.0 Oracle Database adapter support of Oracle 12c CDB databases
|
|
|
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 |
|
|
None |
|
|
Items included in 7.0.18 release |
|
|
None |
Closed Issues
|
CMVC# |
APAR# |
PMR# / Description |
|
|
|
Items closed in current release (7.1.28) |
|
|
|
None |
|
|
|
Items closed in release (7.1.27) |
|
RTC 183248 |
|
Internal - save all the ALs in TDI 7.1.1 |
|
Bugz 2854/RTC 183249 |
|
Internal - Trailing spaces in erlockdate attribute's definition must be removed |
|
|
|
Items closed in release (7.1.26) |
|
Bug 2642 RTC 177623 APAR IJ06996 |
|
Mapping all users of Oracle end resource to IGI user |
|
|
|
Items closed in release (7.1.25) |
|
Bugz 2472/RTC 174802 |
IJ05419 |
Error ORA-01741 on modify request |
|
|
|
Items closed in release.(7.1.24) |
|
|
|
None |
|
|
|
Items closed in release.(7.1.23) |
|
Bugz 2152/ 2202 RTC153511/ 153512 |
IV90163 |
Connect credential / Search operation fails for Oracle 11G Test connection and Reconciliation fail on 11g |
|
Bugz 2194 RTC153513 |
IV90344 |
Oracle profile does not contain RMI status attributes for service form |
|
RTC152426 |
|
Missing value for conEmpty leads to NullPointerException on FP14 |
|
|
|
Items closed in release (7.0.22) |
|
Bugz 2041/ 2066 |
IV84414 |
Oracle adapter Tablespace quota not reconciled ISPIM Oracle DB adapter not retrieving Tablespace quotas |
|
|
|
Items closed in 7.0.21 release |
|
Bug1960, RTC 137359 |
|
Oracle DB Adapter - encryption issue. The JDBC Thin Client Properties File, OraASO.properties 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 |
|
Internal |
|
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 |
|
IV72523 |
|
Warning on erroraroles 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 |
|
|
|
None. |
Known Issues
|
Internal# |
APAR# |
PMR# / Description |
|
N/A |
N/A |
Converting between Default and Non-default Roles It is a two-step process to make a role 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. |
See the IBM Security Identity Adapter Installation Guide for detailed instructions.
The following configuration notes apply to this release:
The following corrections to the Installation Guide apply to this release:
The Oracle DB adapter can be now used to manage Oracle container database. However, the CDB and each PDB connected to it, should be managed separately thru separate services from ISIM.
Adapter user account for managing Oracle container database
· CDB can be managed using common users.
· PDB can be managed using local users only.
Add/Modify account operation
For CDB
· 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.
For PDB
· 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
For CDB
We will be managing the common users through CDB services.
For PDB
We will be managing only local users through PDB services.
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
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.
Installation Platform
The IBM Security Identity Adapter was built and tested on the following product versions.
Adapter Installation Platform:
Note: Earlier SDI supported versions may function properly, however to resolve any communication errors, you must upgrade your SDI releases to the officially supported versions.
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
IGI v5.2.4
IGI v5.2.5
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 user's 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:
Intellectual Property Licensing
Legal and Intellectual Property Law
IBM Japan, Ltd.
1623-14, Shimotsuruma, Yamato-shi
Kanagawa 242-8502 Japan
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
2ZA4/101
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.
Trademarks
IBM,
the IBM logo, and ibm.com 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 www.ibm.com/legal/copytrade.shtml.
Microsoft, Windows, and the Windows logo are trademarks of Microsoft
Corporation in the United States, other countries, or both.
Java and all Java-based trademarks and logos are trademarks or registered
trademarks of Oracle and/or its affiliates.