Re: SQL*Net problem when using cron.

Check your interactive environment to see is you have a shell variable called TNS_ADMIN.

This is used to override the normal location of tnsnames.ora, etc.

If you are using this interactivly, you will need to specify it in your cron environment.

Michael Rothwell wrote:

> I have an HP UX 10.20 system running Oracle 7.3.4 and
> SQL*Net 2.3.
> When I run a job interactively, all works fine. When I have
> cron kick off the job, it fails with an: ora 12545 error -
> error msg follows:
>
> 12545, 00000, "TNS:name lookup failure"
> // *Cause: A protocol specific ADDRESS parameter cannot be
> resolved.
> // *Action: Ensure the ADDRESS parameters have been entered
> correctly;
> // the most likely incorrect value is the node name.
>
> I set the ORACLE_HOME, PATH and the ORACLE_SID in the job
> and export them. What am I missing here? Why would it run
> interactively but not when kicked off by cron.
>
> Thanks.
>
> Michael
Received on Mon Nov 16 1998 - 18:38:39 CST