Oracle change from sid to service_name

Hi. We have our database configuration setup in the service console database setting using the sid as the name. we are in the process of upgrading to oracle 12c and we will not be using sid anymore but will have a service_name. I have tried but are unable to connect using the service name. Anyone an idea how to set the settings to use service name? I keep on getting Opening JDBC connection to snapdb12c:1521 failed with SQLState: 66000 Error code: 12505 Message: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor Retrying...(2/4)
1 answers

This is available as an advanced custom setting. I've used this option in Mendix 5, but looks like it's in Mendix 4 as well:


Defines the SERVICE_NAME when you have a connection with an Oracle DBMS.

See the full reference here