Has anybody seem this error or have an idea where to check to pinpoint the issue? I don't know much about the job other than it connects to a database. It was running before until we upgraded our environment and Oracle.
Here is the error trying to connect to oracle database:
failed: ERROR OCIEnvNlsCreate. Check ORACLE_HOME (Linux) env var or PATH (Windows) and or NLS settings, permissions, etc.
Cannot connect to the database: ERROR OCIEnvNlsCreate. Check ORACLE_HOME (Linux) env var or PATH (Windows) and or NLS settings, permissions, etc.
If you search on that last sentence you'll get to a number of links where people discuss it. Universally the issue seems to be the Perl module DBD :: Oracle not being configured correctly, often due to changing Oracle versions.
Did you update it when you updated your Oracle environment on that machine? If not, then that's what I'd suggest doing. You might want to check http://search.cpan.org/~p...e/Troubleshooting.pm for further Troubleshooting info.