问题1：数据库不方便安装透明网关软件怎么办？
解决方案：在其他数据库服务器上安装透明网关软件，再在本机上添加透明网关服务器的tns别名即可

192.168.21.16不方便安装透明网关服务器，直接在一台虚拟机192.168.128.163上安装透明网关（指向IP为172.16.50.162端口为1433的RPT数据库），192.168.21.16新增指向192.168.128.163监听的tns别名信息即可

192.168.128.163安装透明网关
透明网关配置如下
[oracle@localhost admin]$ pwd
/u01/app/oracle/product/11.2.0/db_1/dg4msql/admin
[oracle@localhost admin]$ cat initdg4msql.ora
HS_FDS_CONNECT_INFO=[172.16.50.162]:1433//RPT
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER

静态监听配置如下
[oracle@localhost admin]$ pwd
/u01/app/oracle/product/11.2.0/db_1/network/admin
[oracle@localhost admin]$ cat listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.128.163)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME= /u01/app/oracle/product/11.2.0/db_1)
(SID_NAME = dg4msql)
(PROGRAM = dg4msql)
)
)
ADR_BASE_LISTENER = /u01/app/oracle

监听信息如下
[oracle@localhost admin]$ lsnrctl status|grep dg4
Service "dg4msql" has 1 instance(s).
Instance "dg4msql", status UNKNOWN, has 1 handler(s) for this service...

192.168.21.16添加如下tns信息
sqlserver162 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.128.163)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dg4msql)
)
(HS=OK)
)

问题2：$ORACLE_HOME和透明网关的安装路径不一样，怎么办？
解决方案：透明网关的监听配置里面$ORACLE_HOME写成实际安装路径

[oratst@hqerp1 TST_hqerp1]$ echo $ORACLE_HOME
/u01/TST/db/tech_st/11.2.0

[oratst@hqerp1 ~]$ ll /u01/TST/db/tech_st/gatways/dg4msql/admin/initdg4msql.ora
-rw-r--r-- 1 oratst dba 362 Apr 5 15:31 /u01/TST/db/tech_st/gatways/dg4msql/admin/initdg4msql.ora

静态监听的关键配置如下
TST =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.31)(PORT = 1571))
)
)

SID_LIST_TST =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME= /u01/TST/db/tech_st/11.2.0)
(SID_NAME = TST)
)
(SID_DESC =
(ORACLE_HOME= /u01/TST/db/tech_st/gatways)
(SID_NAME = dg4msql)
(PROGRAM = dg4msql)
)
)

Lsnrctl status tst显示如下信息
Service "TST" has 1 instance(s).
Instance "TST", status UNKNOWN, has 1 handler(s) for this service...
Service "dg4msql" has 1 instance(s).
Instance "dg4msql", status UNKNOWN, has 1 handler(s) for this service...

ITPub博客

透明网关一些特殊场景的配置

最新文章