The below error is reported by our application team, when they tried to access records from Oracle database using SQL server linked server. I came to know that this was working fine till the last day without issues.
Resolution
1) Checked the Provider properties of OraOLEDB.Oracle and the AllowInprocess
was checked.
2) I had to restart (fail over) the instance to make it functional.
Resolution
1) Checked the Provider properties of OraOLEDB.Oracle and the AllowInprocess
was checked.
2) I had to restart (fail over) the instance to make it functional.
