Solved

data pump

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that useā€¦
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

680 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