All geek questions in one place

Crontab oracle problem in linux

I created an application that needs to be run on linux running crontab. An error occurred while trying to connect to the oracle database: it returned SQLO_INVALID_DB_HANDLE. But if you start it manually, everything will be fine.

I am sure there are no path related errors because everything is going well except connecting to the Oracle database. Oracle8 functions are used in my code.

thank

+3
source share
1 answer

Oracle uses a couple of environment variables such as ORACLE_HOME, TNS_HOME, ORACLE_SID. They may not be available in your crontab environment.

+4
source

Source: https://habr.com/ru/post/1731838/

More articles:


All Articles