OK, so I removed everything else except the ConnectionString part from the config file for the Oracle connections, and now it works both via command line and in my Agent Job (yay!)

Thanks for all your help and your patience! 🙂 Have a great weekend!