我是严格按照配置透明网关的过程来配置的为什么还有这样的错误大家来帮我看看.
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: 通信通道的文件结束
大家帮我看看怎么回事.
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: 通信通道的文件结束
大家帮我看看怎么回事.
不行呀,你的哪个地址看不了,注册了死活登陆不了.发过来看看吧.
ORA-28546: 连接初始化失败, 可能是 Net8 管理错误
ORA-02068: 以下严重错误源于TOSQL2K
ORA-03113: 通信通道的文件结束
刚刚测试直接连接System@***** test_1就报ORA-03113: 通信通道的文件结束
你先到这看下吧,有关于异构通讯和DBLINK的文章
(SID_DESC=
(SID_NAME=TEST_SQLSERVER)
(ORACLE_HOME=D:\oracle\ora92)
(PROGRAM=hsodbc)
) tnsnames.ora文件:
TEST_SQLSERVER =
(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=10.37.23.188) (PORT=1521) )
(CONNECT_DATA=
(SID=TEST_SQLSERVER)
(HS=OK) )
)
initTEST_SQLSERVER.ora文件:HS_FDS_CONNECT_INFO = TEST_SQLSERVER
HS_FDS_TRACE_LEVEL = 0
Connect System/****@TEST_SQLSERVER
ERROR:
ORA-03113: 通信通道的文件结束
CREATE PUBLIC DATABASE LINK "TEST2" CONNECT TO "SA"
IDENTIFIED BY "********"
USING 'TEST_SQLSERVER' desc ss@TEST2;ERROR:
ORA-28546: 连接初始化失败, 可能是 Net8 管理错误
ORA-02068: 以下严重错误源于TEST2
ORA-03113: 通信通道的文件结束
tnsnames.ora文件的IP地址是填ORACLE的IP2、查看监听状态 lsnrctl status3、global_names = false 否则不能查询
global_names = false
sql在远程,tnsnames.ora的ip是写的本机.
看来问题出在这儿.状态是unknown.为什么会这样呢?
ODBC数据源建了吗?
就是负责听这个连接的TEST_SQLSERVER状态是unknown.
其他都是先显示unknown,后显示ready