CODEWITHSUNDEEP
databaselinuxoracle-databasecron
StevenWang
StevenWang

Reputation: 3826

crontab oracle problem in linux

I created an app which is need to run in linux started by crontab. An error happened when it tried to connect oracle database: it returned SQLO_INVALID_DB_HANDLE. But if started it manually everything is okay.

I bet there are no path-related mistakes here, because everything goes well except the connection to the Oracle database. Oracle8 functions are used in my code.

thanks

Upvotes: 3

Views: 829

Answers (1)

Thilo
Thilo

Reputation: 262754

Oracle uses a couple of environment variables, like ORACLE_HOME, TNS_HOME, ORACLE_SID. They might be missing from your crontab environment.

Upvotes: 4

Related Questions