Oracle® Data Guard Concepts and Administration 11g Release 1 (11.1)
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
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.