Error while Connecting IAM (VS Catalog) to External Oracle

Document ID : KB000109916
Last Modified Date : 09/08/2018
Show Technical Document Details
Issue:
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.
Resolution:
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.