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 ;

if you encounter an error like follwing:

select * from

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@]