exec master.dbo.sp_MSset_oledb_prop 'ORAOLEDB.Oracle', N'AllowInProcess', 1
exec master.dbo.sp_MSset_oledb_prop 'ORAOLEDB.Oracle', N'DynamicParameters', 1

exec sp_addlinkedserver N'UT', 'Oracle', 'ORAOLEDB.Oracle', N'//xxx.xxx.xxx.xxx/', N'FetchSize=2000', ''
exec master.dbo.sp_serveroption @server=N'UT', @optname=N'rpc out', @optvalue=N'true'

exec sp_addlinkedsrvlogin @rmtsrvname='UT', @useself=N'FALSE', @rmtuser=N'xxxxxx', @rmtpassword='xxxxxx'

El proveedor OLE DB de 32 bits "ORAOLEDB.Oracle" no se puede cargar en proceso en un servidor SQL Server de 64 bits.

The OLE DB provider of 32 bits "ORAOLEDB.Oracle" can not be loaded on process in a SQL Server of 64 bits.