Link server that adds oracle as SQL Server

1. Execute sp_addmediaserver in the query Analyzer

 
Use master

Go

Exec sp_addmediaserver

@ Server = 'ralph. lanstart', -- Name of the Oracle linked server

@ Srvproduct = 'oracle ', -- fixed

@ Provider = ''msdaora '', -- fixed

@ Datasrc = ''ralphlink'' -- server alias in net8 (Network Service name)

 

2. In Enterprise Manager

 

Security --- link server --- Oracle chain name (Ralph. lanstart)

--- Right-click to display the Property dialog --- Security Tab

The image of this topic is as follows:

3. How to reference data on an oracle linked server

Select * From openquery ([Ralph. lanstart], 'select * From SYS. ralph_test ')
-- Select * from [([Ralph. lanstart]... sys. ralph_test (table name writing)