Connect from Oracle 12c to SQL server 2012

Hi Team,

I have configured DB link to connect between Oracle 12c ( Linux server ) to SQL 2012 ( win 2012 std ).

Error after run simple query

SQL> select count(*) from AX_SALES_ALLOC@MSSQL_TEST;

select count(*) from AX_SALES_ALLOC@MSSQL_TEST

                                    *

ERROR at line 1:

ORA-28500: connection from ORACLE to a non-Oracle system returned this message:

ORA-02063: preceding line from MSSQL_TEST

All configuration done ;

1. 1. Configure the gateway init file (init*.ora).
   2. Configure Oracle® Net for the gateway (listener.ora).
   3. Configure the Oracle® database for gateway access (tnsnames.ora).
2. Create a database link.

Appreciate your comment

TQ

Abez