Solved

data pump

Posted on 2012-03-20
4
807 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
  • 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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

792 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