Cocould not execute query against ole db Provider 'oraoledb. Oracle'

Cocould not execute query against ole db Provider 'oraoledb. Oracle'

This error occurs when I use openquery to query the linked server on SQL Server. The linked server connects to Oracle DB.
However, the table and view information can be seen on the linked server, but cannot be seen using openquery, and is also normal on other machines, but not on the local machine.

Later, I found a solution because the resume linked server does not set allow in process in the provider option.
Check this setting to enable openquery.

Note: The current situation is that if the previously established linked server has not set this attribute, this problem will occur. Once a linked server is set, then you don't have to pay attention to this.

Location