![]() Subsequently, export was performed successfully. I modified my command and explicitly specified log file to be created on local file system pointed to by the directory object DATA_PUMP_DIR. Since directory parameter points to a shared location on an ASM disk group and log file is not supported on it, I received the above error. The error message indicates that Log file cannot be opened. With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,ĭata Mining and Real Application Testing options All rights reserved.Ĭonnected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production Issued the command to export SH schema in parallel across all active Oracle RAC instances with parallelism = 6 which resulted in error root]$ expdp schemas=sh directory=dp_shared_dir parallel=6 cluster=y dumpfile='expsh%U.dmp' reuse_dumpfiles=yĮxport: Release 11.2.0.3.0 - Production on Tue Dec 8 14:45:39 2015Ĭopyright (c) 1982, 2011, Oracle and/or its affiliates.SQL>grant read, write on directory dp_shared_dir to public SQL>create directory DP_SHARED_DIR as '+DATA/orcl/' Created a directory object pointing to shared storage which is accessible by all the three instances of the database. ![]() Number of nodes : 3 (host01, host02, host03) I received this error message when I was trying to perform a data pump export of SH schema in parallel in a RAC database. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |