sqlserver to oracle 11g connection

-----------odbcad32---------------------

datasource name (DSN) : dg4odbc

description: dg4odbc

sqlserver : 172.168.0.6

database: msajag

username: lduser

password: kshitij

test connection successfully

--------------------oracle------

Select * from v$parameter where name like 'global_names%';

alter system set global_names=false scope = both;

create public database link lnk_rkserver connect to lduser identified by kshitij using 'dg4odbc';

if ora 28500 error then username, password in double quotes

create public database link lnk_rkserver connect to "lduser" identified by "kshitij" using 'dg4odbc';

---D:\app\Administrator\product\11.2.0\dbhome_1\hs\admin\initdg4odbc.ora------

HS_FDS_CONNECT_INFO = dg4odbc

HS_FDS_TRACE_LEVEL = off

-----------listener-----------

(SID_DESC=

(SID_NAME=dg4odbc)

(ORACLE_HOME=D:\app\Administrator\product\11.2.0\dbhome_1)

(PROGRAM=dg4odbc)

)

-----------------tnsnames.ora-------------

dg4odbc =

(DESCRIPTION=

(ADDRESS=(PROTOCOL=tcp)(HOST=172.168.0.11)(PORT=1521))

(CONNECT_DATA=(SID=dg4odbc))

(HS=OK)

)