Configuring Oracle Database Gateway for SQL Server

jackytang520

该文章来自Oracle 透明网关安装方便的帮助文档,在这里需要注意，连接sql server2000时，请确认你的sql server2000已经打好SP3,SP4补丁，我因为没打这两个补丁折腾了一个晚上，总是提示sa用户不能登录。
After installing the gateway, perform the following tasks to configure Oracle Database Gateway for SQL Server:

• Configure the Gateway Initialization Parameter File
  
• Configure Oracle Net for the Gateway
  
• Configure the Oracle Database for Gateway Access
  
• Create Database Links
  
• Configure Two-Phase Commit
  
• Create SQL Server Views for Data Dictionary Support
  
• Encrypt Gateway Initialization Parameter Values
  
• Configure the Gateway to Access Multiple SQL Server Databases
  

<div class="sect1">Configure the Gateway Initialization Parameter File

Perform the following tasks to configure the gateway initialization parameter file:

• Choose a System Identifier for the Gateway
  
• Customize the Initialization Parameter File
  

<div class="sect2">Choose a System Identifier for the Gateway

The gateway system identifier (SID) is an alphanumeric character string that identifies a gateway instance. You need one gateway instance, and therefore one gateway SID, for each SQL Server database you are accessing. The SID is used as part of the file name for the initialization parameter file. The default SID is dg4msql.
You can define a gateway SID, but using the default of dg4msql is easier because you do not need to change the initialization parameter file name. However, if you want to access two SQL Server databases, you need two gateway SIDs, one for each instance of the gateway. If you have only one SQL Server database and want to access it sometimes with one set of gateway parameter settings, and other times with different gateway parameter settings, then you will need multiple gateway SIDs for the single SQL Server database.