引用LOG_ARCHIVE_DEST_n参数引起的ORA-16024报错

刘泽宇

数据库SPFILE文件中使用了LOG_ARCHIVE_DEST_n参数，可能会引起数据库出现ORA-16024: parameter log_archive_dest_1 cannot be parsed的报错造成出现ORA-16024报错的原因包括：
等号位置错误、属性无法识别或属性缺少所需值（参见文档 ID:96278.1）
处理方法有：
1.Ensure that /u01/oracle/arch is a valid directory and that Oracle has write permissions there.
确保oracle用户对目录拥有写的权限

2.Remove the spaces on either side of the '=' sign.
You cannot have as space on either side on the '=' sign after 'location'.
Note that the word 'location' can be in either upper or lower case.
log_archive_dest_1 = 'location=/u01/oracle/arch'
去掉'='两边可能存在的空格，location后接=不能有任何空格存在，并且location统一大写或者小写

3.Make sure that there is no trailing /.
确保参数后没有接有/

4.Make sure that LOG_ARCHIVE_DEST is not set in the init.ora.
These 2 parameters are not compatible with each other.
确保没有在init.ora文件中设置LOG_ARCHIVE_DEST参数

NOTE:
The error ORA-16024 could also be encountered when an SPFILE is used, for instance when upgrading a database.
To prevent that, you can remove the log_archive_dest from spfile by issuing
SQL> alter system reset log_archive_dest scope=spfile;
当使用SPFILE的数据库实例进行升级时，也可能会遇到ORA-16024的报错，可以通过移除SPFILE文件中的log_archive_dest参数来处理

5.If still not working set the LOG_ARCHIVE_DEST_n parameter to a null value: LOG_ARCHIVE_DEST_n=''
如果上述的方法依然没有解决，将LOG_ARCHIVE_DEST_n设置为空值