因业务需求,需要配置oracle访问sqlserver数据,故配置gateway
oracle服务器: 192.168.6.10
sqlserver服务器: 192.168.6.16
一、Oracle数据库服务器配置
1、Oracle 数据库服务器信息
[oracle@db ~]$ uname -a
Linux db 2.6.32-431.el6.x86_64 #1 SMP Sun Nov 10 22:19:54 EST 2013 x86_64 x86_64 x86_64 GNU/Linux
[oracle@db ~]$ cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.6.10 db
SQL> select name,dbid,created from v$database;
NAME DBID CREATED
--------- ---------- ---------
ORCL 1435632369 30-MAR-16
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
2、在Oracle服务器上安装gateway(11gR2 gateway是单独的安装包:11.2.0.4.0 x64是第五个安装包)
安装过程默认选择$ORACLE_HOME,安装后在ORACLE_HOME下生成 dg4msql目录
[oracle@db ~]$ cd $ORACLE_HOME
[oracle@db db_1]$ ls