Oracle11RAC中配置资源自动启动
来源:互联网 发布:易观是什么软件 编辑:程序博客网 时间:2024/06/17 19:09
How to set auto start resources in 11G RAC
Changing Resource Attributes in 11gR2 Grid Infrastructure
In 11gR2 grid infrastructure installations certain resources may have auto start set to never and restore. This was observed both on environments where clusterware was upgraded to 11.2 as well as newly installed environments. Depending on the situation these may not be desirable. Auto start attribute setting could be changed as follows.
1. Check the current auto start values
# crsctl stat res -p
NAME=ora.FLASH.dg
TYPE=ora.diskgroup.type
ACL=owner:oracle:rwx,pgrp:oinstall:rwx,other::r--
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
ALIAS_NAME=
AUTO_START=never
NAME=ora.DATA.dg
TYPE=ora.diskgroup.type
ACL=owner:oracle:rwx,pgrp:oinstall:rwx,other::r--
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
ALIAS_NAME=
AUTO_START=never
NAME=ora.clusdb.db
TYPE=ora.database.type
ACL=owner:oracle:rwx,pgrp:oinstall:rwx,other::r--
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=
ACTIVE_PLACEMENT=1
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
AUTO_START=restore
2. Since ASM diskgroup that database depend on will never auto start database will also be unavailable.
3. Change the resource start attribute with
# crsctl modify resource "ora.FLASH.dg" -attr "AUTO_START=always"
# crsctl modify resource "ora.DATA.dg" -attr "AUTO_START=always"
# crsctl modify resource ora.clusdb.db -attr "AUTO_START=always"
Auto start must be upper case if not command will fail
crsctl modify resource ora.clusdb.db -attr "auto_start=always"
CRS-0160: The attribute 'auto_start' is not supported in this resource type.
CRS-4000: Command Modify failed, or completed with errors.
4. Verify the status change with
# crsctl stat res -p
NAME=ora.clusdb.db
TYPE=ora.database.type
ACL=owner:oracle:rwx,pgrp:oinstall:rwx,other::r--
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=
ACTIVE_PLACEMENT=1
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
AUTO_START=always
转载自:http://oracleracdba1.wordpress.com/2013/01/29/how-to-set-auto-start-resources-in-11g-rac/
Changing Resource Attributes in 11gR2 Grid Infrastructure
In 11gR2 grid infrastructure installations certain resources may have auto start set to never and restore. This was observed both on environments where clusterware was upgraded to 11.2 as well as newly installed environments. Depending on the situation these may not be desirable. Auto start attribute setting could be changed as follows.
1. Check the current auto start values
# crsctl stat res -p
NAME=ora.FLASH.dg
TYPE=ora.diskgroup.type
ACL=owner:oracle:rwx,pgrp:oinstall:rwx,other::r--
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
ALIAS_NAME=
AUTO_START=never
NAME=ora.DATA.dg
TYPE=ora.diskgroup.type
ACL=owner:oracle:rwx,pgrp:oinstall:rwx,other::r--
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
ALIAS_NAME=
AUTO_START=never
NAME=ora.clusdb.db
TYPE=ora.database.type
ACL=owner:oracle:rwx,pgrp:oinstall:rwx,other::r--
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=
ACTIVE_PLACEMENT=1
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
AUTO_START=restore
2. Since ASM diskgroup that database depend on will never auto start database will also be unavailable.
3. Change the resource start attribute with
# crsctl modify resource "ora.FLASH.dg" -attr "AUTO_START=always"
# crsctl modify resource "ora.DATA.dg" -attr "AUTO_START=always"
# crsctl modify resource ora.clusdb.db -attr "AUTO_START=always"
Auto start must be upper case if not command will fail
crsctl modify resource ora.clusdb.db -attr "auto_start=always"
CRS-0160: The attribute 'auto_start' is not supported in this resource type.
CRS-4000: Command Modify failed, or completed with errors.
4. Verify the status change with
# crsctl stat res -p
NAME=ora.clusdb.db
TYPE=ora.database.type
ACL=owner:oracle:rwx,pgrp:oinstall:rwx,other::r--
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=
ACTIVE_PLACEMENT=1
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
AUTO_START=always
转载自:http://oracleracdba1.wordpress.com/2013/01/29/how-to-set-auto-start-resources-in-11g-rac/
0 0
- Oracle11RAC中配置资源自动启动
- 配置ibus自动启动
- oracle10g自动启动配置
- Red Hat 9中配置tomcat随系统自动启动
- rac 11g 资源自动启动
- 配置JBoss4服务自动启动
- Myeclipse 启动 xml 自动配置
- Mysql 自动启动的配置
- OBIEE SampleAppv406 自动启动配置
- windows配置svn自动启动
- SVN服务端配置自动启动
- Jexus开机自动启动配置
- 一个根据所给资源自动配置CDH中Hadoop等参数的工具
- 一个根据所给资源自动配置CDH中Hadoop等参数的工具
- Maven工程中自动拷贝资源文件的 pom文件配置方法
- JBoss的安装与配置(二)Linux(RedHat4)中JBoss自动启动设置
- Linux/Unix 中如何配置 Oracle Database 随服务器自动启动
- Linux下配置JBoss自动启动
- SCALA 集合框架文档翻译-Concrete Immutable Collection Classes
- 递归遍历路径下所有文件算法
- activiti5第五弹 serviceTask中的webserviceTask 以及 shellTask
- svn安装
- C++11 并发指南六( <atomic> 类型详解二 std::atomic )
- Oracle11RAC中配置资源自动启动
- crontab----定时调用的守护进程
- go---agent 提高访问网站速度的方法
- Android Volley完全解析(一),初识Volley的基本用法
- Oracle11gR2——RAC基本管理命令
- iOS之横竖屏旋转
- 正则表达式
- 底子薄之11.24
- Linux内存分配小结--malloc、brk、mmap