Oracle 11g transparent gateway connects to Sqlserver 2000

Source: Internet
Author: User
Tags mssqlserver


1. The website system of the Environment Company uses IIS + Oracle, but a system of the company uses Sqlserver 2000, but the data needs to be made into reports and put on the website. To simplify programming, use
Oracle is A transparent gateway that regularly captures data from Sqlserver through www.2cto.com A: Web ServerOS: Windows Server 2008IP: 10.108.3.10 install software: IIS, Oracle ClientB: Oralce DB ServerOS: Windows Server 2008IP: 10.108.3.20 Installation Software: Oracle DB, Oracle GatewayC: Sqlserver 2000 DB ServerOS: Windows Server 2003IP: 10.108.5.100 Installation Software: Sqlserver 2000 the installation and configuration of A and C are very simple, let's talk about the configuration of Oracle transparent gateway for machine B www.2cto.com II. Oracle transparent gateway configuration 1. to install the gateway, you must first install our Oracle DB and complete other services. Then install Gateway2. configure E: \ Oracle \ product \ 11.2.0 \ tg_1 \ dg4msql \ admin \ initdg4msql. oraHS_FDS_CONNECT_INFO = [10.108.5.100]. MSSQLSERVER. pwnt
HS_FDS_TRACE_LEVEL = OFF
HS_FDS_RECOVERY_ACCOUNT = RECOVER
HS_FDS_RECOVERY_PWD = RECOVEROracle Gateway in this file, the IP address, Instance name, and database name of sqlserver 2000 are separated by/by default. This setting
An error will be reported later. for separation, OK www.2cto.com # HS_FDS_CONNECT_INFO = [172.21.10.228]/MSSQLSERVER/pwnt3. configure E: \ Oracle \ product \ 11.2.0 \ tg_1 \ NETWORK \ ADMIN \ listener. ora SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = dg4msql)
(ORACLE_HOME = E: \ Oracle \ product \ 11.2.0 \ tg_1)
(PROGRAM = dg4msql)
)
) LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 10.108.3.20) (PORT = 1522 ))
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1522 ))
)
) ADR_BASE_LISTENER = E: \ Oracle \ product \ 11.2.0 \ tg_1 4. Configure E: \ Oracle \ product \ 11.2.0 \ tg_1 \ NETWORK \ ADMIN \ tnsnames. ora dg4msql =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 10.108.3.20) (PORT = 1522 ))
)
(CONNECT_DATA =
(SERVICE_NAME = dg4msql)
)
(HS = OK)
) 5. Configure E: \ Oracle \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN \ listener. ora SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = E: \ Oracle \ product \ 11.2.0 \ dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS = ONLY: E: \ Oracle \ product \ 11.2.0 \ dbhome_1 \ bin \ oraclr11.dll ")
)
# The following are the databases of other services
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = E: \ Oracle \ product \ 11.2.0 \ dbhome_1)
(SID_NAME = ORCL)
)
# The following are the settings of the transparent gateway.
(SID_DESC =
(SID_NAME = dg4msql)
(ORACLE_HOME = E: \ Oracle \ product \ 11.2.0 \ dbhome_1)
(PROGRAM = dg4msql)
)
) LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 10.108.3.20) (PORT = 1521 ))
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521 ))
)
) ADR_BASE_LISTENER = E: \ Oracle www.2cto.com 6. Configure E: \ Oracle \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN \ tnsnames. ora dg4msql =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 10.108.3.20) (PORT = 1522 ))
)
(CONNECT_DATA =
(SERVICE_NAME = dg4msql)
)
(HS = OK)
) Export lr_connection_data =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521 ))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
) Www.2cto.com 7. Create DB link -- Create database link
Create database link PWNT
Connect to sa identified by password
Using 'dg4msql ';

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.