Re: shell script for auto export

On Mon, 25 Jan 1999 4:13:41 +0100, forums.inprise.com wrote (in message <01be4811$bbef0400$374d41d2_at_swa0105-stan->): snip
> Message 206 not found; No message file for product=RDBMS, facility=EXP:
> Release9
>
> Copyright (c) Oracle Corporatio EXP-00008: Message 8 not found; No message
> file for product=RDBMS, facility=EXP Error while trying to retrieve text for

> error ORA-12545 EXP-00222: Message 222 not found; No message file for
> product=RDBMS, facility=EP EXP-00000: Message 0 not found; No message file

> for product=RDBMS, facility=EXPt /mnt/oracle/exp_backup/export.out: No such

> file or directory mv: cannot access /mnt/oracle/exp_backup/export.out.Z
> 01.25.99.export.Z: No such file or directory Interactive mode off.
>
> < File name : backup >
>
> #!/sbin/sh cd /mnt/oracle/exp_backup /mnt/oracle/product/7.3/bin/exp
> system/asetadmin< /mnt/oracle/script/exp_response mv
> /mnt/oracle/exp_backup/export.out /mnt/oracle/exp_backup/export.out compress
> /mnt/oracle/exp_backup/export.out mv /mnt/oracle/exp_backup/export.out.Z
> /mnt/oracle/exp_backup/`date +%m.%d.%y.export.Z`
snip

You should set up your oracle environment completely. Cron does not execute your .profile. In this case you missed ORACLE_HOME (set by oraenv).

#!/usr/ksh
ORACLE_SID=your_sid
ORAENV_ASK=NO
. oraenv
exp userid=x/secret ...

hope this helps
--

Ronald  -  Unix SA               http://home.wxs.nl/~ronr/professional.html

        -  Oracle DBA            http://www.tresco.nl  
        -  Middleware programmer/
                      designer   mailto:R.Rood_at_tresco.nl