ORA-39070: Unable to open the log file. (in RAC/ASM)

Cause : In ASM directory impdp/expdp are not able to create log file.

Solution: Create directory in file system and use this for log file directories.


[oracle@sbldcdb01 ~]$ impdp system/pass directory=DUMPDIR dumpfile=CBSDB_BODAY080816-%U.dmp logfile=impCBSDB_BODAY080816.log parallel=4 remap_schema=CBSDB_BODAY:CBSDB_RAC transform=oid:n

Import: Release 11.2.0.4.0 - Production on Wed Aug 24 12:43:34 2016

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, 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


[oracle@sbldcdb01 ~]$ PWD
-bash: PWD: command not found
[oracle@sbldcdb01 ~]$
[oracle@sbldcdb01 ~]$ pwd
/home/oracle
[oracle@sbldcdb01 ~]$
[oracle@sbldcdb01 ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.4.0 Production on Wed Aug 24 12:46:19 2016

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> CREATE OR REPLACE DIRECTORY
LOGPDIR AS
'/home/oracle/';
  2    3
Directory created.

SQL> GRANT READ, WRITE ON DIRECTORY LOGPDIR TO PUBLIC;

Grant succeeded.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
[oracle@sbldcdb01 ~]$ impdp system/pass directory=DUMPDIR dumpfile=CBSDB_BODAY080816-%U.dmp logfile=LOGPDIR:impCBSDB_BODAY080816.log parallel=4 remap_schema=CBSDB_BODAY:CBSDB_RAC transform=oid:n

Import: Release 11.2.0.4.0 - Production on Wed Aug 24 12:47:31 2016

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_FULL_03" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_03":  system/******** directory=DUMPDIR dumpfile=CBSDB_BODAY080816-%U.dmp logfile=LOGPDIR:impCBSDB_BODAY080816.log parallel=4 remap_schema=CBSDB_BODAY:CBSDB_RAC transform=oid:n
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
Processing object type SCHEMA_EXPORT/DB_LINK
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE