Database - RAC/Scalability (MOSC)

MOSC Banner

impdp 12.1.0.2.0 to RAC 12c db get ORA-06512: at "SYS.UTL_FILE", line 536

edited May 25, 2016 5:14AM in Database - RAC/Scalability (MOSC) 3 commentsAnswered

The RAC 12c db has two nodes. The dump file is located on one node's folder that is not a shared location.

[node1:cdb1206] > impdp user/password@appsrv1 DIRECTORY=DATA_PUMP_DIR_SRV1 schemas=app1 DUMPFILE=expdp_app1_201512132025_01.dump.keep LOGFILE=import_dbo_from_app1_PRD_$(date +%Y%m%d%H%M).log

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

The import 'user' has full access to the directory 'DATA_PUMP_DIR_SRV1'. Then I found out another node [node2] does not have the identical file structure. First I try to add CLUSTER=NO on impdp to ignore other node file checking as below, I get the same error.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center