Sunday, October 18, 2015

Oracle Troubleshooting: Datapump - ORA-39002: invalid operation

Some issue when working  on a datapump on an old machine. It used to work and out of a sudden, I was getting errors.


C:\Windows\system32>expdp bobdb/vmware dumpfile=bobdb.dmp full=n directory=DMPDIR logfile=bobdb.export.log

Export: Release 11.2.0.1.0 - Production on Thu Oct 15 10:16:07 2015

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

UDE-28002: operation generated ORACLE error 28002
ORA-28002: the password will expire within 7 days

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation


C:\Windows\system32>sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Thu Oct 15 10:16:28 2015

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select directory_name, directory_path from dba_directories;

DIRECTORY_NAME
------------------------------
DIRECTORY_PATH
--------------------------------------------------------------------------------
XMLDIR
c:\ade\aime_dadvfm0254\oracle\rdbms\xml

DMPDIR
C:\Users\orcldb\Downloads\bobdb\

DATA_PUMP_DIR
C:\app\orcldb\admin\zig\dpdump\


DIRECTORY_NAME
------------------------------
DIRECTORY_PATH
--------------------------------------------------------------------------------
ORACLE_OCM_CONFIG_DIR
C:\app\orcldb\product\11.2.0\dbhome_2\ccr\state


SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

C:\Windows\system32>

It turned out, entire directory of "C:\Users\orcldb\Downloads\bobdb\" was removed and causing the error. I wish the error would me more intuitive.


Created "bobdb" under download and fixed the issue.

1 comment: