References
Oracle® Data Guard Concepts and Administration 11g Release 1 (11.1)
Overview
Because I had set up TDE in
11G OCM Create and Manage encrypted tablespaces
, I had to copy the Wallet from
BANKSTOWN
to
PADSTOW
.
Support for Transparent Data Encryption (TDE) says that:
To translate encrypted redo records, SQL Apply must have access to an open wallet containing the Transparent Data Encryption keys. Therefore, you must copy the wallet containing the keys from the primary database to the standby database after it has been created
Procedure
Set Up Wallet on PADSTOW
Using the zip file sent from
BANKSTOWN
, a duplicate wallet is created on
PADSTOW
after I had zipped the contents on
BANKSTOWN
:
[oracle@padstow ~]$ mkdir -p $ORACLE_BASE/admin/$ORACLE_SID/wallet [oracle@padstow ~]$ mv wallet.zip $ORACLE_BASE/admin/$ORACLE_SID/wallet/ [oracle@padstow ~]$ cd $ORACLE_BASE/admin/$ORACLE_SID/wallet/ [oracle@padstow wallet]$ unzip wallet.zip Archive: wallet.zip extracting: cwallet.sso extracting: ewallet.p12 [oracle@padstow wallet]$ rm wallet.zip [oracle@padstow wallet]$ pwd /u01/app/oracle/admin/example1/wallet
Create System Default Location
Create the System Default Location directory to stop
owm
complainig:
[oracle@padstow wallet]$ sudo mkdir -p /etc/ORACLE/WALLETS/oracle [oracle@padstow wallet]$ sudo chown -R oracle:oinstall /etc/ORACLE
Verify Wallet Using OWM
I used
owm
to verify that I could open the new wallet.