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
作者:wwjd365 WWJD_DBA
出处:http://www.cnblogs.com/wwjd365/
本文版权归作者和博客园共有,欢迎转载,但未经作者同意必须保留此段声明,且在文章页面明显位置给出原文连接,否则保留追究法律责任的权利。