Minor issues with the installation and configuration of Oracle transparent gateway

1. For details about how to install the Oracle transparent gateway, see http://space.itpub.net/6517/viewspace-145560. The main process is: install the software, configure the tg4msql connection parameters, configure the listener and service name, and configure the local service name.
2. Most error-prone:
1) configure the tg4msql connection parameters. If an error occurs, the SQL-related error is displayed during the connection;
2) Tnsname. ora: If no (HS = sidxx), the following error is displayed:

Error is located in row 1st:

ORA-28546: Connection initialization failure may be a net8 management error

ORA-02068: The following serious errors stem fromOracle_ SQL

ORA-03113: End of file for communication channel

Reference http://www.frontoracle.com/oracle-database/507/398507-help-configuring-transparent-gateway.html

The correct statement is as follows:

(CONNECT_DATA =
(SID = tg4msql)
)

(HS = tg4msql)

3) Pay attention to the correct user name and password when creating dblink; otherwise, an SQL connection error will be prompted (this error is clear)

Other good references:

Http://blog.csdn.net/tangnf/archive/2007/05/25/1626112.aspx