When I add an Oracle server as a Linked Server in SQL Server 2008 Management Studio, I can only see a database named 'default', and none of the other DB's on the server. Using Microsoft OLD DB Provider for Oracle or Oracle Provider for OLE DB--same result.
I map my local login to the remote user for the Oracle server, so it should not be a permissions issue.
Thanks for any ideas.