I am trying to schedule a cron job to execute a script.
This script is to run the oracle exp tool, this is the script (bkp):
/usr/users/oracle/bin/exp parfile=/usr/users/oracle/scripts/backup.ctl
-------contents of backup.ctl-----
system/xxxxx file=/usr/users/oracle/bkp/expdba_desenv.bkp full=n
owner=dba_dsi
grants=y indexes=y constraints=y rows=y
log=/usr/users/oracle/bkp/expdba.log
---------------------------------------------
So i gave the full path to the exp command and the backup.ctl.
and i am receiving the following mail message from the cron deamon:
Export: Release 7.1.4.1.1 - Production on Wed Mar 25 14:30:01 1998
Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
EXP-00008: ORACLE error 12545 encountered
ORA-12545: TNS:name lookup failure
EXP-00222:
System error message 2
EXP-00000: Export terminated unsuccessfully
...comprimindo arquivo exportado, aguarde.....
/usr/users/oracle/bkp/expdba_desenv.bkp: No such file or directory
OK.....
---------------------------x-----------------------------
What it is?
Thanks Andre V. Maciel
Received on Thu Mar 26 1998 - 12:08:20 NZST