APPLIES TO:
Oracle Database - Enterprise Edition - Version 11.1.0.7 to 12.1.0.1 [Release 11.1 to 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
SYMPTOMS
In RAC environment if log_archive_config made to null '' on one node then the other node crash with , "ORA-16188". Startup of node 2 alsowill fail with ORA-16188.
-------sample Alert log-----------
In the alert log we are seeing:
WARNING: The 'LOG_ARCHIVE_CONFIG' init.ora parameter settings
are inconsistent with another started instance. This may be
caused by the 'DB_UNIQUE_NAME' init.ora parameter being specified
differently on one or more of the other RAC instances; the
DB_UNIQUE_NAME parameter value MUST be identical for all
instances of the database.
Errors in file /u02/diag/rdbms/<DB UNIQUE NAME>/<SID>/trace/<SID>_lgwr_26567.trc:
ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance
Wed Jul 24 07:07:20 2013
Example,
Alter system set log_archive_config='' scope=both sid='*' Now try to restart the only one node we will get ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with previously started instanceErrors in file /oracle/app/admin/<db unique name>/bdump/<SID>_lgwr_29682.trc:ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with previously started instanceLGWR: terminating instance due to error 16188 and instance will be terminated. ++ Problem is v$dataguard_config is not updated between instances
CAUSE
Incorrect log_Archive_config set.
SOLUTION
In any one of the node,
alter system set log_archive_config=NODG_CONFIG scope=both sid='*';
