PRCR-1001 : Resource ora.orcl.db does not exist
環境：RAC oracle 11.2.0.4，有兩個節點：node1和node2
現象：在啟動集群之後，執行節點 srvctl status database -d orcl啟動報錯
解決步驟：
1：srvctl status database -d orcl 啟動兩個節點數據庫
2：向OCR中添加一個數據庫
3：查看OCR中數據庫信息
4：向OCR中添加數據庫的實例
5：啟動數據庫
6：停止數據庫，刪除實例orcl2
7：按順序向OCR中添加數據庫的實例
方法/步驟
1：srvctl status database -d orcl 啟動兩個節點數據庫
數據庫文件存放在DATADG中。DATADG處於mounted狀態
[[email protected] ~]$ 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：向OCR中添加一個數據庫
[[email protected] ~]$ srvctl add database -d orcl -o /u01/app/11.2.0.4/oracle/ -p +datadg/orcl/spfileorcl.ora
如果在添加過程發現錯誤可以刪除：
[[email protected] ~]$ srvctl remove database -d orcl
Remove the database orcl? (y/[n]) y
3：查看OCR中數據庫信息
[[email protected] ~]$ srvctl config database -d orcl
[[email protected] ~]$ 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：向OCR中添加數據庫的實例
[[email protected] ~]$ srvctl add instance -d orcl -i orcl2 -n node2
[[email protected] ~]$ 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：
[[email protected] ~]$ 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
[[email protected] ~]$ crsctl status server
NAME=node1
STATE=ONLINE
NAME=node2
STATE=ONLINE
[[email protected] ~]$ 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：啟動數據庫
[[email protected] ~]$ srvctl start database -d orcl
[[email protected] ~]$ srvctl status database -d orcl
Instance orcl2 is running on node node2
啟動數據庫，發現只有節點2的實例啟動了
[[email protected] ~]$ 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：停止數據庫，刪除實例orcl2
[[email protected] ~]$ srvctl stop database -d orcl
[[email protected] ~]$ srvctl status database -d orcl
Instance orcl2 is not running on node node2
[[email protected] ~]$ srvctl remove instance -d orcl -i orcl2
Remove instance from the database orcl? (y/[n]) y
[[email protected] ~]$ 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：按順序向OCR中添加數據庫的實例
[[email protected] ~]$ srvctl add instance -d orcl -i orcl1 -n node1
[[email protected] ~]$ srvctl add instance -d orcl -i orcl2 -n node2
[[email protected] ~]$ 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
[[email protected] ~]$ srvctl start database -d orcl
[[email protected] ~]$ srvctl status database -d orcl
Instance orcl1 is running on node node1
Instance orcl2 is running on node node2
按順序添加之後，通過srvctl啟動數據庫，兩節點實例都正常啟動
