Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Wallet install ORA 11G XE problem, Trying to impdp and getting 39189 2835
mstaples@resdat....
post Oct 1 2017, 03:58 PM
Post #1


Newbie
*

Group: Members
Posts: 3
Joined: 1-October 17
Member No.: 52,192



Client is moving off XXXX, an Oracle Cloud app. Client is moving to a new app on SQL Server. Oracle has given me a Data Pump file. Client has no Oracle License so I am trying to load the data into a staging Oracle DB 11g XE version. The DP dump is apparently encrypted. Obviously the client does not want to buy and Oracle license just get to their own data.

ANY IDEAS. This simple little data conversion is becoming a nightmare.
Here are the windows 10 powershell messages.


PS :\oraclexe\app\oracle\oradata\admin\scripts> ./imp1

C:\oraclexe\app\oracle\oradata\admin\scripts>impdp user/pass directory=data_pump_dir dumpfile=fnlexttemp_201603101154_01.dp, fnlexttemp_2016
03101154_02.dp, fnlexttemp_201603101154_03.dp content=metadata_only
tRelease 11.2.0.2.0 - Production on Sun Oct 1 12:50:17 2017

Copyright 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
ORA-39002: invalid operation
ORA-39189: unable to decrypt dump file set
ORA-28365: wallet is not open
Go to the top of the page
 
+Quote Post
boobal_ganesan
post Oct 2 2017, 01:13 AM
Post #2


Advanced Member
***

Group: Members
Posts: 85
Joined: 6-June 16
From: India
Member No.: 51,370



Hello buddy,

Here are few notes on the TDE wallet creation and management,

http://www.dba-oracle.com/t_adv_plsql_tde_keystore.htm


Thank you,
Boobal Ganesan


--------------------
Check out my new Advanced PL/SQL book here - http://www.rampant-books.com/book_1701_pls...initive_ref.htm
Go to the top of the page
 
+Quote Post
burleson
post Oct 2 2017, 07:42 AM
Post #3


Advanced Member
***

Group: Members
Posts: 13,577
Joined: 26-January 04
Member No.: 13



Hi,

There are many ways to get a data pump export file into a text file:

http://www.dba-oracle.com/t_convert_oracle_dmp_file.htm

In your case, I would install the free version of Oracle, import the DMP file, and then use the SQL*Plus spool command with SQL selects to punch the table contents into a flat file:

http://www.dba-oracle.com/t_sqlplus_spool.htm

Also, Mr. Ganesan is correct, your file is encrypted and you must have Oracle wallet.

For example:

Spool mytab.txt

Select col1||' '||col2 from mytab;

Good luck!


--------------------
Hope this helps . . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
mstaples@resdat....
post Oct 5 2017, 07:32 PM
Post #4


Newbie
*

Group: Members
Posts: 3
Joined: 1-October 17
Member No.: 52,192



Guys thanks for the help. I got through the wallet problems by running this command.
alter system set encryption wallet open identified by "passwd";

Now I am getting this. I can't seem to create a master key no matter what I do.

The DP export file has these encryption attributes:

Metadata encrypted = 1
Table data encrypted = 1
Encrypt Mode = Dual

Here is the error.

C:\oraclexe\app\oracle\oradata\admin\scripts>impdp system/taleo directory=data_pump_dir dumpfile=fnlexttemp_201603101154
_01.dp, fnlexttemp_201603101154_02.dp, fnlexttemp_201603101154_03.dp content=metadata_only encryption_password="passwd"

Import: Release 11.2.0.2.0 - Production on Thu Oct 5 11:26:17 2017

Copyright © 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
ORA-39002: invalid operation
ORA-39189: unable to decrypt dump file set
ORA-28362: master key not found

If I understand how this works I need the encryption_password used during the epxdp. At this point Oracle will not give me that???
There is a lot of information out there regarding ORA-28362 but not much that about error with IMPDP

Thanks


Go to the top of the page
 
+Quote Post
burleson
post Oct 6 2017, 09:22 AM
Post #5


Advanced Member
***

Group: Members
Posts: 13,577
Joined: 26-January 04
Member No.: 13



Hi,

A web search found lots of notes on your issue:

http://www.dba-oracle.com/t_ora_28362_mast...y_not_found.htm

And here:

https://sites.google.com/site/oraclepractic...racle-data-pump

It looks like you need to provide the encryption_password from the export.

You should see it in the expdp control file.

Try this query on the source database:

select ts#, masterkeyid, utl_raw.cast_to_varchar2( utl_encode.base64_encode('01'||substr(masterkeyid,1,4))) || utl_raw.cast_to_varchar2( utl_encode.base64_encode(substr(masterkeyid,5,length(masterkeyid)))) masterkeyid_base64
FROM
v$encrypted_tablespaces;

Here is a solution to a lost encryption_password:

https://technology.amis.nl/2013/12/08/where...ibility-in-12c/

Good luck!


--------------------
Hope this helps . . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 23rd October 2017 - 03:46 PM