IBM Security Verify Governance Adapter 10.0.6 for Oracle Database is available. Compatibility, installation, and other getting-started issues are addressed.
Copyright International Business Machines Corporation 2022, 2023. All rights reserved.
US Government Users Restricted Rights -- Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
Welcome to the IBM Security Verify Governance Adapter for Oracle Database.
These Release Notes contain information for the following products that was not available when the IBM Security Verify Governance Adapter manuals were printed:
· IBM Security Verify Governance Adapter for Oracle Database Installation and Configuration Guide
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 Verify Governance 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 Verify Governance and/or IBM Security Verify Governance Identity Manager 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 Verify Governance 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 |
2024 March 22 16.43.33 |
Adapter Version |
10.0.6 |
Component Versions |
Adapter build: 10.0.6.17 Profile: 10.0.6.17 Connector: 10.0.6.17 Dispatcher 7.1.39 or higher (packaged separately) |
Documentation |
The following guides are available in the IBM Security Verify Adapters Knowledge Center: Oracle Database Adapter Installation and Configuration Guide |
New Features
Internal |
Enhancement # (RFE) |
Description |
|
|
Items included in release (10.0.6) |
|
|
None |
Items included in release (10.0.5) |
||
RTC 191004 |
Oracle Database 21c Certification |
|
RTC 191297 |
ADAPT-I-160 |
Oracle Adapter support for Kerberos authentication |
RTC 191296 |
ADAPT-I-159 |
Oracle adapter external authentication |
|
Items included in release (10.0.4) |
|
|
None |
|
|
Items included in release (10.0.3) |
|
|
None |
|
|
Items included in release (10.0.2) |
|
RTC 188054 |
Add tooltip labels for Oracle adapter |
|
|
Items included in release (10.0.1) |
|
RTC 187756 |
Added supporting data changes for IBM Security Verify - Governance Oracle DB adapter |
|
|
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
Internal# |
KnownIssue# / Case# |
Description |
Items included in current release (10.0.6) |
||
Bug 4252 / SVGAD 1619 |
DT257601 / TS014847380 |
eroraauthenticationtype is set to Local for accounts that have value None |
Items included in release (10.0.5) |
||
Bugz 3774/RTC 190869 |
IJ42338 / TS008455971 |
The Oracle DB adapter doesn't use the default consumer group value if this is specified in ISIM |
RTC 190640 |
OracleDB eroraconvertusernametouppercase not honored |
|
|
|
Items included in release (10.0.4) |
Bugz 3689/RTC 190107 |
IJ36971 |
Trying to figure out NPE ISIM server side failure from different types of Oracle adapter request failures |
|
|
Items included in release (10.0.3) |
Bugz 3509/RTC 188908 |
IJ32424 |
information about the last login time of an Oracle account |
|
|
Items included in release (10.0.2) |
|
|
None |
|
|
Items closed in release (10.0.1) |
Bugz 3305/RTC 187874 |
IJ28159 |
Error ACCESS_ANY_WORKSPACE : ERROR: java.sql.SQLException: ORA-06550 on modify |
|
|
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 Limitations
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. |
|
|
In IGI, eroraglobalname target attribute is not being deleted properly. |
-------------------
Installation and Configuration Notes
See the IBM Security Verify Governance Application Adapters for Oracle Adapter Installation and Configuration guide.
Corrections and/or additions to the Installation and Configuration sections of the adapter guide
Chapter 1: Overview
No updates for the current release
Chapter 2: Planning
No updates for the current release
Chapter 3: Installing
Installing in the Verify Governance Virtual Appliance
( Please add this new section at knowledge centre (under Installing > Installing in the Verify Governance Virtual Appliance) for Azure AD Adapter to describe installation procedure of adapter in Verify Governance Virtual Appliance: https://www.ibm.com/docs/en/svgaa?topic=ldap-installing-in-virtual-appliance. Please add this below note as well after adding the description.)
Note: While uploading the Adapter package, you may receive System Error: A file included in the SDI Adapter zip already exists on the system and the Server Message log under Appliance tab of VA will have a reference to error com.ibm.identity.sdi.SDIManagementService E File ibm.com_IBM_Security_Verify_Governance_xxxx.swidtag found in the adapter zip at location ILMT-Tags/ already exists in system. This is because, you can install the same swidtags only once. So, if another adapter of the same type is installed, remove the swidtags.
The ibm.com_IBM_Security_Verify_Governance_Enterprise-xxxx.swidtag file is common to all adapters. In addition to the common swidtag file, an application adapter needs ibm.com_IBM_Security_Verify_Governance_Application_Adapters-xxxx.swidtag file and an infra adapter needs ibm.com_IBM_Security_Verify_Governance_Lifecycle-xxxx.swidtag and ibm.com_IBM_Security_Verify_Governance_Compliance-xxxx.swidtag files. So, if an application adapter is already installed and this is an infra adapter, then only install the infra-specific swidtags and the other way around. Please visit IBM Security Verify Governance Adapters v10.x link to identify the adapter type of the installed adapters.
Chapter 4: Upgrading
No changes
Chapter 5: Configuring
No changes
Chapter 6: Troubleshooting
Enabling DEBUG Logs on SDI Server
Procedure:
1. Stop the SDI Server process
Pre-7.2.0-ISS-SDI-FP0008
2. Edit the <SDI_Solution_Directory>/etc/log4j.properties
3. Modify the following line:
log4j.rootCategory=INFO, Default
to
log4j.rootCategory=DEBUG, Default
Post-7.2.0-ISS-SDI-FP0008
2. Edit the <SDI_HOME_Directory>/etc/log4j2.xml
3. Modify the following line:
<Root level="info">
to
<Root level="debug">
From-7.2.0-ISS-SDI-FP0011
4. To enable TCB block in debug
5. Append the line com.ibm.di.logging.close=false in the <SDI_HOME_Directory>/etc/global.properties file.
6. Start the SDI Server process
7. Re-create the problem and collect the <SDI_Solution_Dir>/logs/ibmdi.log
Chapter 7: Reference
No updates for the current release
Supported Configurations
Supported third-party client libraries:
· ojdbc8.jar (https://www.oracle.com/in/database/technologies/appdev/jdbc-downloads.html)
Installation Platform
The IBM Security Verify Governance Adapter for Oracle Adapter was built and tested on the following product versions.
Adapter Installation Platform:
Due to continuous Java security updates that may be applied to your IBM Security Verify Governance server and IBM Security Verify Governance Identity Manager server, the following SDI releases are the officially supported versions:
- Security Directory Integrator 7.2 + FP12
Note: Earlier versions of SDI that are still supported may function properly, however to resolve any communication errors, you must upgrade your SDI releases to the officially supported versions by the adapters. Please refer to the adapter's installation and configuration guides for the latest update on IBM Security Directory Integrator versions and fix packs
· Oracle 19c (non-container database)
· Oracle 19c (Container database)
· Oracle 21c (Container database)
Supported
IBM Security Verify servers
IBM Security Verify Governance Identity Manager v10.0*
IBM Security Verify Governance v10.0
* Unless this document specifies a specific fix pack version of ISVG Identity Manager v10, we expect the adapter to work with ISIM 6 as well. However, it will only be debugged and fixed from the perspective of ISVG-IM v10.
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.