linuxoracle11g使用透明网关连接sqlserver.docxVIP

Linux系统oracle 11g数据库使用透明网关（gateway）连接sqlserver数据库本例中sqlserver数据库是192.168.6.199，oracle数据库是192.168.6.231，gateway透明网关是192.168.6.232，oracle和gateway分开部署。1.准备环境参数修改主机名[root@gateway ~]# vi /etc/sysconfig/networkNETWORKING=yesNETWORKING_IPV6=noHOSTNAME=gateway[root@gateway ~]# vi /etc/hosts127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4::1 localhost localhost.localdomain localhost6 localhost6.localdomain6192.168.6.232gateway~创建用户和组、目录[root@gateway ~]# groupadd dba[root@ gateway ~]# useradd -m -G dba oracle[root@ gateway ~]# passwd oracle[root@ gateway opt]# mkdir -p /u01/app/oracle[root@ gateway opt]# chown -R oracle:dba /u01[root@ gateway /]# chmod 755 /u01修改oracle用户环境变量限制[root@xxgsdb ~]# su - oracle[oracle@xxgsdb ~]$ vi .bash_profile增加以下部分umask 022export ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/tg_1export NLS_LANG=AMERICAN_AMERICA.UTF8export NLS_DATE_FORMAT=yyyy-mm-dd hh24:mi:ssexport PATH=.:${PATH}:$HOME/bin:$ORACLE_HOME/binexport PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/binexport PATH=${PATH}:$ORACLE_BASE/common/oracle/binexport ORACLE_PATH=${PATH}:$ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/adminexport ORACLE_TERM=xtermexport TNS_ADMIN=$ORACLE_HOME/network/adminexport ORA_NLS10=$ORACLE_HOME/nls/dataunset ORA_NLS10export LD_LIBRARY_PATH=$ORACLE_HOME/libexport LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/libexport LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/libexport CLASSPATH=$ORACLE_HOME/JREexport CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlibexport CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlibexport CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlibexport THREADS_FLAG=nativeexport TEMP=/tmpexport TMPDIR=/tmpexport PATH=$PATH:$ORACLE_HOME/bin关闭iptables[root@xxgsdb /]# service iptables stopiptables: Setting chains to policy ACCEPT: filter [ OK ]iptables: Flushing firewall rules: [ OK ]iptables: Unloading modules: [ OK ][root@xxgsdb /]# [root@xxgsdb /]# [root