Hi @rajeeec-5608m,
The error message shows ‘The 'OraOLEDB.Oracle.1' provider is not registered on the local machine’.
I did some research online, please make sure you have already installed both 64-bit driver and 2-bit driver ODAC.
Here is an article. for your reference:
Below is the download link for you.
https://www.oracle.com/database/technologies/dotnet-odacmsi-vs2017-downloads.html
https://www.oracle.com/database/technologies/odac-downloads.html
Regards,
Zoe
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
What can I do if my transaction log is full?--- Hot issues November
How to convert Profiler trace into a SQL Server table -- Hot issues November