I got ” ORA-16188 terminating the instance due to ORA error 16188 LOG_ARCHIVE_CONFIG ” error in Oracle database during startup of any instance of RAC Database.
ORA-16188 terminating the instance due to ORA error 16188
Details of error are as follows. We have 8 node instances in the RAC, When I start the Instance on the any node of Cluster, I got this error. I have checked the Alertlog of Database, I have seen the following errors.
Process termination requested for pid 109088 [source = rdbms], [info = 0] [request issued by pid: 127304, uid: 1001]
USER (ospid: 127304): terminating the instance due to ORA error 16188
2021-02-13T19:41:30.490372+03:00
System state dump requested by (instance=1, osid=127304), summary=[abnormal instance termination]. error - 'Instance is terminating.
'
System State dumped to trace file /u01/app/oracle/diag/rdbms/MSDB/MSDB1/trace/MSDB1_diag_108888.trc
2021-02-13T19:41:35.083802+03:00
Dumping diagnostic data in directory=[cdmp_20210213194130], requested by (instance=1, osid=127304), summary=[abnormal instance termination].
2021-02-13T19:41:37.456967+03:00
Instance terminated by USER, pid = 127304
ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with previously
This ORA-16188 error is related with the LOG_ARCHIVE_CONFIG setting of RAC database.
I have reset the log_archive_config parameter, as follows.
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 instance Errors in file /oracle/app/admin/<db unique name>/bdump/<SID>_lgwr_29682.trc:
ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance
LGWR: terminating instance due to error 16188 and instance will be terminated.
++ Problem is v$dataguard_config is not updated between instances
SQL> show parameter log_archive_config NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_config string SQL> SQL> SQL> alter system set log_archive_config=NODG_CONFIG scope=both sid='*'; System altered. SQL> SQL> SQL> SQL> SQL> SQL> show parameter log_archive_config NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_config string NODG_CONFIG SQL> SQL>
[MSDB1]/home/oracle $ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Sat Feb 13 19:54:38 2021 Version 19.8.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE instance started. Total System Global Area 2.1445E+11 bytes Fixed Size 30145368 bytes Variable Size 1.0201E+11 bytes Database Buffers 1.1221E+11 bytes Redo Buffers 207720448 bytes Database mounted. Database opened. SQL>