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

 2,558 views last month,  1 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply