My Oracle Support Banner

ORA-27369: job of type EXECUTABLE failed with exit code: Incorrect function. STANDARD_ERROR="'expdp' is not recognized as an internal or external command (Doc ID 1913344.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 01-Mar-2017***

Goal

TEST_EXPDP.bat windows batch file contains below entry to use export datapump using expdp 

expdp 'sys/****@testdb1 as sysdba' directory=datapump1 dumpfile='EXP_test.dmp' logfile='EXP_test.log' full=y

Following error when scheduled the expdp backup in DBMS_SCHEDULER

ORA-12012: error on auto execute of job "SYS"."EXPORT_DATAPUMP_JOB1"
ORA-27369: job of type EXECUTABLE failed with exit code: Incorrect function.
STANDARD_ERROR="'expdp' is not recognized as an internal or external command,
operable program or batch file."

When batchfile executed outside the scheduler, it works fine

C:\Users\sscoradba>C:\windows\system32\cmd.exe /c I:\EXPDP\TEST_EXPDP.bat


C:\Users\sscoradba>expdp 'sys/****@testdb1 as sysdba' directory=datapump1 dumpfile='EXP_test.dmp' logfile='EXP_test.log' full=y

Export: Release 11.2.0.3.0 - Production on Wed Jul 30 01:00:29 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYS"."SYS_EXPORT_FULL_14":  "sys/****@testdb1 AS SYSDBA" directory=datapump1 dumpfile='EXP_test.dmp' logfile='EXP_test.log' full=y
Estimate in progress using BLOCKS method...

Processing object type ...
Total estimation using BLOCKS method: 199.7 GB
...
...
. . exported "USER"."TABLE_NAME"            0 KB       0 rows
Master table "SYS"."SYS_EXPORT_FULL_12" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_FULL_12 is:
 P:\EXP_test.DMP
Job "SYS"."SYS_EXPORT_FULL_12" successfully completed at 03:46:56

 

 

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.