linux, crontab & oracle8

From: Harald Lapp <h.lapp_at_biering.de>
Date: Fri, 16 May 2003 13:18:25 +0200
Message-ID: <ba2h9i$obtvr$1@ID-139340.news.dfncis.de>

hello,

i'm searching for a solution for the following problem:

i've written a script (in php), which fills an oracle database with data. the script will be run automatically by the cron-demon.

when i run the script from commandline (e.g. as user 'foo' everything works fine. but when i install the script as cronjob for this user, the script can't connect to the oracle database, it get's an error 'ORA-12154' which means afaik
'TNS:could not resolve service name'

i thought, that there might be some environment variables, that wheren't set for the specific user, so i've added the env command to the crontab entry and set the variables 'ORACLE_BASE',
'ORACLE_SID' and 'ORA_NLS33', but it still doesn't
work.

does somebody have an idea, what might be wrong?

thanks,
regards
<-harald Received on Fri May 16 2003 - 06:18:25 CDT