Site icon IT Tutorial

ORA-16188 terminating the instance due to ORA error 16188 LOG_ARCHIVE_CONFIG

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

To Solve this error, set log_archive_config=NODG_CONFIG in any node of RAC instance then startup the RAC instance.
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>
Now startup the instance which is not started because of this error as follows, Instance will be startup.
[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>

Do you want to learn more details about SRVCTL, then Click this Link and read the articles.

What is the SRVCTL and Useful SRVCTL Commands in Oracle RAC

Exit mobile version