Error while Connecting IAM (VS Catalog) to External Oracle

book

Article ID: 109916

calendar_today

Updated On:

Products

CA Application Test Service Virtualization CA Continuous Application Insight (PathFinder) CA Service Virtualization (DevTest / LISA / VSE / Application Test)

Issue/Introduction

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.

Environment

Release:
Component: ITKOVS

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.