Shulou(Shulou.com)05/31 Report--

This article is about what to do with ORA-12850 error in oracle. Xiaobian thinks it is quite practical, so share it with everyone for reference. Let's follow Xiaobian and have a look.

1. problem phenomenon

The error message is as follows:

Thu Aug 24 10:01:33 2017

Errors in file /oradata/diag/rdbms/cdb/cdb2/trace/cdb2_m000_3564.trc:

ORA-12850: Unable to assign slave processes on all specified instances: 2 required, 1 assigned

trace file partial output Output:

*** 2017-08-24 10:01:33.324

*** SESSION ID:(1390.13783) 2017-08-24 10:01:33.324

*** CLIENT ID:() 2017-08-24 10:01:33.324

*** SERVICE NAME:(SYS$BACKGROUND) 2017-08-24 10:01:33.324

*** MODULE NAME:(MMON_SLAVE) 2017-08-24 10:01:33.324

*** CLIENT DRIVER:() 2017-08-24 10:01:33.324

*** ACTION NAME:(Automatic Report Flush) 2017-08-24 10:01:33.324

*** CONTAINER ID:(1) 2017-08-24 10:01:33.324

2. Error analysis

Two articles were found in mos that matched this error.

ORA-12850 is Raised by Mmon Slave Automatic Report Flush Action (File ID 2217969.1)

High CPU Usage and/or Frequent Occurrence of ORA-12850 For Monitor Queries by MMON From 12.1 (File ID 2102131.1)

The article mentions the causes of the problem:

bug:24554937 ORA-12850 WHILE MMON SLAVE AUTOMATIC REPORT FLUSH ACTION

There is a new feature in 12C called "Automatic Report Capturing Feature". As part of this feature, some monitoring SQLs are executed by MMON_SLAVE to identify the resource-intensive SQLs and generate the SQL Monitoring report automatically for those SQLs. Those SQLs consume little more CPU and it is expected behavior being a new feature. Such monitoring queries can be identified from (G)V$SQLSTATS.

12.1 introduces a new feature called Automatic Report Capturing Feature, where monitoring SQL is executed to collect resource-intensive SQL information and generate SQL Monitoring reports. ORA-12850 is reported when monitoring SQL consumes too much CPU.

3. solutions

The article provides 2 solutions:

1.Apply Patch 24554937 if it is available for your version and platform.

2. Execute the following sql to disable new features

SQL> alter system set "_report_capture_cycle_time"=0;

Thank you for reading! About "Oracle ORA-12850 error how to do" This article is shared here, I hope the above content can be of some help to everyone, so that we can learn more knowledge, if you think the article is good, you can share it to let more people see it!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.