ORA-06512: at "SYS.UTL_FILE", line 536

DataPump Export (EXPDP) Raises Errors ORA-39002 ORA-39070 ORA-29283 ORA-6512 On RAC Instance (Doc ID 1317798.1)


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

CAUSE

You used the sqlnet identifier (@<db>) while performing export using expdp. On RAC, the connection was routed to another instance where there was not enough permissions on mentioned directory.

SOLUTION

1. Use a local directory as /tmp. The file will then get created in /tmp of another instance.

- OR -

2. Do not use the sqlnet identifier while performing export on a RAC instance.

- OR -

3. Use next workaround:
    - Create a tnsnames.ora in $HOME of the particular OS user
    - Insert the instance specific entry
    - Set the parameter TNS_ADMIN at session level to point to the new tnsnames.ora for the particular OS user who performs the export.