Heterogeneous Databases (2)

Connect:
Another heterogeneous type of Oracle is the general Gateway (also called transparent gateway)
A better general gateway than a common link is that it can perform heterogeneous data modification and deletion operations, but it needs to install a component (for tran, it is called transparent gateway for sqlserver, other components for Sybase ),
This plug-in was charged in the past, but it is now free of charge. It will not be automatically installed when oracle is installed,
You need to customize the installation. There is a wizard during the installation process. If the installation is successful, the tg4msql directory will be generated under the Oracle main directory ora90,
(1)
Configure the tnsnames. ora file. In the Oracle installation directory, ora92 \ Network \ admin \,
Add
Tg4msql = // The name of a heterogeneous database in Oracle
(Description =
(Address_list =
(Address = (Protocol = TCP) (host = 168.1.1.57) (Port = 1521) // (set the host to the name or address of a heterogeneous database, and keep the rest unchanged)
)
(CONNECT_DATA =
(SID = tg4msql) // be consistent with the SID in the following file
)
(HS = OK) // note this sentence
)
(2)
Configure lisener. ora in the same directory as tnsnames.
Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = plsextproc)
(ORACLE_HOME = c: \ oracle \ ora92)
(Program = EXTPROC)
)
(Sid_desc =
(Global_dbname = cnng)
(ORACLE_HOME = c: \ oracle \ ora92)
(Sid_name = cnng)
)
// Add it here.
)
Add a Section
(Sid_desc =
(Global_dbname = tg4msql
(Sid_name = hs4sql) // consistent with the SID in the TNS File
(ORACLE_HOME = c: \ oracle \ ora92) // copy the existing Oracle Home Directory
(Program = tg4msql) // note this writing method
)

(3)
Copy init. ora to ora92 \ HS \ admin \ and name it inittg4msql. ora (using the SID in init + TNS). If there is no init. ora file,
Create a new text file by yourself, open the file, and add the following code:
Hs_fds_connect_info = erpsql. Tek // erpsql indicates the database server name, and Tek indicates the database name.
Hs_fds_trace_level = off
Save close
(4) restart the oralce listener

The usage is the same as that of common links.
The above content is summed up by yourself by searching for information on the Internet. If there are any errors, please give us some advice and supplement it.