transparent gateway 透明网关配置

--listener.ora

# listener.ora Network Configuration File: E:product11.2.0tg_1NETWORKADMINlistener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(PROGRAM = dg4msql)
(SID_NAME = dg4msql)
(ORACLE_HOME = E:product11.2.0tg_1)
)
(SID_DESC =
(PROGRAM = dg4odbc)
(SID_NAME = dg4odbc)
(ORACLE_HOME = E:product11.2.0tg_1)
)
(SID_DESC =
(PROGRAM = dg4msql)
(SID_NAME = dg4msql207)
(ORACLE_HOME = E:product11.2.0tg_1)
)

)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.216.65)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

ADR_BASE_LISTENER = E:product11.2.0tg_1

---initdg4msql.ora

# This is a customized agent init file that contains the HS parameters
# that are needed for the Database Gateway for Microsoft SQL Server

#
# HS init parameters
#
#HS_FDS_CONNECT_INFO="SERVER=172.16.216.111;DATABASE=homelink_db"
HS_FDS_CONNECT_INFO=172.16.11.31//Broker
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=recover
HS_FDS_RECOVERY_PWD=RECOVER

HS_FDS_DEFAULT_OWNER=dbo
HS_DB_NAME=BROKER
#HS_DB_INTERNAL_NAME=01010104
HS_DB_DOMAIN=MS.BJ.CN
#HS_LANGUAGE=american_america.al32utf8
HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P1
#HS_LONG_PIECE_TRANSFER_SIZE=10485760
#HS_RPC_FETCH_REBLOCKING=on
#HS_FDS_FETCH_ROWS=1000

---important supplyment:

select * from sys.all_tables@broker.ms.bj.cn ;

if you encounter an error like follwing:

select * from sys.all_tables@ho.world

ORA-00604: error occurred at recursive SQL level 1
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
ORA-02063: preceding line from HO.WORLD
--- The real reason which cause this error message is that oracle TG bug.

Just modify TG parameter nl_language to workaround it.

change character Encode to ISO8859 .

HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P1

-- test again ,it will be OK.

另一种解决办法：对SQL SERVER和ORACLE ，透明网关三者使用相同的字符集（ZHS16GBK），最后在ORACLE内部实现转码，这样可以更顺利些。

##重要声明：

透明网关所使用的数据库参数文件名，命名规范与ORACLE实例相同，如inithm.ora 表示hm实例的参数文件，否则，如果ORACLE监听在接收到客户端连接时找不到参数文件名，会报错，错误代号：ORA-28513。

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/350519/viewspace-1048327/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/350519/viewspace-1048327/