Re: Using OS_Authentication in cron jobs

From: Michael Serbanescu <ms_at_cmprime.cis.att.com>
Date: 1996/10/18
Message-ID: <3267DCBE.1BCD@cmprime.cis.att.com>#1/1

Make sure that the cron job was created and is owned by the same UNIX/ORACLE user who executes successfully the shell-cum-sqlplus script from the UNIX command prompt. To do that, log into UNIX as that user and execute "crontab -l".
I suspect that your problem is that the cron job was created by either "root" or "oracle".

I hope this helps.

Michael Serbanescu
Sr. ORACLE DBA, TRECOM Business Systems, Edison, NJ ms_at_cmprime.cis.att.com
(908)576-3894

---

Brad Baker wrote:
>
> I'm looking into using os_authentication for the purposes of running
> cron jobs which run a sql script through sqlplus. When the appropriate
> user invokes the shell script from the unix command prompt, the script
> runs to completion with no errors. However, when the same shell is
> invoked by the cron facility, I receive an invalid username/password
> message. Any ideas as to the possible problem? Has anyone implemented
> a similar setup?
>
> Thanks for any help...
> Brad Baker
Received on Fri Oct 18 1996 - 00:00:00 CDT