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.

No comments:

Post a Comment