Transparent Gateway Configuration method

To delete Oracle database methods completely:
1, Start-> Settings-> Control Panel-> Management Tools-> Services
Stop all Oracle Services.
2. Start-> Program->oracle-orahome81->oracle installation products->universal Installer
Uninstall all Oracle Products
3, run regedit, select Hkey_local_machine/software/oracle, press del key to delete this entry.
4, run regedit, select hkey_local_machine/system/currentcontrolset/services, scroll this list, delete all Oracle portals
5, from the desktop, startup (startup) Group, program menu, delete all the Oracle-related groups and icons
6. Restart the computer to completely remove Oracle's directory after reboot
7, delete the Oracle-related files, select the default directory c:/oracle Oracle, delete this entry directory and all subdirectories,
and delete the following files from the Windows 2000 directory (typically C:/winnt)
ORACLE. INI, Oradim80. Ini
8, WIN. INI file, delete the segment if there is a tag segment in the [ORACLE]

Oracle2sqlserver Transparent Gateway configuration steps:
1, installation oracle:oracle9i Database9.2.0.1.0
1 The installation must choose a custom, and then select Oracle Transparent Gateway for Microsoft SQL Server 9.2.0.1.0;
2 The post installation must create a database (no use, but seems to be related to starting listener)

2. Install SQL Server
1 need to create a database (such as JGPT)
2 requires a login account (such as SA SA)
The above two conditions need to be used when creating a database link statement later
3, in the file E:/oracle/ora92/tg4msql/admin/inittg4msql.ora configuration as follows:
hs_fds_connect_info= "Server=192.168.57.6;database=jgpt"
Hs_fds_trace_level=off
Hs_fds_recovery_account=recover
Hs_fds_recovery_pwd=recover
4. Modify the Oracle installation directory on the Transparent gateway server (a transparent gateway installed computer), such as e:/oracle/ora92/network/admin/files: Listener.ora, add the following in Sid_list:
(Sid_desc =
(Sid_name = tg4msql)
(Oracle_home = e:/oracle/ora92)
(program = tg4msql)
)
5. The Oracle installation directory on Oracle Server (Oracle Servers computer), such as the Tnsnames.ora of files under d:/oracle/ora92/network/admin/, is added as follows:
JGPT =
(DESCRIPTION =
(Address_list =
(address = (PROTOCOL = TCP) (HOST = 192.168.57.6) (PORT = 1521))
)
(Connect_data =
(SID = tg4msql)
)
(HS = OK)
)

6. Restart Oracle database servers (such as Oracle on 192.168.57.1) and Oracleorahome92tnslistener (Listener services on computers installed on transparent gateways)
7, now create a database link on Oracle server (can be executed in Toad) statement as follows:
Create DATABASE link jgpt connect to SA identified by SA using ' jgpt ';
The link that is created is displayed in DB links in Toad, and the right mouse button executes the test
8, testing
SELECT * FROM Sgqyjbqkb@jgpt

Note: A transparent gateway configuration should pay attention to the problem:
  1, transparent gateway computer must start Oracleorahome92tnslistener (if the computer user name is Chinese, then can not start, you must manually modify the file e:/oracle/ Ora92/network/admin/listener.ora, change the garbled text to the corresponding Chinese)
  2, such as Toad Frog link is not on, because the network service is not added.
    Add steps: Start/program/oracle-orahome92/configuration and Migration tools/net Manager
     Start Selection: Service name/point to the left of the plus ammonium twist
  3, such as still unable to link to see if the listener service is started, whether the Oracle database server z start