Not able to configure Oracle database with Identity Access Manager (IAM)

Document ID : KB000121423
Last Modified Date : 30/11/2018
Show Technical Document Details
Issue:
When installing DevTest 10.4, I want to configure IAM with Oracle database.
When providing the data from our connection string, we are receiving the following error:
Error validating database connection Exception in thread "main" java.lang.illegalStateException: Error checking database connectivity.
IO Error: Invalid connection string format, a valid format is: "host:port:sid"

The connection string is something similar to jdbc:oracle:thin:@ldap://oracleserver.domain.com:1521/DATABASE,cn=Oracle,dc=abcde,dc=com
Environment:
DevTest on release 10.4
Cause:
The connection string format will not fit in the installation wizard.
We need to continue DevTest installation with the embedded database - Derby, and configure the external DB using the dataSourceUpdater.exe under $DEVTEST_HOME/IdentityAccessManager/bin/.
More information in the following document How to Configure DevTest to Use SQL Server for ED, Registry and IAM, under step 3.

While using the dataSourceUpdater.exe, there is an issue when configuring Oracle database. The connection string was being created with a colon (:) before the SID when it needed to be a slash (/):
jdbc:oracle:thin:@ldap://oracleserver.domain.com:1521:DATABASE,cn=Oracle,dc=abcde,dc=com instead of jdbc:oracle:thin:@ldap://oracleserver.domain.com:1521/DATABASE,cn=Oracle,dc=abcde,dc=com
 
Resolution:
If you are facing this issue, please open a support ticket and reference DE393362.
We will be happy to provide you a patch if it matches your issue.