Export Problem

From: Andy Kniveton <kniveton_at_zeus.swindon.rtsg.mot.com>
Date: 12 Mar 1994 13:13:02 GMT
Message-ID: <2lsf4u$5g9_at_zeus.swindon.rtsg.mot.com>

I'm having a problem trying to export our database via cron using the following in the crontab file :-

[17] % crontab -l

00 06 * * * /usr/oracle/bin/exp PARFILE=/usr/database/oracle/dbs/arch/6AM.par
00 14 * * * /usr/oracle/bin/exp PARFILE=/usr/database/oracle/dbs/arch/2PM.par
00 22 * * * /usr/oracle/bin/exp PARFILE=/usr/database/oracle/dbs/arch/10PM.par

[18] %

The PARFILE for the 6 AM dump reads :-

[20] % more /usr/database/oracle/dbs/arch/6AM.par
SYSTEM/*******
BUFFER=4096
FILE=/usr/database/oracle/dbs/arch/6AM.dmp LOG=/usr/database/oracle/dbs/arch/6AM.dmp.log FULL=Y
[21] %

When the backup is run via cron the 6AM.dmp.log read :-
[21] % more /usr/database/oracle/dbs/arch/6AM.dmp.log

EXP-00008: ORACLE error 12545 encountered
ORA-12545: TNS:name lookup failure
EXP-00222:

System error message
EXP-00000: Export terminated unsuccessfully
[22] %

Any idea what errors mean, if I type in the following at the prompt the export works ok :-

/usr/oracle/bin/exp PARFILE=/usr/database/oracle/dbs/arch/6AM.par

oerr ora 12545
12545, 00000, "TNS:name lookup failure"

// *Cause: A protocol specific ADDRESS parameter cannot be resolved.
// *Action: Ensure the ADDRESS parameters have been entered correctly,
// in particular, the node name.

Andy.

--
  _ _ /|  	Andy Kniveton,	Tel No	+44 793 545349
  \'o.O'  	Motorola Ltd,	Fax No	+44 793 541228
  =(___)= 	16 Euro Way,	E-mail	kniveton_at_zeus.swindon.rtsg.mot.com
     U    	Blagrove, Swindon,
		England, SN5 8YQ.

"Additional: Our biggest enemy is going space crazy through loneliness. The 
only thing that helps me maintain my slender grip on reality is the friendship
I share with my collection of singing potatoes." Holly Red Dwarf II, Queeg

Received on Sat Mar 12 1994 - 14:13:02 CET