ORA-02097: parameter cannot be modified because specified value is invalid-ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE
Cause:
When try setting up FRA, the below error is triggered due to size not specified
SQL> alter system set db_recovery_file_dest='/data01';
alter system set db_recovery_file_dest='/data01'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE
Workaround:
Specify the FRA size and set FRA location then
SQL> alter system set db_recovery_file_dest_size=5G;
System altered.
SQL> alter system set db_recovery_file_dest='/data01';
System altered.