Identity Manager DB Connection Error

book

Article ID: 196974

calendar_today

Updated On:

Products

CA Identity Manager CA Identity Governance CA Identity Portal CA Identity Suite

Issue/Introduction

Trying  install IDM 14.3.0 and after entered the Oracle connection information, it fails to connect with the below error.

DBConnection: dbUserName=IAMOBJECT_2
DBConnection: dbPassword=***********
DBConnection: dbServerName=***********
DBConnection: dbName=DCX153
DBConnection: dbPort=16112
DBConnection: dbType=DB_ORACLE
DBConnection: tableName=
DBConnection: schemaName=
DBConnection: Connection String: jdbc:oracle:thin:IAMOBJECT_2/***********@//***********:16112/DCX153
DBConnection: Unable to connect to the database due to the following error
17067: Invalid Oracle URL specified
java.sql.SQLException: Invalid Oracle URL specified

Cause

User credential contain special chars that was part of JDBC connection string.

Environment

Release : 14.3

Component : IdentityMinder(Identity Manager)

Resolution

Replaced @ with other special chars