Coming in 5 years later. For people who are having the.

Cannot obtain the required interface 
("IID_IDBSchemaRowset") from OLE DB provider 
"OraOLEDB.Oracle"

Server Objects --> Linked Servers --> Providers...