Thanks for the question, Ashish.
Asked: January 12, 2018 - 9:03 pm UTC
Last updated: January 14, 2018 - 12:13 pm UTC
Version: 11.2.0.4
Viewed 1000+ times
You Asked
I am running a DB 11.2.0.4 (RAC db) that has TDE implemented - Tablespace level.
Source db (11.2.0.4) has TDE implemented.
sqlnet.ora file on each node has the entry ENCRYPTION_WALLET_LOCATION.
Also each node has the wallet and auto login file (they are not sharing.)
Now I am trying to do the database upgrade using DBUA from 11.2.0.4 to 12.1.0.2. (RAC environment)
During the upgrade process -
does the target db (12.1.0.2) sqlnet.ora file on each , also needs the entry or once the upgrade is done, then update the target sqlnet.ora to add the entry ?
The wallet and auto login file location on each node is shared between, 11gR2 and 12cR2 database.
I just want to check whether the target DB , 12.1.0.2 , sqlnet.ora need the ENCRYPTION_WALLET_LOCATION entry
during the upgrade process or once the upgrade is done, then add the ENCRYPTION_WALLET_LOCATION entry in sqlnet.ora file ?
Thanks ,
Ashish
Ashish
and Connor said...
I've passed this question on to the upgrade Product Manager, so I'll do an addenda with his feedback.
But I got this from the (excellent) MOS note 2189854.1
Copying Transparent Encryption Oracle Wallets
If you use Oracle wallet with Transparent Data Encryption (TDE), and you use Database Upgrade Assistant (DBUA) to upgrade the database, then copy thesqlnet.ora and wallet file to the new 12.2 Oracle home.
You must copy the sqlnet.ora and the wallet file manually before starting the upgrade.
1. Log in as an authorized user.
2. Manually copy the sqlnet.ora file, and the wallet file, ewallet.p12, to the new release Oracle home.
3. Open the Oracle wallet in mount.
For example:
SQL> STARTUP MOUNT;
SQL> ALTER SYSTEM SET ENCRYPTION WALLET OPEN;
Is this answer out of date? If it is, please let us know via a Comment