Re: Problem with Cron to access oracle

Hi Johnny,

        Your problem is that the account you are running cron from (probably root) doesn't have $ORACLE_HOME/bin in the path. Ask your Unix system administrator for assistance in solving the problem. There are several alternatives and due to security issues the solution has to be one acceptable to the local administrator.

regards

Jerry

Johnny Tjokro wrote:
>
> Hi ..
> I am expecting to run stored_procedure in ORACLE using cronjob and I
> have to use cronjob. I am not allowed to used DBMS_JOB.
>
> I have Korn-shell script that have no problem running manually.
> But, when I put my Korn Shell script in the Cron. It got problem.
>
> My Korn Shell script's name is : daily.ksh
>
> When I excecute this script from Unix prompt:
> $ daily.ksh
> It works just fine.
>
> daily.ksh
>
> #!/bin/ksh
> #
> #
> umask 0
>
> sqlplus user_at_database_name/paswd
> set serveroutput on;
> execute sp_daily;
> exit;
> EOF
>
> -------
>
> However, when I put it in Cron,
>
> crontab -l
> 0 17 * * 1-5 /export/home/daily.ksh
>
> It gives me message : sqlplus not found.
>
> Any help would be appreciated. Thank you very much.

--

Jerry Gitomer         	ICT Group
jgitomer_at_ictgroup.com	Langhorne PA
jgitomer_at_yahoo.com 	Opinions are mine not those of ICT Group