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?

Yup! There are several ideas. We could use the answer to some questions first, though ...

1. What OS
2. What version of the OS
3. What version of the database

(1-3 above are generally answered when initially asking the question)

4) Have you spent any time in the Oracle Concepts manual? 5) Does the environment set up the appropriate env vars?

• you say youve added them - are they working right? 6) Do you have any clue about what the oraenv script does? 7) Do you have multiple Oracle Homes? 8) Is the TNS naming support accessible properly from all OH users? 9) Have you read the Oracle Network Administrator's manual?

(4-9 help us understand what level of answer you need) Received on Fri May 16 2003 - 11:45:34 CDT