透明网关问题.配置透明网关出现ORA-28546错误.
我是严格按照配置透明网关的过程来配置的为什么还有这样的错误大家来帮我看看.
inittg4msql文件
HS_FDS_CONNECT_INFO="SERVER=10.37.21.91;DATABASE=hotel"
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
listener文件 :
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = banping)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orclx)
(ORACLE_HOME = D:\oracle\ora92)
(SID_NAME = orclx)
)
(SID_DESC =
(GLOBAL_DBNAME = OEMREP)
(ORACLE_HOME = D:\oracle\ora92)
(SID_NAME = OEMREP)
)
(SID_DESC =
(GLOBAL_DBNAME = tg4msql)
(PROGRAM = tg4msql)
(SID_NAME = tg4msql)
(ORACLE_HOME = D:\oracle\ora92)
)
)
tnsnames文件:
ORCHL_10.37.21.90 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.37.21.90)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orchl)
(SERVER = DEDICATED)
)
)
OEMREP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = banping)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = OEMREP)
)
)
test_1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = banping)(PORT = 1521))
)
(CONNECT_DATA =
(SID = tg4msql)
(HS = OK)
)
)
ORCLX =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = banping)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orclx)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = banping)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
ORCHL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.37.21.90)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orchl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
数据连接:
CREATE DATABASE LINK "TOSQL2K" CONNECT TO "SA"
IDENTIFIED BY "********"
USING 'test_1'
使用的时候出现:
最后提示:
ERROR:
ORA-28546: 连接初始化失败, 可能是 Net8 管理错误
ORA-02068: 以下严重错误源于TOSQL2K
ORA-03113: 通信通道的文件结束
大家帮我看看怎么回事.