Example 3-8 Setting up Archive Logging and Fast Recovery Area (FRA) Before Using AutoUpgrade

In the following example, your-directory-or-diskgroup is the directory path or disk group where your recovery area is placed. The value for DB_RECOVERY_FILE_DEST_SIZE is specified as 50GB, but you should use the value that you require for your recovery area.

sqlplus / as sysdba 
shutdown immediate;
startup mount;
alter system set db_recovery_file_dest_size = 50g scope=both sid='*'; 
alter system set db_recovery_file_dest ='your-directory-or-diskgroup' scope=both sid='*';
alter database archivelog;
alter database open;
alter pluggable database all open;

Example 3-9 Password Files and Security Password File Updates

During the upgrade, the AutoUpgrade utility copies the password file from the source Oracle Database Oracle home to the target Oracle Database Oracle home. However, the copied password file retains the earlier release password file version. Oracle recommends that you regenerate the password file to update it to the new release password file version.

Example 3-10 Transparent Data Encryption and AutoUpgrade

To enable the AutoUpgrade utility to obtain the privileges required for copying transparent data encryption keystores, you must enable auto-login for these keystores so that AutoUpgrade can copy them to the target release Oracle home. If you do not enable auto-login, then AutoUpgrade cannot complete the upgrade.

In addition, AutoUpgrade looks for the location of the Oracle Net administration directory using the TNS_ADMIN environment variable. If your TNS_ADMIN environment variable is not defined, then the path to the network administration directory defaults to the path Oracle_home/network/admin. If you need to specify a different path, then specify the path in your configuration file using the local configuration parameter source_tns_admin_dir, and if necessary, the target path with target_tns_admin_dir.

Enable an Auto-Login or a Local Auto-Login Software Keystore by using the ADMINISTRATOR KEY MANAGEMENT or SYSKM privilege on your existing keystore. For example, to create an auto-login software keystore of the password-protected keystore that is located in the /etc/ORACLE/WALLETS/orcl directory:

ADMINISTER KEY MANAGEMENT CREATE AUTO_LOGIN KEYSTORE 
FROM KEYSTORE '/etc/ORACLE/WALLETS/tde' 
IDENTIFIED BY password;

keystore altered.