sql server and oracle stady
1,install the sql server gataway
2,$oracle_home/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.0.47;DATABASE=pubs"
HS_FDS_TRACE_LEVEL=ON
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
3,update then file:$oracle_home/network/admin/listner.ora
# LISTENER.ORA Network Configuration File: d:oracleora92NETWORKADMINlistener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = lkhuasof-lihj)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = tg4msql)
(PROGRAM = tg4msql)
(ORACLE_HOME = D:oracleora92)
(SID_NAME = tg4msql)
)
(SID_DESC =
(GLOBAL_DBNAME = oralihj)
(ORACLE_HOME = d:oracleora92)
(SID_NAME = oralihj)
)
)
4,update then file:$oracle_home/network/admin/tsnames.ora
tg4msql =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =lkhuasof-lihj)(PORT = 1521))
)
(CONNECT_DATA =
(SID = tg4msql)
(SERVER = DEDICATED)
)
(HS=OK)
)
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9879835/viewspace-997573/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- SQL in ORACLE and SQL ServerSQLOracleServer
- SQL Server連線SQL Server、SQL Server連線ORACLE 連結伺服器SQLServerOracle伺服器
- SQL Server linked server 連線OracleSQLServerOracle
- SQL Server建立Linked Server訪問OracleSQLServerOracle
- SQL server資料匯入OracleSQLServerOracle
- 從Oracle訪問SQL Server(GATEWAYS)OracleSQLServerGateway
- 如何使用Linked Server連線Oracle與SQL ServerServerOracleSQL
- 從Sql Server遷移資料到OracleSQLServerOracle
- SQL server 與Oracle開發比較SQLServerOracle
- [zt] Oracle與SQL Server的互連OracleSQLServer
- SQL SERVER與ORACLE的資料共享SQLServerOracle
- SQL SERVER和ORACLE的排序問題SQLServerOracle排序
- SQL Server AlwaysOn的Oracle等價技術SQLServerOracle
- Oracle\MS SQL Server Update多表關聯更新OracleSQLServer
- MySql/Oracle和SQL Server的分頁查MySqlOracleServer
- Oracle 和 SQL Server 個別小區別OracleSQLServer
- .NET框架下Oracle到SQL Server遷移框架OracleSQLServer
- Migrate from SQL SERVER to Oracle 10GSQLServerOracle 10g
- ORACLE和SQL SERVER,DB2對比OracleSQLServerDB2
- SQL Server中建Linked Server時首次選Oracle Provider for OLE 導致SQL當機SQLServerOracleIDE
- sql ServerSQLServer
- Oracle Transparent Gateway for SQL Server安裝配置說明OracleGatewaySQLServer
- SQL Server、Oracle中CASE 與COUNT合用計數SQLServerOracle
- Oracle Gateways透明閘道器訪問SQL ServerOracleGatewaySQLServer
- 將應用程式從Sql Server遷移到OracleSQLServerOracle
- oracle 同步sql server 資料,怎麼做啊?OracleSQLServer
- SQL SERVER的UPDATE操作比ORACLE快得多SQLServerOracle
- ORACLE RAC 利與弊 SQL SERVER課題研究OracleSQLServer
- SQL Server常用工具——SQL Server Powershell ExtensionsSQLServer
- Oracle 11g的SQL Developer連線SQL Server 2008OracleSQLDeveloperServer
- 怎樣把Oracle查詢轉換為SQL ServerOracleSQLServer
- SQL Server通過dblink訪問Oracle資料SQLServerOracle
- 資料庫對比SQL SERVER 、 ORACLE、DB2資料庫SQLServerOracleDB2
- oracle透過透明閘道器訪問sql serverOracleSQLServer
- sql server with ...as 用法SQLServer
- SQL Server raiserrorSQLServerAIError
- SQL Server 鎖SQLServer
- SQL Server OptimizationSQLServer