cp of while over 2Gb works in cron, but not in at

[David_246]

Hi,

I have an issue that a file over a 2Gb gets copied over using "cron", but not using "at".

The user is oracle running $SHELL=/sbin/sh
- On the commandline, no errors when using copy
- In cron, no errors when using copy
-- In at, the same job fails with the following error :

cp: bad copy to file1.dbf: write: File too large

I know already it has something to do with ulimit and Posix shells :)

Question : Does anyone know how to change the standard shell of at, or how to change ulimit of at, so that it will start working.

Regs David

[Michael Schulte zur Sur]

Hi,

create a script:
#!/bin/ksh
copy blabla blabla2

call script with at

greetings,

Michael

[john korterman · Accepted solution]

Hi David,
a workaround for something similar is described in this thread. Please, take a look.

http://www4.itrc.hp.com/service/cki/docDisplay.do?docLocale=en_US&docId=200000062903227

regards,
John K.

[Robert-Jan Goossens]

David,

Europe
http://www5.itrc.hp.com/service/cki/docDisplay.do?docLocale=en_US&docId=200000062903227

US
http://www2.itrc.hp.com/service/cki/docDisplay.do?docLocale=en_US&docId=200000062903227

Document description: Oracle error: "File too large"; db started by at(1) command from OmniBack
Document id: 1200252533

Hope this helps,
Robert-Jan

[mark vosberg]

I had the identical problem copying large files in hpux 11i using at. Changing the script to use ksh did not work. I had to change ulimit to unlimited in the file /var/adm/cron/.proto. Then it worked fine.