想通過透明网關來實現oracle連接sqlserver,總是不成功,請大家看看,謝謝!
OS:WINDOWS XP
ORACLE:Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
SQLSERVER200.
oracle和sqlserver都裝在同一台机器(192.168.1.221),oracle用system用戶,sqlsver用aaaa/aaaa測試,測試表為pubs.t!
[php]
#D:\oracle\ora92Loc\tg4msql\admin\inittg4msql.ora
# This is a sample agent init file that contains the HS parameters that are
# needed for the Transparent Gateway for SQL Server
#
# HS init parameters
#
HS_FDS_CONNECT_INFO="SERVER=192.168.1.221;DATABASE=pubs"
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
# LISTENER.ORA Network Configuration File: D:\oracle\ora92Loc\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = S0504027)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora92Loc)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = DB)
(ORACLE_HOME = D:\oracle\ora92Loc)
(SID_NAME = DB)
)
(SID_DESC =
(GLOBAL_DBNAME = tg4msql)
(PROGRAM=tg4msql)
(ORACLE_HOME = D:\oracle\ora92Loc)
(SID_NAME = tg4msql)
)
)
# TNSNAMES.ORA Network Configuration File: D:\oracle\ora92Loc\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = S0504027)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
DB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = S0504027)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DB)
)
)
TG4MSQL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.221)(PORT = 1521))
)
(CONNECT_DATA =
(SID = tg4msql )
)
(HS=OK)
)
[/php]
--
tns能ping通
-----
[php]
create database link from_sql
connect to aaaa identified by aaaa
using 'tg4msql' ;
SQL> select * from t@FROM_SQL;
select * from t@FROM_SQL
ORA-28500: 從 ORACLE 到非 Oracle 系統的連線傳回如下訊息:
[Transparent gateway for MSSQL]Could not open MS-SQL Connection
ORA-02063: 在 2 lines 之前, 自 FROM_SQL
[/php]
|
