Re: linux, crontab & oracle8

Harald Lapp wrote:

> 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

No hardware or operating system information (though I could guess some UNIX), no Oracle version (8.0.3 or 8.1.7.4) or edition, no information on what user id you are using to try to connect, and no copy of the code.

No not really. I have no idea at all.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)