DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, June 20, 2017

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'

No comments: