We are trying to configure the MFT DB Logger to connect with the database running on an ORACLE RAC Database where the SCAN listeners are configured for utilizing the failover capabilities of Oracle RAC Db. But the listeners are configured to use Service_name whereas MFT DB Loggers can only use SID for connection to Oracle DB.

The MFT database logger would need to be created and configured in a way that follows the steps outlined at the link below:

https://www.ibm.com/docs/en/ibm-mq/9.4.x?topic=logger-installing-mft-stand-alone-database

The step #4 states:

If you are using an Oracle database, add USE_SID_AS_SERVICE_listener_name=on to yourlistener.ora file, where listener_name is the name of the listener on your database server. Then restart the listener.This parameter specifies that the database connection treats the Oracle system identifier (SID) as the service name for the database. This parameter is required because the MFT database logger connects to Oracle databases only by using a SID but later Oracle databases (from version 12c) use a service name. For more information, see the documentation for your version of Oracle, for example Oracle Net Listener Parameters in the listener.ora File.

This is what we received from our DB team:

Oracle Usage Notes

Database clients with earlier releases of Oracle Database that have hard-coded connect descriptors can use this parameter to connect to a container or pluggable database.

When the database is an Oracle Database 12c container database, the client must specify a service name in order to connect to it. Setting this parameter to on instructs the listener to use the SID in the connect descriptor as a service name and connect the client to the specified database.

Do not use the USE_SID_AS_SERVICE_listener_name parameter with SCAN listeners. The parameter is used for connecting directly through local listeners.