So I have a script file that is on my agent machine that runs a series of database upgrades. When executing the script manually on the machine, it works fine. When attempting to get Jenkins to run the script, I get ORA-12560: TNS:protocol adapter error.
This was working last week before I configured Jenkins to run as a service, but I am not sure if that has anything to do with it. The Jenkins service is configured to use the localadmin account, the same account I use when running the script manually. Stopping the service and launching the agent connection script via the command line did not fix the issue though.
Is there some configuration I am missing? Our VM server also had maintenance last weekend, but I am not sure why that would break anything.
Update - I think I discovered a workaround for this. I still think the issue has to do with running Jenkins as a service and how something fundamentally is changing. If I try to run my scripts that launch connections to oracle normally, they fail. If I use powershell Invoke-Command -ComputerName agent machine -ScriptBlock {command} this works as expected.
Hopefully this can help anyone who stumbles across this question.