SQL*Net problem when using cron.

From: Michael Rothwell <michael_rothwell_at_non-hp-usa-om46.om.hp.com>
Date: Mon, 16 Nov 1998 14:20:10 -0800
Message-ID: <3650A51A.6FE66577@non-hp-usa-om46.om.hp.com>

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 - 16:20:10 CST