Hi @Forbes, Nancy ,
Oracle is really beyond my ability. I found an official link and I hope this can be helpful: https://learn.microsoft.com/en-us/troubleshoot/sql/admin/set-up-troubleshoot-linked-server
And I think you need to check the windows log to see what exactly happened when you open SQL.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment"