Harald Lapp <h.lapp_at_biering.de> wrote in message news:<ba2h9i$obtvr$1_at_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
how about ORACLE_HOME?
Received on Fri May 16 2003 - 16:57:47 CDT
