Hi,
I am not ruling out this is a DB config thing, but when I use the Real Time SQL Monitor in EA2 I can consistently generate the following alert log error:
ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated
Error occurs immedialy when I open a SQL Monitor window. DB is a 2 node RAC cluster 12.1.0.2 with the April PSU.
Any ideas/suggestions?
I have seen notes: Doc ID 1503358.1 and Doc ID 1945816.1 among others and they do not seem applicable.
Trace File Header:
*** 2016-12-23 10:50:23.292
*** SESSION ID:(1526.19319) 2016-12-23 10:50:23.292
*** CLIENT ID:() 2016-12-23 10:50:23.292
*** SERVICE NAME:(<service_name>) 2016-12-23 10:50:23.292
*** MODULE NAME:(SQL Developer) 2016-12-23 10:50:23.292
*** CLIENT DRIVER:(jdbcthin : 12.2.0.1.0) 2016-12-23 10:50:23.292
*** ACTION NAME:() 2016-12-23 10:50:23.292
Trace File Entry
ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated Dump of memory from 0x000000109A1A6E80 to 0x000000109A1A70F7 109A1A6E80 48544957 54434120 5F455649 53534553 [WITH ACTIVE_SESS] 109A1A6E90 5F4E4F49 54534948 2059524F 28205341 [ION_HISTORY AS (] 109A1A6EA0 4C455320 20544345 71732E68 64695F6C [ SELECT h.sql_id] 109A1A6EB0 2E68202C 5F6C7173 63657865 2C64695F [, h.sql_exec_id,] 109A1A6EC0 6C766E20 702E6D28 63715F78 2C646973 [ nvl(m.px_qcsid,] 109A1A6ED0 69732E6D 41202964 61622053 735F6573 [m.sid) AS base_s] 109A1A6EE0 202C6469 71732E68 6C705F6C 6C5F6E61 [id, h.sql_plan_l] 109A1A6EF0 5F656E69 202C6469 61732E68 656C706D [ine_id, h.sample] 109A1A6F00 6D69745F 52462065 67204D4F 51532476 [_time FROM gv$SQ] 109A1A6F10 4F4D5F4C 4F54494E 2C6D2052 24766720 [L_MONITOR m, gv$] 109A1A6F20 49544341 535F4556 49535345 485F4E4F [ACTIVE_SESSION_H] 109A1A6F30 4F545349 68205952 45485720 6D204552 [ISTORY h WHERE m] 109A1A6F40 6C71732E 2064695F 2E68203D 5F6C7173 [.sql_id = h.sql_] 109A1A6F50 61206469 6D20646E 6C71732E 6578655F [id and m.sql_exe] 109A1A6F60 64695F63 68203D20 6C71732E 6578655F [c_id = h.sql_exe] 109A1A6F70 64695F63 202C2920 49544341 485F4556 [c_id ), ACTIVE_H] 109A1A6F80 4F545349 535F5952 53544154 20534120 [ISTORY_STATS AS ] 109A1A6F90 45532028 5443454C 6C717320 2C64695F [( SELECT sql_id,] 109A1A6FA0 6C717320 6578655F 64695F63 6162202C [ sql_exec_id, ba] 109A1A6FB0 735F6573 202C6469 5F6C7173 6E616C70 [se_sid, sql_plan] 109A1A6FC0 6E696C5F 64695F65 20534120 6E616C70 [_line_id AS plan] 109A1A6FD0 6E696C5F 64695F65 6F63202C 28746E75 [_line_id, count(] 109A1A6FE0 4120292A 61732053 656C706D 756F635F [*) AS sample_cou] 109A1A6FF0 202C746E 286E696D 706D6173 745F656C [nt, min(sample_t] 109A1A7000 29656D69 20534120 5F6E696D 706D6173 [ime) AS min_samp] 109A1A7010 745F656C 2C656D69 78616D20 6D617328 [le_time, max(sam] 109A1A7020 5F656C70 656D6974 53412029 78616D20 [ple_time) AS max] 109A1A7030 6D61735F 5F656C70 656D6974 4F524620 [_sample_time FRO] 109A1A7040 4341204D 45564954 5345535F 4E4F4953 [M ACTIVE_SESSION] 109A1A7050 5349485F 59524F54 4F524720 42205055 [_HISTORY GROUP B] 109A1A7060 71732059 64695F6C 7173202C 78655F6C [Y sql_id, sql_ex] 109A1A7070 695F6365 62202C64 5F657361 2C646973 [ec_id, base_sid,] 109A1A7080 6C717320 616C705F 696C5F6E 695F656E [ sql_plan_line_i] 109A1A7090 2C292064 4C515320 4E4F4D5F 524F5449 [d ), SQL_MONITOR] 109A1A70A0 4154535F 41205354 20282053 454C4553 [_STATS AS ( SELE] 109A1A70B0 6D205443 6C71732E 2C64695F 732E6D20 [CT m.sql_id, m.s] 109A1A70C0 655F6C71 5F636578 202C6469 61622E6D [ql_exec_id, m.ba] 109A1A70D0 735F6573 202C6469 71732E6D 78655F6C [se_sid, m.sql_ex] 109A1A70E0 735F6365 74726174 2E6D202C 7473616C [ec_start, m.last] 109A1A70F0 6665725F 00736572 [_refres.]