SQL Server establishes Oracle's link server

--Establish a database linked server
EXEC sp_addlinkedserver
@server =n ' testoracle ',--the linked server alias to create
@srvproduct =n ' Oracle ',--product name
@provider =n ' oraoledb.oracle ',--ole DB driver name
@datasrc =n '
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.1) (PORT = 1521))
)
(Connect_data =
(service_name = test)
)
)
'--Data source Oracle "ora10g" network "admin" Tnsnames.ora view

EXEC sp_addlinkedsrvlogin
' Testoracle ',--established linked server name
' False ',--fixed */
NULL,--write user name for each user logging on to SQL Server using this linked server */
' Testoracle ',--account (Oracle)
' Testoracle '--Password

SQL Server establishes Oracle's link server