Scheduler Job Misleading error ORA-27369 Cannot Allocate Memory instead of zip error: Nothing to do! (Doc ID 1535218.1)

Last updated on MARCH 07, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 12.1.0.1.0 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

On :  11.2.0.3 version, RDBMS

the following error occurs from Scheduler Job.

ERROR
-----------------------
ORA-27369: job of type EXECUTABLE failed with exit code: Cannot allocate memory

Changes

 exec create_host_command_job_args('"/oracle/data/usage/HostScripts/zip" -m -j -r -7 -q "/oracle/data/usage/dummy.txt.zip" "/oracle/data/usage/dummy"',1);

this zips and moves (deletes source) all files in the directory /oracle/data/usage/dummy to /oracle/data/usage/dumm.txt.zip

if /oracle/data/usage/dummy is not empty, the created job and the zip command succeeds.

if /oracle/data/usage/dummy is empty (contains no files) or does not exists, then I get the "cannot allocate memory error".

If you run the command '"/oracle/data/usage/HostScripts/zip" -m -j -r -7 -q "/oracle/data/usage/dummy.txt.zip" "/oracle/data/usage/dummy" directly in a terminal window when /oracle/data/usage/dummy is empty then I get the following reply:

zip error: Nothing to do! (try: zip -m -j -r -7 -q /oracle/data/usage/dummy.txt.zip . -i /oracle/data/usage/dummy)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms