Shulou(Shulou.com)06/01 Report--

In many cases, we use data pumps to migrate small batches of data, but at 12C we need to configure TNS to specify PDB imports, while Volkswagen's service is created through clusters using srvctl. At this point, preferred instances may have multiple values. If your dmp file is not mounted through shared storage, then the DMP must be transferred to a node for storage and directory creation.

In the scenario triggered by the problem, if TNS is configured using SCAN IP at this time, the operating system environment in which impdp username/passwd@TNS is connected to the node may not necessarily be the environment where dmp is stored. If you connect to a non-dmp storage environment, the impdp will report an error.

Solution to the problem:

1 modify the connection string TNS to replace the SCAN IP with the specified environment PUBLIC IP or VIP

2 if the preferred instances is not a dual-active dual-value configuration, there is only one value, and the corresponding sevice relocate can be transferred to the specified node.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.