标题: DBUA Fails with ORA-16026: Parameter LOG_ARCHIVE_DEST_2 Contains an Invalid A... [打印本页] 作者: 刘泽宇 时间: 4 天前 标题: DBUA Fails with ORA-16026: Parameter LOG_ARCHIVE_DEST_2 Contains an Invalid A... 现象：
Upgrading database from 12.1.0.2 to 12.2.0.1 in data guard environment using DBUA got hung and reporting error
Alert.log :
ORA-16026: parameter LOG_ARCHIVE_DEST_2 contains an invalid attribute value
2019-01-26T15:27:37.696899-05:00
Oracle_Server.log
select count(*) from v$instance
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
ORA-16026: parameter LOG_ARCHIVE_DEST_2 contains an invalid attribute value
原因：
Bug 27941110
处理方法：
Execute the below query and validate the log_archive_dest parameters
SQL> SELECT num, '*' "THREAD#", name, value FROM v$PARAMETER WHERE NUM IN (SELECT num FROM v$parameter WHERE (isdefault = 'FALSE' OR ismodified <> 'FALSE') AND name NOT LIKE 'nls%'
MINUS
SELECT num FROM gv$parameter gvp, gv$instance gvi WHERE num IN (SELECT DISTINCT gvpa.num FROM gv$parameter gvpa, gv$parameter gvpb WHERE gvpa.num = gvpb.num AND gvpa.value <> gvpb.value AND (gvpa.isdefault = 'FALSE' OR gvpa.ismodified <> 'FALSE') AND gvpa.name NOT LIKE 'nls%') AND gvi.inst_id = gvp.inst_id AND (gvp.isdefault = 'FALSE' OR gvp.ismodified <> 'FALSE') AND gvp.name NOT LIKE 'nls%')
UNION
SELECT num, TO_CHAR(thread#) "THREAD#", name, value FROM gv$parameter gvp, gv$instance gvi WHERE num IN (SELECT DISTINCT gvpa.num FROM gv$parameter gvpa, gv$parameter gvpb WHERE gvpa.num = gvpb.num AND gvpa.value <> gvpb.value AND (gvpa.isdefault = 'FALSE' OR gvpa.ismodified <> 'FALSE') AND gvp.name NOT LIKE 'nls%') AND gvi.inst_id = gvp.inst_id AND (gvp.isdefault = 'FALSE' OR gvp.ismodified <> 'FALSE') AND gvp.name NOT LIKE 'nls%' ORDER BY 1, 2;
If the output reports with "," for the log_archive_dest parameters