Hi @Anne ,
When you see this ORA-12560 error on Windows, you need to check these two things before anything else.
1.Make sure the windows service is up and running
2.Make sure your ORACLE_SID is set to the instance name you’re trying to connect to.
3.If either one or two are not correct you will get the error as seen below.
Please refer to the following links:
How to Fix ORA-12560: TNS: Protocol Adapter Error
How to fix OLE DB connection error while connecting Oracle database using SSIS.
Best regards,
Mona
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.