Re: Pro*C and cron

rstewart_at_bio.ri.ccf.org (Ron Stewart) wrote:
>I'm having a problem with a pro*c program running under cron in a Solaris 2.3
>environment. The pro c program works fine when run from the command line. But from
>cron, it blows up when it tries to connect to the Oracle database. I get a message:
>
>ORA-12546: Unable to open message file (SQL-02113)
>
>This message indicates a problem with privileges. We're new to using pro c here. Has
>anyone experienced and gotten around this?

This is the message you get when your Oracle environment variables arent't set up correctly. One of crons weaknesses is that it tends not to bother to set the environment up before doing what you ask it to do. Try writing a sh/csh script which explicitly runs all the login scripts and *then* runs the program.

David Rolfe,
SunSoft. Received on Thu Feb 22 1996 - 00:00:00 CET