Solved

data pump

Posted on 2012-03-20
4
814 Views
Last Modified: 2012-06-27
we are running oracle 10g with TDE.  I ran an export on one environment (full data pump export using the encryption parameter)... ran fine

I'm trying to import it into a 'blank' database.  I issued the command to set up the master key/wallet and even copied over the wallet from the originating database.
However, everytime I issue with IMPDP I get the following:

I'm using the same encryption_password parameter and value as I used for the export.

ORA-39001: invalid argument value
ORA-39180: unable to encrypt ENCRYPTION_PASSWORD
ORA-28362: master key not found

Suggestions... i'm obviously missing something.
0
Comment
Question by:sqlnewbie08
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 8

Accepted Solution

by:
Chakravarthi Ayyala earned 500 total points
ID: 37744423
Did you open the wallet using

ALTER SYSTEM SET ENCRYPTION WALLET OPEN IDENTIFIED BY "password";
0
 

Author Comment

by:sqlnewbie08
ID: 37744485
Yes... the wallet was opened.

The export is from QA database. The import is into a DEV database, which is 'blank'.
I'm performing a 'full' export with the excryption password parameter.
I copied over the QA wallet to the proper location on the DEV server.
I then made sure the wallet was open...

The error points to the master key, not the wallet being closed.

As a note (that may make a difference)... initially in this DEV database a wallet was created with a different master key.

I had dropped the schema associated with this set up.

Could that be causing the 'confusion' ???
0
 
LVL 5

Expert Comment

by:Bajwa
ID: 37747678
The error is coming from the expdp encryption command.  and not the database wallet.



Make sure that your impdp encryption_password (imp parfile) is same as expdp encryption_password.
0
 

Author Comment

by:sqlnewbie08
ID: 37747721
The password is exactly the same as was used in the export ..."X"... can get any simpler then that :)
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question