Re: linux, crontab & oracle8

I think you are on the right track by setting the variables.

With all due respect to your ability and background - the biggest possibility I see is that the values of the environment variables did not 'stick'. It is possibly to set the variables in a spawned shell and they do not get reflected in the running cron environment.

You should consider using the "oraenv" or "coraenv" programs to set the variables - probably found in /usr/local/bin/ and invoke it to be 'read into the current shell' rather than spawned. In the Bourne shell & variants, this is done using the . notation eg: ". /usr/local/bin/oraenv". If you do this, preceed that with the two lines:

export ORACLE_SID=xxx # of course, replace xxx with your SID export ORAENV_ASK=NO

You definitely need to verify the the values exist during the life of the process. To check, echo the values to a file immediately before they are used, not immediately after they are set - especially if you happen to set them in a separate script.

It seems your TNSNAMES.ora is set up right - but you still may want to read the Oracle Network Administration manual or the Net8 Administration manual or the SQL*Net Administration manual - whichever is appropriate to your version - for more advice. Received on Fri May 23 2003 - 10:05:48 CDT