oracle_impdp_aleph_libs doesn't work properly
- Article Type: General
- Product: Aleph
- Product Version: 20
Problem Symptoms:
After running oracle_impdp_aleph_libs the Oracle data is not populated on the target server as it should be.
Cause:
1. a problem with the oracle_impdp_aleph_libs import procedure.
2. a problem with the oracle_expdp_aleph_libs export procedure. It may be that, though the proper dpdir files exist, the oracle_expdp_aleph_libs produced defective files.
Resolution:
For Cause 1: Check the log of the oracle_impdp_aleph_libs to see if it indicates any problem; check the ./xxxnn/files/dpdir directories to see if they have the expected files in them, such as:
-rwxrwxrwx 1 aleph exlibris 72299253 Jan 22 12:56 xxxnn01.dmp.gz*
-rwxrwxrwx 1 oracle dba 781684736 Jan 22 12:56 xxxnn02.dmp*
-rwxrwxrwx 1 oracle dba 4737 Jan 22 12:56 expxxxnn.log*
-rw------- 1 aleph exlibris 46710784 Jan 22 12:57 xxxnn02.dmp.gz
These files should have been produced by the oracle_expdp_aleph_libs and transferred from the source server to the target.
See also Article 000001595 ("Refreshing Test server data Using Oracle Data Pump")
For Cause 2: See Article 000003484 {"Oracle Data Pump doesn't work in UE Create Customer Data step (or otherwise)}
- Article last edited: 4/23/2014