ORA-16024: parameter LOG_ARCHIVE_DEST_1 cannot be parsed



SYS@APPLE7DR>startup;



ORA-16024: parameter LOG_ARCHIVE_DEST_1 cannot be parsed





There are 3 issues:


log_archive_dest_1 = ‘LOCATION=/u01/app/oracle/apple/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES)DB_UNIQUE_NAME=appledr’


1.The log_archive_dest_n (log_archive_dest_2) should not end with a “/”


2.The syntax for log_archive_dest_n is:


log_archive_dest_1=’LOCATION=/u01/app/oracle/oradata’
log_archive_dest_2=’LOCATION=/u01/app/oracle/oraarch’


LOCATION= is compulsory.


3.Should be containing a space before db)unique_name:


log_archive_dest_1 = ‘LOCATION=/u01/app/oracle/apple/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=appledr’

  • June 20, 2017 | 16 views
  • Comments