代码改变世界

ORA-12850 需要重启对应的pdb才生效

2019-08-05 11:00  WWJD_DBA  阅读(1133)  评论(0编辑  收藏  举报
select con_id,inst_id,event#,event,count(*) from gv$session where wait_class#<>6 and event NOT LIKE 'SQL*N%' group by con_id,inst_id,event#,event order by 5
                                                 *
ERROR at line 1:
ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 1 allocated

NAME                                                         DESCRIPTION                                                            VALUE                                    ISDEFAULT  ISMODIFIED ISADJUSTED
------------------------------------------------------------ ---------------------------------------------------------------------- ---------------------------------------- ---------- ---------- ----------
_report_capture_cycle_time                                   Time (in sec) between two cycles of report capture daemon              60                                       TRUE       false      false

--节点1执行
alter system set "_report_capture_cycle_time"=0;

--节点1 alert
Mon Aug 05 10:50:33 2019
ALTER SYSTEM SET _report_capture_cycle_time=0 SCOPE=BOTH;

NAME                                                         DESCRIPTION                                                            VALUE                                    ISDEFAULT  ISMODIFIED ISADJUSTED
------------------------------------------------------------ ---------------------------------------------------------------------- ---------------------------------------- ---------- ---------- ----------
_report_capture_cycle_time                                   Time (in sec) between two cycles of report capture daemon              0                                        TRUE       system_mod false

show1 _param _report_capture_cycle_time