Garth Colasurdo Posted May 13, 2022 Share Posted May 13, 2022 Our DBAs are migrating our Oracle servers to Multi-Tenant. Not sure what that all means, but it changes some of the connection configs. Specifically it uses the Service Name rather than the SID in the JDBC string, as well as having changes to the syntax of the string. On the Oracle side I think it consolidates database resources and makes management easier. I have not seen it referenced in the install documentation, or if this is supported, but I wondered if anyone has done such a configuration. It has worked with most of our other ERP systems, but we did have one system require a lot of reconfiguration and updating to make work. Link to comment Share on other sites More sharing options...
Garth Colasurdo Posted June 7, 2022 Author Share Posted June 7, 2022 Just following up, we determined that we do need to update the Repository Database URL to accomodate the Oracle jdbc string connection. However, to do so, we need to contact Customer Support to make the change (can't be made by with the Administrative Config page). So the new string needs to be in the form of: jdbc:oracle:thin:@{host}:{port}/{service name} The old form is: jdbc:oracle:thin:@{host}:{port}:{SID} Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now