Re: Listener service for SQL server

Posted by ErmanArslansOracleBlog on Oct 02, 2019; 7:58am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Listener-service-for-SQL-server-tp7722p7725.html

Okay.
As you know, you need to install the  Database Gateway for ODBC first.
You need to install it into an ORACLE HOME and the ORACLE_HOME value that you specify in your listener.ora (in SID_DESC) must match the location where you have installed your gateway to.

Modifying this Grid related listener files is not something that I recommend, as the listener configurations in GRID Home uses Dynamic service registration. That 's why you don't see e SID_LIST there.

However, what you want to do actually is to have a static one there.

I didn't test it yet, but you can test it on your own risk.

Just add the below lines to your GRID listener.ora, reload the listener and see.

Do this on a TEST instance first!

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = MySQL)
(ORACLE_HOME = /u01/app/oracle/product/18.0.0.0/dbhome_1)
(PROGRAM = dg4odbc)
)
)