Oracle 12C IMPDP Permissions Issues

Many times, we do a small batch of data migration will use the data pump, but 12C we want to configure TNS to specify the PDB import, but the public service we are through the cluster using SRVCTL to create. At this time preferred instances may have multiple values. If your DMP file is not mounted through shared storage, then DMP must be uploaded to a node to store it for the corresponding directory creation.

Issue-triggered scenario, TNS if this is configured with scan IP at this time, IMPDP username/[email protected] the operating system environment connected to the node is not necessarily the environment where DMP is stored. If you connect to non-DMP storage environment, this time IMPDP will be error.

Problem Solving methods:

1 Modify the connection string TNS, change the scan IP to the designated environment public IP or VIP

2 If the preferred instances dual-value configuration, there is only one value, you can relocate the corresponding sevice to the specified node.

This article is from the ORACLE blog, so be sure to keep this source http://2012ivan.blog.51cto.com/5241776/1976063

Oracle 12C IMPDP Permissions Issues