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" for linked server "xxx". (Microsoft SQL Server, Error: 7399)