Error while Connecting IAM (VS Catalog) to External Oracle
search cancel

Error while Connecting IAM (VS Catalog) to External Oracle


Article ID: 109916


Updated On:


CA Application Test CA Continuous Application Insight (PathFinder)


We are getting the below error when connecting IAM (VS Catalog) to the external database (Oracle).

We are providing the servicename and the configuration requires the SID name.

In our organization SID is not preferred and we have to connect via the given servicename.

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

Please let us know how we can connect via the service name as all other applications (EnterpriseDashboard,Registry) are connected using the servicename.


Component: ITKOVS


IAM only supports only a SID, but the connection url in the configuration file can be updated to use service name.

1. Navigate to /IdentityAccessManager/standalone/configuration
2. Open standalone.xml
3. Search for pool-name="KeycloakDS"
4. Update the connection url as needed.

Change the connection-url to your service:

Service format: jdbc:oracle:thin:@//[HOST][:PORT]/SERVICE

Verify tables created with a JDBC connection tool.