Solved: Re: Oracle 10g - 12c upgrade, but TDE wallet issues
From: Lyall Barbour <lyallbarbour_at_sanfranmail.com>
Date: Thu, 19 Nov 2015 19:45:25 +0100
Message-ID: <trinity-d1b6fe0d-c617-4dce-8393-818397f312fc-1447958725371_at_3capp-mailcom-lxa12>
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 19 2015 - 19:45:25 CET
Date: Thu, 19 Nov 2015 19:45:25 +0100
Message-ID: <trinity-d1b6fe0d-c617-4dce-8393-818397f312fc-1447958725371_at_3capp-mailcom-lxa12>
Thanks so much Steven. I actually went down that road until Oracle Support TDE specialist helped me.
Apparently i had the wrong password this whole time since joining the computer. After using the right password and making a Master Key Store for my PDB, things worked fine!
Lyall
Sent: Thursday, November 19, 2015 at 4:51 AM
From: "Stefan Knecht" <knecht.stefan_at_gmail.com>
To: "Lyall Barbour" <lyallbarbour_at_sanfranmail.com>
Cc: oracle-l <oracle-l_at_freelists.org>
Subject: Re: Oracle 10g - 12c upgrade, but TDE wallet issues
From: "Stefan Knecht" <knecht.stefan_at_gmail.com>
To: "Lyall Barbour" <lyallbarbour_at_sanfranmail.com>
Cc: oracle-l <oracle-l_at_freelists.org>
Subject: Re: Oracle 10g - 12c upgrade, but TDE wallet issues
Since you have exported the data, I assume that your dump file is un-encrypted. If not, I would re-export the data without encrypting the dump file.
Then, I would forget about the old 10g wallet, and create a new one on 12c and re-encrypt the data during import? You can do this by pre-creating your tables, make sure what needs to be encrypted, is encrypted, and then just run your import.
Stefan
On Tue, Nov 17, 2015 at 11:34 PM, Lyall Barbour <lyallbarbour_at_sanfranmail.com> wrote:
-- http://www.freelists.org/webpage/oracle-lHi,I'm trying to upgrade a 10g database to 12c. Best way i've learnt to do this is export/import. Trick with this current database is that it has a wallet. I know the password, i can open/close the wallet in the 10g database. I've copied over the sqlnet.ora to the new 12c $TNS_ADMIN directory. I'm using that listener.ora now for the listener. My local_listener parameter is set. querying v$encryption_wallet shows that the 12c container database sees the wallet directory in the sqlnet.ora file.... in other words, everything looks GREAT!except i can't open the dang wallet to have the import run properly. I've used multiple syntax, old ones from 10g and 11g. Plus a new one i've learnt from 12c documents. Any one have any suggestions? OWM never seems to work for me in any version. NOt sure if that's a/the problem.ALTER SYSTEM SET ENCRYPTION KEY AUTHENTICATED BYALTER SYSTEM SET WALLET OPEN IDENTIFIED BYALTER SYSTEM SET ENCRYPTION WALLET OPEN IDENTIFIED BYplus,ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY software_keystore_password [CONTAINER = ALL | CURRENT];constantly (consistently) getting ORA-28353: failed to open walletAny suggestions?Lyall Barbour