Oracle Database Gateways透明网关的安装和配置
简介
在企业里，通常可能有多种数据源，并且他们是异构的。所谓的异构就是说他们是不同的产品，例如: Oracle Database, MS SQL Server, IBM DB2, Sybase ASE, MySQL, Postgre SQL, Excel, XML, Txt或者CSV等用于存放数据的产品或者文件。
oracle 透明网关（Transparent gateways）是Oracle连接异构数据库提供的一种技术。通过Gateway，可以在Oracle里透明的访问其他不同的数据库，如SQL Server, DB2, Sybase等等，就像远程Oracle数据库一样。因此透明网关也是Oracle数据仓库和数据迁移中的一个重要组成部分。透明网关的体系结构也很简单，在ORACLE和SQL SERVER之间使用ORACLE透明网关服务器实现互连互通，其中透明网关服务器可以与ORACLE或SQL SERVER数据库在同一台主机上，也可以是在独立的一台主机上。
配置后的sql查询的处理流程如下：
下载
安装包和数据库的安装包在一块，最新的软件下载：https://www.oracle.com/database/technologies/oracle-database-software-downloads.html
历史版本下载：https://edelivery.oracle.com
历史版本下载需要登录Oracle账号，这个不需要mos即可，自己注册一个就行。
然后搜索“12.2.0.1 gateway”，
然后点击找到的项目，加入下载目录，然后点击Continue：
由于安装网关需要有数据库作为基础，所以这里带出来2个软件，但是我DB已经安装过了，所以，这里只下载Gateways就行：
image-20220305091445233
image-20220305091720746点击Download会下载如下的下载管理器：
打开即可：
下一步会自动下载：
还能看到下载性能：
还能设置限速：
等待下载完成即可。
安装
1useradd -g oinstall -G oinstall,dba gateway && echo "lhr" | passwd gateway --stdin<br> 2<br> 3<br> 4cat >> /home/gateway/.bash_profile UNIX_GROUP_NAME=oinstall <br> 3> INVENTORY_LOCATION=/u01/app/oraInventory <br> 4> ORACLE_BASE=/u01/app/ <br> 5> ORACLE_HOME=/u01/app/gateway <br> 6> oracle.install.tg.customComponents=oracle.rdbms.tg4msql:12.2.0.1.0,oracle.rdbms.hsodbc:12.2.0.1.0 <br> 7> oracle.install.tg.msqlConStr=192.168.66.236,1433,MSSQLSERVER,LHRDB<br> 8Starting Oracle Universal Installer...<br> 9<br> 10Checking Temp space: must be greater than 415 MB. Actual 368199 MB Passed<br> 11Checking swap space: must be greater than 150 MB. Actual 10546 MB Passed<br> 12Preparing to launch Oracle Universal Installer from /tmp/OraInstall2022-03-05_03-52-10PM. Please wait ...[WARNING] [INS-32056] The specified Oracle Base contains the existing Central Inventory location: /u01/app/oraInventory.<br> 13 ACTION: Oracle recommends that the Central Inventory location is outside the Oracle Base directory. Specify a different location for the Oracle Base.<br> 14[WARNING] [INS-13014] Target environment does not meet some optional requirements.<br> 15 CAUSE: Some of the optional prerequisites are not met. See logs for details. /u01/app/oraInventory/logs/installActions2022-03-05_03-52-10PM.log<br> 16 ACTION: Identify the list of failed prerequisite checks from the log: /u01/app/oraInventory/logs/installActions2022-03-05_03-52-10PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.<br> 17You can find the log of this install session at:<br> 18 /u01/app/oraInventory/logs/installActions2022-03-05_03-52-10PM.log<br> 19<br> 20Prepare in progress.<br> 21.................................................. 8% Done.<br> 22<br> 23Prepare successful.<br> 24<br> 25Copy files in progress.<br> 26.................................................. 14% Done.<br> 27.................................................. 20% Done.<br> 28.................................................. 25% Done.<br> 29.................................................. 30% Done.<br> 30.................................................. 36% Done.<br> 31.................................................. 42% Done.<br> 32.................................................. 47% Done.<br> 33.................................................. 52% Done.<br> 34.................................................. 57% Done.<br> 35.................................................. 64% Done.<br> 36.................................................. 69% Done.<br> 37.................................................. 74% Done.<br> 38....................<br> 39Copy files successful.<br> 40<br> 41Link binaries in progress.<br> 42<br> 43Link binaries successful.<br> 44<br> 45Setup files in progress.<br> 46<br> 47Setup files successful.<br> 48<br> 49Setup Inventory in progress.<br> 50<br> 51Setup Inventory successful.<br> 52<br> 53Finish Setup successful.<br> 54The installation of Oracle Database Gateways was successful.<br> 55Please check '/u01/app/oraInventory/logs/silentInstall2022-03-05_03-52-10PM.log' for more details.<br> 56<br> 57Oracle Gateway Configuration in progress.<br> 58<br> 59Oracle Net Configuration Assistant in progress.<br> 60.................................................. 95% Done.<br> 61<br> 62Oracle Net Configuration Assistant failed.<br> 63[WARNING] [INS-32091] Software installation was successful. But some configuration assistants failed, were cancelled or skipped.<br> 64 ACTION: Refer to the logs or contact Oracle Support Services.<br> 65<br> 66<br> 67[gateway@lhrora1221 admin]$ netca -silent -responsefile $ORACLE_HOME/assistants/netca/netca.rsp -instype custom -listener LISTENER -lisport 1525<br> 68<br> 69Parsing command line arguments:<br> 70 Parameter "silent" = true<br> 71 Parameter "responsefile" = /u01/app/gateway/assistants/netca/netca.rsp<br> 72 Parameter "instype" = custom<br> 73 Parameter "listener" = LISTENER<br> 74 Parameter "lisport" = 1525<br> 75Done parsing command line arguments.<br> 76Oracle Net Services Configuration:<br> 77Configuring Listener:LISTENER<br> 78Listener configuration complete.<br> 79Oracle Net Listener Startup:<br> 80 Running Listener Control: <br> 81 /u01/app/gateway/bin/lsnrctl start LISTENER<br> 82 Listener Control complete.<br> 83 Listener started successfully.<br> 84Profile configuration complete.<br> 85Oracle Net Services configuration successful. The exit code is 0<br> 86<br> 87[test@lhrora1221 admin]$ lsnrctl status<br> 88<br> 89LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 05-MAR-2022 16:02:02<br> 90<br> 91Copyright (c) 1991, 2016, Oracle. All rights reserved.<br> 92<br> 93Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=lhrora1221)(PORT=1525)))<br> 94STATUS of the LISTENER<br> 95------------------------<br> 96Alias LISTENER<br> 97Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production<br> 98Start Date 05-MAR-2022 16:01:56<br> 99Uptime 0 days 0 hr. 0 min. 6 sec<br>100Trace Level off<br>101Security ON: Local OS Authentication<br>102SNMP OFF<br>103Listener Parameter File /u01/app/gateway/dg4msql/admin/listener.ora<br>104Listener Log File /u01/app/gateway/network/log/listener.log<br>105Listening Endpoints Summary...<br>106 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lhrora1221)(PORT=1525)))<br>107 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1525)))<br>108The listener supports no services<br>109The command completed successfully <br>
