今天在查gv$session视图时,出乎意料报了个错:
ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 1 allocated
马上找帮助文档看了下:
Cause: When executing a query on a gv$ fixed view, one or more instances failed to allocate a slave to process query.
Action: Check trace output for instances on which slaves failed to start. GV$ query can only proceed if slaves can be allocated on all
instances.
从上面的解释看来,因为gv$视图是对整个DB的查询,涉及到多个实例,所以每个实例上都要能启动从属进程,现在就是因为某种愿意有些实例上的从属进程不能分配到,导致失败。至于为什么会分配失败,我在网上也查了下,大多都说是oracle的bug,先记下来,以后遇到了这个问题,也好有个思想准备。。。。