Database can't be started on Node 1 due to serverpool Max value is 1

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_db
PRCC-1014 : rig7_db was already running
PRCR-1004 : Resource ora.rig7_db.db is already running
PRCR-1079 : Failed to start resource ora.rig7_db.db
CRS-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_pool
Server pool name: rig7_svr_pool
Importance: 0, Min: 0, Max: 1
Category: hub
Candidate server names:
racusr@itqe-t4seville-1-ld1:~$ srvctl status serverpool -serverpool rig7_svr_pool
Server pool name: rig7_svr_pool
Active 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 2
racusr@itqe-t4seville-1-ld1:~$ srvctl status database -db rig7_db
Instance rig7db_1 is running on node itqe-t4seville-2-ld1
Instance rig7db_2 is running on node itqe-t4seville-1-ld1