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

     1421 *                                        log_archive_dest_2                       service="<service>", ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections
                                                                                            =1 reopen=300 db_unique_name="<db_unique_name>" net_timeout=30, valid_for=(online_logfile,all_roles)

     1422 *                                        log_archive_dest_3                       service="<service>", ASYNC NOAFFIRM delay=0 optional compression=enable max_failure=0 max_connections
                                                                                            =1 reopen=300 db_unique_name="<db_unique_name>" net_timeout=300, valid_for=(online_logfile,all_roles)

     1423 *                                        log_archive_dest_4                       service="<service>", ASYNC NOAFFIRM delay=0 optional compression=enable max_failure=0 max_connections

New setting ( Remove ",").

* log_archive_dest_2 service="<service>", ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name="<db_unique_name>" net_timeout=300 valid_for=(online_logfile,all_roles)
* log_archive_dest_3 service="<service>", ASYNC NOAFFIRM delay=0 optional compression=enable max_failure=0 max_connections=1 reopen=300 db_unique_name="<db_unique_name>" net_timeout=300 valid_for=(online_logfile,all_roles)
* log_archive_dest_4 service="<service>", ASYNC NOAFFIRM delay=0 optional compression=enable max_failure=0 max_connections=1 reopen=300 db_unique_name="<db_unique_name" net_timeout=300 valid_for=(online_logfile,all_roles)

Re-run the DBUA