Shulou(Shulou.com)06/01 Report--

First install the client side of oracle on the sqlserver server:

Configure snooping and tnsnames:

Tnsnames:

D:\ app\ username\ product\ 11.2.0\ client_1\ network\ admin

SCPRDDR =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP) (HOST = X.X.X.X) (PORT = 1521))

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = hrdg)

)

)

Create a read-only user on the oracle server:

Then set the linked server on the sqlserver:

The data source is the SCPRDDR in tnsnames

This user is the read-only user on the oracle server.

Complete the setup.

The linked server was established successfully.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.