Configuration listening for Oracle 10g transparent gateway accessing SQL Server 2000

Oracle 10g transparent gatewayAccessSQL Server 2000The configuration and listener startup and configuration are what we will introduce in this article. Next we will introduce them one by one.

I. Configure the environment

Oracle 10 Gb is installed on Windows 2003 server of 192.168.0.250: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0-64bit Production)

SQL Server 2000 is installed on Window 2003 server at 192.168.0.233.

2. Download the transparent GATEWAY)

Oracle 10g, transparent network management is a separate component, you can go to the Oracle official website to download http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/winsoft.html, this installation package has 300 m. Unfortunately, we only find the xiuming gateway version: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-32bit Production.

3. Install transparent gateway

Install the transparent gateway on the SQL server. Click setup.exe to start the installation interface and install oracle transparent gateway for microsoft SQL server. Next, enter the sqlserver address and sqlserver database name. Here, you can enter the correct one, you can also enter it at will or leave it blank. After installation is complete, configure it again. After installation, the configuration listening page is displayed. Click Cancel. The installation process is similar to DB installation or client installation.

Iv. Configure the transparent gateway parameter file

Find the transparent gateway path: D: \ oracle \ product \ 10.2.0 \ tg_1 \ tg4msql \ admin. A default parameter file: inittg4msql is generated when the transparent gateway is installed. ora, whose sid is tg4mssql. You can use this file or create a new file. COPY is named initUFDATA_002_2009.ora. It is recommended that the name be the same as that of the SQL SERVER database. Note the format: init <sid>. ora, which can be understood as the oracle parameter file. Now, edit the parameter file:

 
 

  
  
# 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.233;DATABASE =UFDATA_002_2009" 
  
  
HS_FDS_TRACE_LEVEL=OFF 
  
  
HS_FDS_RECOVERY_ACCOUNT=RECOVER  
  
  
HS_FDS_RECOVERY_PWD=RECOVER 
 
 

HS_FDS_CONNECT_INFO has multiple formats, such as: HS_FDS_CONNECT_INFO = server_name.db_name. However, server_name cannot be an IP address and the port must be 1433 by default, for example: if you set the server and database to the above format when installing the transparent gateway.

5. Configure listeners on the transparent gateway Server

Find the path D: \ oracle \ product \ 10.2.0 \ tg_1 \ NETWORK \ ADMIN \ listen er. ora where the listener file is located. These configurations are similar to DB configurations.

 
 

  
  
# listener.ora Network Configuration File: d:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listen er.ora 　  
  
  
# Generated by Oracle configuration tools.  
  
  
SID_LIST_LISTENER = 　  
  
  
(SID_LIST = 　  
  
  
(SID_DESC = 　  
  
  
(SID_NAME = PLSExtProc) 　  
  
  
(ORACLE_HOME = d:\oracle\product\10.2.0\db_1) 　  
  
  
(PROGRAM = extproc) 　  
  
  
) 　  
  
  
(SID_DESC= 　  
  
  
(SID_NAME=UFDATA_002_2009)  
  
  
(ORACLE_HOME=D:\oracle\product\10.2.0\tg_1) 　  
  
  
(PROGRAM=tg4msql) 　  
  
  
) 　  
  
  
)  
 
 

SID_Name corresponds to the parameter file name initUFDATA_002_2009.ora, And the PROGRAMN must be tg4msql

6. Start the listener

The configuration of the start listener is the same as that of the DB. In the CMD command, enter lsnrctl start

 
 

  
  
C: \ Documents ents and Settings \ rocky> lsnrctl start
  
  
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0-Production on-2009 21:57:56
  
  
Copyright (c) 1991,200 5, Oracle. All rights reserved.
  
  
Start tnslsnr: Please wait...
  
  
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0-Production
  
  
The system parameter file is D: \ oracle \ product \ 10.2.0 \ tg_1 \ network \ admin \ listen er. ora.
  
  
Write the log information of D: \ oracle \ product \ 10.2.0 \ tg_1 \ network \ log \ listener. log
  
  
Listener:
  
  
(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = fcserver .winbo4x4.com) (PORT = 1521 )))
  
  
Connecting to (ADDRESS = (PROTOCOL = tcp) (HOST =) (PORT = 1521 ))
  
  
Listener status ------------------------ alias LISTENER
  
  
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0-Production
  
  
Start Date:-2009 21:57:58
  
  
Normal operation time 0 days 0 hours 0 minutes 1 second
  
  
Tracking level off
  
  
Security ON: Local OS Authentication
  
  
SNMP OFF
  
  
Listener parameter file D: \ oracle \ product \ 10.2.0 \ tg_1 \ network \ admin \ listen er. ora
  
  
Listener log file D: \ oracle \ product \ 10.2.0 \ tg_1 \ network \ log \ listener. log
  
  
Listener endpoint overview...
  
  
(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = fcserver .winbo4x4.com) (PORT = 1521 )))
  
  
Service summary. The service "PLSExtProc" contains one routine.
  
  
Routine "PLSExtProc", status UNKNOWN, contains one handler of this service... the service "UFDATA_002_2009" contains one routine.
  
  
Routine "UFDATA_002_2009", status UNKNOWN, contains one handler of this service...
  
  
Command executed successfully
 
 

You can see that UFDATA_002_2009 has registered the static listening service.

Generate the OracleOraTg10g_home1TNSListener service in the Service (if the transparent gateway is on the DB database machine, there are more than N Listener services, you can stop other Listener services, directly in the transparent Listener)

View the Listener status:

 
 

  
  
C: \ Documents ents and Settings \ rocky> lsnrctl status
  
  
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0-Production on-2009 21:58:06
  
  
Copyright (c) 1991,200 5, Oracle. All rights reserved.
  
  
Connecting to (ADDRESS = (PROTOCOL = tcp) (HOST =) (PORT = 1521 ))
  
  
Listener status ------------------------
  
  
Alias LISTENER
  
  
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0-Production
  
  
Start Date: 2009-21:57:58 normal running time: 0 days, 0 hours, 0 minutes 9 seconds
  
  
Tracking level off
  
  
Security ON: Local OS Authentication SNMP OFF
  
  
Listener parameter file D: \ oracle \ product \ 10.2.0 \ tg_1 \ network \ admin \ listen er. ora
  
  
Listener log file D: \ oracle \ product \ 10.2.0 \ tg_1 \ network \ log \ listener. log
  
  
Listener endpoint overview...
  
  
(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = fcserver .winbo4x4.com) (PORT = 1521 )))
  
  
Service summary. The service "PLSExtProc" contains one routine.
  
  
Routine "PLSExtProc", status UNKNOWN, contains one handler of this service... the service "UFDATA_002_2009" contains one routine.
  
  
Routine "UFDATA_002_2009", status UNKNOWN, contains one handler of this service...
  
  
Command executed successfully
 
 

The configuration for Oracle 10g transparent gateway to access SQL Server 2000 is introduced here. I hope this introduction will be helpful to you! Next Introduction: Oracle 10g transparent gateway accesses SQL Server 2000 to create a DB Link.

Source: http://blog.csdn.net/rockywu/archive/2009/06/04/42. aspx.