Hi @HAN WU ,
First, you need to download the ODAC Runtime Downloads from this link: https://www.oracle.com/technetwork/topics/dotnet/downloads/odacdeploy-4242173.html
The second step. run the CMD as administator and run : install.bat oledb c:\oracle odac
The third step, in the system environment variable, add "C: \ oracle C: \ oracle \ bin" to the Path first and restart your SQL Server.
The fourth step, you got the and pls set the Allow in-process, in the propertites.
The fifth step, choose this choice.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment"