USE [master]
GO
EXEC master.dbo.sp_addlinkedserver
@server = N'ServerName',
@srvproduct=N'Oracle',
@provider=N'ORAOLEDB.ORACLE',
@datasrc=N'ServerName',
@provstr=N''

EXEC master.dbo.sp_addlinkedsrvlogin
@rmtsrvname=N'ServerName',
@useself=N'False,
@locallogin=NULL,
@rmtuser=N'UserName',
@rmtpassword='UserPassword'
GO