Listener service for SQL server

Posted by Mydeen on Oct 01, 2019; 8:17am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Listener-service-for-SQL-server-tp7722.html

we need help on creating the DB link for Microsoft SQL server from Oracle
Currently we have established the ODBC connection on both server to reach it.

Here the issue is we don't know how to do the changes in listerner.ora file as its
configured with ASM. Please help us the sample to do that.

Current file listener:
-- Linux Database

LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))            # line added by Agent
ASMNET1LSNR_ASM=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=ASMNET1LSNR_ASM))))              # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_ASMNET1LSNR_ASM=ON               # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_ASMNET1LSNR_ASM=SUBNET         # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON              # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER=SUBNET                # line added by Agent


Need to add the SQL server servcies, we don't know how to add and where to add
        (SID_DESC =
      (SID_NAME = MySQL)
      (ORACLE_HOME = /u01/app/oracle/product/18.0.0.0/dbhome_1)
      (PROGRAM = dg4odbc)
    )