10g RAC在ASM实例下查询gv$session,会报错ORA-12850；11g RAC中查询正常！！！

最新推荐文章于 2024-10-05 15:25:14 发布

lk_db

最新推荐文章于 2024-10-05 15:25:14 发布

阅读量1.3k

点赞数

CC 4.0 BY-SA版权

分类专栏： Oracle

本文链接：https://blog.youkuaiyun.com/lk_db/article/details/78625494

Oracle 专栏收录该内容

120 篇文章

订阅专栏

本文介绍在Oracle 10g RAC环境下，使用ASM实例查询gv$session表时出现ORA-12850错误的情况，并对比了11gRAC中的正常表现。

10g RAC在ASM实例下查询gv$session,会报错ORA-12850；11g RAC中查询正常！！！

SQL> show parameter instance_name
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
instance_name string +ASM1

/dbbackup@rac1=>+ASM1$sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on 14 12:55:40 2017
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> select count(1) from gv$session where status='ACTIVE';
select count(1) from gv$session where status='ACTIVE'
*
ERROR at line 1:
ORA-12850: Could not allocate slaves on all specified instances: 3 needed, 2
allocated

SQL> select count(1) from v$session;
COUNT(1)
----------
38

SQL> select count(1) from v$session where status ='ACTIVE';
COUNT(1)
----------
23