Re: export database error - when run from cron

[Quoted] Assuming the cron job is also run by user oracle,

then you need to add the following to the script file (called by your cron job):

. /etc/profile
. /user_oracle's_default_login_directory/.profile

# then start your EXP call here:

This way all the environment variable's are set properly. When you login to command line, all the envs are properly set, but cron job does not load these envs automatically.

Hope this helps.

Guang

In article <MPG.1426c98e494b77d2989694_at_news.demon.co.uk>,   jkucharski_at_altavista.net (Jan Kucharski) wrote:
> Hi,
>
> when I use unix cron to execute my export
> the foolowing error is displayed:
>
> Message 206 not found; No message file for product=RDBMS,
 facility=EXP:
> Release 8.1.5.0.0 - Production on Mon Sep 11 11:25:01
2000

> (c) Copyright 1999 Oracle
Corpo

> Invalid format of Export utility
name

> Verify that ORACLE_HOME is properly
set

> Export terminated

unsuccessfully

> EXP-00000: Message 0 not found; No message file for product=RDBMS,
> facility=EXP EXP-00222: Message 222 not found; No message file for
> product=RDBMS, facility=EXP
>
> yet when I run it from command line ( interactivelly )
> then the export proceeds ok.
> I am doing this as the user Oracle ( owner of the database ).
> My parfile has
> userid=uname/pass_at_connect_string
>
> and all the files are fully qualified.
>
> What can be the problem ?
>
> Thanks for any answer,
>
> Jan
> jkucharski_at_altavista.net
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Sep 11 2000 - 18:20:35 CEST