error linked server di sql server 2012

tanda-tanda :
- test connection OK
- ketika menjalankan query atau stored proc ada pesan :


Msg 7399, Level 16, State 1, Procedure nama_store_proc, Line 54
The OLE DB provider "OraOLEDB.Oracle" for linked server "nama_linked" reported an error. Access denied.
Msg 7350, Level 16, State 2, Procedure nama_store_proc, Line 54
Cannot get the column information from OLE DB provider "OraOLEDB.Oracle" for linked server "nama_linked".

solusi :
- buka propertis dari Provider yang digunakan, Server Objects - Linked Servers - Providers - klik kanan di provider yang digunakan pilih propertis
- aktifkan tick-mark (enable)  di parameter "Allow in process"
- klik OK
- drop linked server yang error
- create ulang linked server
- coba lagi query atau execute stored procedure