Error while Connecting IAM (VS Catalog) to External Oracle
Article ID: 109916
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.
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.