oracle查询链接服务器,从SQL Server2008 R2中的链接服务器(Oracle)运行查询

我在SQL Server 2008中设置了链接服务器.但我无法对链接服务器运行任何查询.

我试图运行这个简单的命令,但它不起作用

SELECT * FROM MYSERVER..ALANH.TEMP_UPDATE1

这是我运行上面命令时得到的错误.

Msg 7399, Level 16, State 1, Line 1

The OLE DB provider "OraOLEDB.Oracle" for linked server "MYSERVER" reported an error. The provider did not give any information about the error.

Msg 7312, Level 16, State 1, Line 1

Invalid use of schema or catalog for OLE DB provider "OraOLEDB.Oracle" for linked server "MYSERVER". A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema.

任何人都可以帮我连接到OracleLinkedServer吗？非常感谢.