方法1:实施了RAC
SQL> show parameter cluster_database;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database boolean TRUE
cluster_database_instances integer 2
未实施RAC
SQL> show parameter cluster_database;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database boolean FALSE
cluster_database_instances integer 1
CLUSTER_DATABASE is a Real Application Clusters parameter that specifies whether or not Real Application Clusters is enabled.
CLUSTER_DATABASE_INSTANCES
is a Real Application Clusters parameter that specifies the number of instances that are configured as part of your cluster database. You must set this parameter for every instance. Normally you should set this parameter to the number of instances in your Real Application Clusters environment. A proper setting for this parameter can improve memory use.
Oracle uses the value of this parameter to compute the default value of the LARGE_POOL_SIZE
parameter when the PARALLEL_AUTOMATIC_TUNING
parameter is set to true
. Note that the PARALLEL_AUTOMATIC_TUNIG
parameter has been deprecated.
方法2:select * from v$option WHERE Parameter = 'Real Application Clusters';
Output:True/False
V$OPTION
displays Oracle Database options and features. Typically, although not always, options must be separately licensed, whereas features come with the product and are enabled based on the product that is running (Standard Edition, Enterprise Edition, and so on).
方法3:
SELECT * from v$active_instances;
Output
INST_NUMBER INST_NAME
1 xyzdb1:abprod1
2 xyzdb2:abprod2
V$ACTIVE_INSTANCES displays the mapping between instance names and instance numbers for all instances that have the database currently mounted.
分享到:
相关推荐
生产环境下oracle 11G RAC实施方案,希望能够给大家带来帮助!
oracle rac 规划实施方案,里面详细介绍每一步的具体过程,其中是以虚拟机为实验环境
1,Oracle19c RAC+ RACDG配置详细部署文档 2,Oracle19c RAC+ RACDG+racdg2配置详细部署文档 涉及主库备库参数配置、spfile、crs资源配置更新及实施过程中故障排除等; 来自于现实上亿级生产系统的实操记录。
oracle11g RAC实施手册
基于Oracle RAC 双活方案实施,如何规避脑裂风险- 最佳实践.docx
本文档详细介绍了Oracle 11gR2 RAC 数据库在华为云上实施步骤。包括CentOS 6和7版本之间安装的差异
最详细的AIX Oracle 10g RAC实施文档,一册在手学习安装无忧!
本文档为基于Oracle 12C RAC的实施标准化流程,包含RAC搭建的施工过程,其中数据迁移略过。
1、solaris10 u11系统安装, 2、oracle 11G RAC安装实施管理文档
oracle 10g RAC实施手册,讲解实施过程中的问题和步骤
Oracle RAC数据库安装实施文档,有centos7安装时候错误的解决方案。
检测是否安装了hangcheck模块 [root@rac1]# find /lib/modules -name "hangcheck-timer.ko" /lib/modules/2.6.9-42.ELsmp/kernel/drivers/char/hangcheck-timer.ko 设置模块为自动加载 su – echo "options ...
Oracle 11gR2 RAC 安装部署学习,OCP必经之路,小白的傻瓜式操作部署
生产环境非常详细的ORACLE RAC 安装部署系统集成实施方案文档
此外,它还突出了您在实施OracleRAC项目过程中可能会犯的错误,并提供了避免这些错误的建议。尽管这篇文章侧重于OracleRAC,但下列步骤对许多种Oracle实施项目均试用。(注意,本指南仅用于提供信息,无论在何种情形...
oracle 10g RAC 实施指南,部署RAC详细文档。
详细的Oracle10g RAC + DataGuard 实施步骤
Oracle RAC ASM Datagurad 项目实施
OracleRAC部署实施PPT课件.pptx