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 ';