Visit Counter

Wednesday, May 25, 2016

ORA-16024: parameter LOG_ARCHIVE_DEST_1 cannot be parsed



ORA-16024: parameter LOG_ARCHIVE_DEST_1 cannot be parsed 


The cause of this ORA-16024 error is a missing space in the variable declaration.


SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORA-16024: parameter LOG_ARCHIVE_DEST_1 cannot be parsed


ORACLE_HOME/dbs/initoratest.ora
log_archive_dest_1 = 'LOCATION = /ora_dat/ssaerp/archive1'
log_archive_dest_2 = 'LOCATION = /ora_dat/ssaerp/archive2'


I removed space between equal to sign and archive path.


log_archive_dest_1 = 'LOCATION=/ora_dat/ssaerp/archive1'
log_archive_dest_2 = 'LOCATION=/ora_dat/ssaerp/archive2'
 


SQL> startup
ORACLE instance started.

Total System Global Area 9723641856 bytes
Fixed Size                  2189808 bytes
Variable Size            4898952720 bytes
Database Buffers         4261412864 bytes
Redo Buffers              561086464 bytes
Database mounted.
Database opened.