Thank you Issue resolve Allow In Process:

Issue:

The OLE DB provider "OraOLEDB.Oracle" for linked server "TEST" reported an error. Access denied.

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