Error while Connecting IAM (VS Catalog) to External Oracle
Article ID: 109916
Updated On:
Products
CA Application Test
CA Continuous Application Insight (PathFinder)
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.
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
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.
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.
Feedback
Yes
No
Powered by
