linux_oracle11g使用透明网关连接sqlserver
发布时间：2023-02-15 17:37:17
Linux系统oracle11g数据库使用透明网关（gateway）连接sqlserver数据库本例中sqlserver数据库是192.168.6.199，oracle数据库是192.168.6.231，gateway透明网关是192.168.6.232，oracle和gateway分开部署。1.准备环境参数a修改主机名[root@gateway~]#vi/etc/sysconfig/networkNETWORKING=yesNETWORKING_IPV6=noHOSTNAME=gateway[root@gateway~]#vi/etc/hosts127.0.0.1localhostlocalhost.localdomainlocalhost4localhost4.localdomain4::1localhostlocalhost.localdomainlocalhost6localhost6.localdomain6192.168.6.232gateway~b创建用户和组、目录[root@gateway~]#groupadddba[root@gateway~]#useradd-m-Gdbaoracle[root@gateway~]#passwdoracle[root@gatewayopt]#mkdir-p/u01/app/oracle[root@gatewayopt]#chown-Roracle:dba/u01[root@gateway/]#chmod755/u01c修改oracle用户环境变量限制[root@xxgsdb~]#su-oracle[oracle@xxgsdb~]$vi.bash_profile增加以下部分umask022exportORACLE_BASE=/u01/app/oracleexportORACLE_HOME=$ORACLE_BASE/product/11.2.0/tg_1exportNLS_LANG=AMERICAN_AMERICA.UTF8exportNLS_DATE_FORMAT="yyyy-mm-ddhh24:mi:ss"exportPATH=.:${PATH}:$HOME/bin:$ORACLE_HOME/binexportPATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/binexportPATH=${PATH}:$ORACLE_BASE/common/oracle/bin
exportORACLE_PATH=${PATH}:$ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/adminexportORACLE_TERM=xtermexportTNS_ADMIN=$ORACLE_HOME/network/adminexportORA_NLS10=$ORACLE_HOME/nls/dataunsetORA_NLS10exportLD_LIBRARY_PATH=$ORACLE_HOME/libexportLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/libexportLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/libexportCLASSPATH=$ORACLE_HOME/JREexportCLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlibexportCLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlibexportCLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlibexportTHREADS_FLAG=nativeexportTEMP=/tmpexportTMPDIR=/tmpexportPATH=$PATH:$ORACLE_HOME/bind关闭iptables[root@xxgsdb/]#serviceiptablesstopiptables:SettingchainstopolicyACCEPT:filter[OK]iptables:Flushingfirewallrules:[OK]iptables:Unloadingmodules:[OK][root@xxgsdb/]#[root@xxgsdb/]#[root@xxgsdb/]#chkconfig--listiptablesiptables0:off1:off2:on3:on4:on5:on6:off[root@xxgsdb/]#chkconfigiptablesoff[root@xxgsdb/]#chkconfig--listiptablesiptables0:off1:off2:off3:off4:off5:off6:off2.安装gateway（透明网关）组件a下载透明网关Oralce11g下透明网管是一个单独的组件，需要单独下载安装，这里下载是64位的，请根据具体下载32位或64位，下载地址google 