SQL Server :Link Server Test connection fail

Issue:
I have created a link server in MS SQL server.
Connect to database with "windows  Auhtentication"  - Connection successful
Conneect to database server with " SQL server Auhtentication -  Test connection fail

most proabably you will get an error like below


Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" for linked server "YourLinkServerName". (Microsoft SQL Server, Error: 7302)

Solution : 
Enable "Allow inprocess" to "OraOLEDB.Oracle"

How to do this
---------

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


tick Enable "Allow inprocess"

make sure you have link server using this provider