New answers tagged server
Oracle object names are all uppercase by default. The linked-server query must exactly match the case of all referenced Oracle metadata, such as schema and table names.
If you need an Oracle proxy server, then you should investigate Oracle Connection Manager, which is exactly that. See http://docs.oracle.com/cd/B28359_01/network.111/b28316/cman.htm for the documentation on 11gR1's version of it.
Top 50 recent answers are included