oracle-gateway 连接sqlserver

sqlserver ip:192.168.0.103 port:1433 database:test
gateway   ip:192.168.0.105 version:Release 11.2.0.3.0
oracle    ip:192.168.0.128 version:Release 10.2.0.1.0

mkdir -p /u01/app/gateway
作为gateway的oracle_home

cat > /u01/app/gateway/dg4msql/admin/initdg4msql.ora << EOF
HS_FDS_CONNECT_INFO=192.168.0.103:1433//test 
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
EOF

cat > /u01/app/gateway/network/admin/listener.ora << EOF
SID_LIST_lsngw =
  (SID_LIST =
    (SID_DESC=
         (SID_NAME=dg4msql)
         (ORACLE_HOME=/u01/app/gateway)
         (PROGRAM=dg4msql)
    )
  )

lsngw =
      (ADDRESS =
        (PROTOCOL = TCP)
        (HOST = 192.168.0.105)
        (PORT = 1522))
EOF
       
ORACLE_HOME=/u01/app/gateway;export ORACLE_HOME
PATH=$ORACLE_HOME/bin:$PATH;export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH;export LD_LIBRARY_PATH

lsnrctl start lsngw

cat >>/u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora << EOF
mssql=
   (DESCRIPTION=
      (ADDRESS=
         (PROTOCOL=TCP)
         (HOST=192.168.0.105)
         (PORT=1522)
      )
      (CONNECT_DATA=
         (SID=dg4msql))
      (HS=OK))
EOF
     
[oracle@ocmdb1 admin]$ tnsping mssql

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 07-JUL-2014 01:36:30

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=192.168.0.105) (PORT=1522)) (CONNECT_DATA= (SID=dg4msql)) (HS=OK))
OK (0 msec)

 --sys
 grant create public database link to term; 
 
 --term
 CREATE PUBLIC DATABASE LINK dl_hrsy CONNECT TO
  "chrI/F" IDENTIFIED BY "chrI/F" USING 'mssql';
 
  --sys
   revoke create public database link from term; 

CREATE PUBLIC DATABASE LINK dlmssql CONNECT TO
 "sa" IDENTIFIED BY "XXXX" USING 'mssql';
 
sys@PROD>select * from dbo.emp@dlmssql;

     empno ename
---------- --------
         1 a
         2 b
   

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22193071/viewspace-1219913/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22193071/viewspace-1219913/