Database can't be started on Node 1 due to serverpool Max value is 1
来源:互联网 发布:算法流程图用什么画 编辑:程序博客网 时间:2024/05/19 08:00
Database can't be started on Node 1 due to serverpool Max value is 1
- Problem Description:
racusr@itqe-t4seville-1-ld1:~$ srvctl start database -db rig7_dbPRCC-1014 : rig7_db was already runningPRCR-1004 : Resource ora.rig7_db.db is already runningPRCR-1079 : Failed to start resource ora.rig7_db.dbCRS-5702: Resource 'ora.rig7_db.db' is already running on 'itqe-t4seville-2-ld1'racusr@itqe-t4seville-1-ld1:~$
- 数据库从node 1装的,在node 1 起不来,却在node 2 上是好好的.
- DIAGNOSTIC ANALYSIS:
racusr@itqe-t4seville-1-ld1:~$ srvctl config serverpool -serverpool rig7_svr_poolServer pool name: rig7_svr_poolImportance: 0, Min: 0, Max: 1Category: hubCandidate server names:racusr@itqe-t4seville-1-ld1:~$ srvctl status serverpool -serverpool rig7_svr_poolServer pool name: rig7_svr_poolActive servers count: 1
- 跑在rig7_svr_pool 这个serverpool里面,现在只有一个server,所以就只能起一个instance,所以要扩大serverpool.
- 当Active servers count 为1 的时候,db instance会自动在另外一个节点起来了。
- Solution:
- 用srvctl modify serverpool -serverpool rig7_svr_pool -max 2。修改max之后 ,db instance 会在所有server上自动起来,若是instance在两个节点都在跑,说明DB 已经正常运行了。
eg.racusr@itqe-t4seville-1-ld1:~$ srvctl modify serverpool -serverpool rig7_svr_pool -max 2racusr@itqe-t4seville-1-ld1:~$ srvctl status database -db rig7_dbInstance rig7db_1 is running on node itqe-t4seville-2-ld1Instance rig7db_2 is running on node itqe-t4seville-1-ld1
0 0
- Database can't be started on Node 1 due to serverpool Max value is 1
- DB can't be started due to Memory lack
- EBS form applet can't be started when browser is IE8
- android.database.sqlite.SQLiteException: Can't upgrade read-only database from version 0 to 1:解决
- Access restriction: The type Node is not accessible due to restriction on required library C: \Prog
- [时钟同步]Can't create ASM instance on node2 during running root.sh on node2 due to Time Syc
- Inteface Buidler can't determine the type of "xx.xib" this may be due to a missing SDK.
- mysql:Variable 'character_set_client' can't be set to the value of 'NULL'解决
- Variable ‘time_zone’ can’t be set to the value of ‘NULL’解决方法
- [mysql] 批量导入提示: Variable ‘character_set_client’ can’t be set to the value of ‘NULL
- 关于freemind.main.freemind can't be started
- Can not connect to database! error: Can't connect to MySQL server on 'localhost' (10061) 安装MYSQL时的问
- Optional int parameter 'folderId' is not present but cannot be translated into a null value due to b
- Optional int parameter 'id' is present but cannot be translated into a null value due to being decla
- Optional int parameter 'page' is present but cannot be translated into a null value due to being dec
- Optional int parameter 'version' is present but cannot be translated into a null value due to being
- Optional int parameter 'id' is present but cannot be translated into a null value due to being decla
- Optional int parameter 'rip' is present but cannot be translated into a null value due to being decl
- Eclipse如何导入一个已有的javaproject
- LightOJ1030-Discovering Gold-dp
- hdu 1573 X问题 水题 一元线性同余方程组
- css和js的浏览器兼容问题汇总
- How To Build CyanogenMod For Huawei Honor 5X ("kiwi")
- Database can't be started on Node 1 due to serverpool Max value is 1
- 文章标题
- Filter(过滤器)与Interceptor(拦截器)的区别
- setTimeout,clearTimeout与setInterval,clearInterval
- 含正方形的不规则数独的对称美感
- 二叉搜索树
- windows消息分类
- android进程常驻、保活研究
- No asm ,database instances after DB re-installation