PRCR-1001 : Resource ora.orcl.db does not e.
1、1：srvctl status database -d orcl 启动两个节点数据库
数据库文件存放在DATADG中。DATADG处于mounted状忌铲态
[oracle@node2 ~]$ srvctl status database -d orcl
PRCD-1120 : The resource for database orcl could not be found.
PRCR-1001 : Resource ora.orcl.db does not exist
2、2：向OCR中添加一个驼荡数据库
[oracle@node2 ~]$ srvctl add database -d orcl -o /u01/app/11.2.0.4/oracle/ -p +datadg/orcl/spfileorcl.ora
如果在添加过程发现错误可以删除：
[oracle@node2 ~]$ srvctl remove database -d orcl
Remove the database orcl? (y/[n]) y
3、3：查看OCR中数据库信息
[oracle@node2 ~]$ srvctl config database -d orcl
[oracle@node2 ~]$ srvctl config database -d orcl
Database unique name: orcl
Database name:
Oracle home: /u01/app/11.2.0.4/oracle/
Oracle user: oracle
Spfile: +datadg/orcl/spfileorcl.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: orcl
Database instances:
Disk Groups: DATADG
Mount point paths:
Services:
Type: RAC
Database is administrator managed
此时Database instances 是空的篇欧驾
查看
4、4：向OCR中添加数据库的实例
[oracle@node2 ~]$ srvctl add instance -d orcl -i orcl2 -n node2
[oracle@node2 ~]$ srvctl add instance -d orcl -i orcl1 -n node1
PRCD-1051 : Failed to add instance to database orcl
PRCS-1011 : Failed to modify server pool orcl
PRCS-1014 : Server node1 is already part of server pool orcl
这个时候发现添加实例orcl1添加失败
查看server pool orcl：
[oracle@node2 ~]$ srvctl config serverpool
Server pool name: Free
Importance: 0, Min: 0, Max: -1
Candidate server names:
Server pool name: Generic
Importance: 0, Min: 0, Max: -1
Candidate server names: node2,node1
[grid@node2 ~]$ crsctl status server
NAME=node1
STATE=ONLINE
NAME=node2
STATE=ONLINE
[grid@node2 ~]$ crsctl status serverpool -p
NAME=Free
IMPORTANCE=0
MIN_SIZE=0
MAX_SIZE=-1
SERVER_NAMES=
PARENT_POOLS=
EXCLUSIVE_POOLS=
ACL=owner:grid:rwx,pgrp:oinstall:rwx,other::r-x
NAME=Generic
IMPORTANCE=0
MIN_SIZE=0
MAX_SIZE=-1
SERVER_NAMES=node2 node1
PARENT_POOLS=
EXCLUSIVE_POOLS=
ACL=owner:grid:r-x,pgrp:oinstall:r-x,other::r-x
NAME=ora.orcl
IMPORTANCE=0
MIN_SIZE=0
MAX_SIZE=-1
SERVER_NAMES=node2 node1
PARENT_POOLS=Generic
EXCLUSIVE_POOLS=
ACL=owner:oracle:rwx,pgrp:oinstall:rwx,other::r--
5、5：启动数据库
[oracle@node2 ~]$ srvctl start database -d orcl
[oracle@node1 ~]$ srvctl status database -d orcl
Instance orcl2 is running on node node2
启动数据库，发现只有节点2的实例启动了
[grid@node2 ~]$ srvctl config database -d orcl
Database unique name: orcl
Database name:
Oracle home: /u01/app/11.2.0.4/oracle/
Oracle user: oracle
Spfile: +datadg/orcl/spfileorcl.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: orcl
Database instances: orcl2
Disk Groups: DATADG
Mount point paths:
Services:
Type: RAC
Database is administrator managed
只有实例orcl2
下面步骤是解决办法
6、6：停止数据库，删除实例orcl2
[oracle@node2 ~]$ srvctl stop database -d orcl
[oracle@node2 ~]$ srvctl status database -d orcl
Instance orcl2 is not running on node node2
[oracle@node2 ~]$ srvctl remove instance -d orcl -i orcl2
Remove instance from the database orcl? (y/[n]) y
[oracle@node2 ~]$ srvctl config database -d orcl
Database unique name: orcl
Database name:
Oracle home: /u01/app/11.2.0.4/oracle/
Oracle user: oracle
Spfile: +datadg/orcl/spfileorcl.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: orcl
Database instances:
Disk Groups: DATADG
Mount point paths:
Services:
Type: RAC
Database is administrator managed
7、7：按顺序向OCR中添加数据库的实例
[oracle@node2 ~]$ srvctl add instance -d orcl -i orcl1 -n node1
[oracle@node2 ~]$ srvctl add instance -d orcl -i orcl2 -n node2
[oracle@node2 ~]$ srvctl config database -d orcl
Database unique name: orcl
Database name:
Oracle home: /u01/app/11.2.0.4/oracle/
Oracle user: oracle
Spfile: +datadg/orcl/spfileorcl.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: orcl
Database instances: orcl1,orcl2
Disk Groups: DATADG
Mount point paths:
Services:
Type: RAC
Database is administrator managed
[oracle@node2 ~]$ srvctl start database -d orcl
[oracle@node2 ~]$ srvctl status database -d orcl
Instance orcl1 is running on node node1
Instance orcl2 is running on node node2
按顺序添加之后，通过srvctl启动数据库，两节点实例都正常启动
