PRCD-1120 : The resource for database RAC could not be found.

最新推荐文章于 2025-02-09 01:18:52 发布

是桃萌萌鸭~

最新推荐文章于 2025-02-09 01:18:52 发布

阅读量641

点赞数 9

CC 4.0 BY-SA版权

文章标签：数据库

本文链接：https://blog.youkuaiyun.com/qq_55914897/article/details/138285669

文章描述了在OracleRAC环境中，发现数据库RACDB未在OCR中注册的问题，给出了数据库注册到OCR的步骤以及如何使用srvctl工具启动和配置数据库。还提到需将实例添加到CRS中。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[oracle@OEL5RACN1 ~]$ srvctl status database -d RACDB -v
PRCD-1120 : The resource for database RACDB could not be found.
PRCR-1001 : Resource ora.rac.db does not exist

This is indicate that Database are not registered in OCR.

Solution : Register database into OCR (database and instances).

[grid@OEL5RACN1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA_01.dg
ONLINE ONLINE oel5racn1
ONLINE ONLINE oel5racn2
ora.FRA_01.dg
ONLINE ONLINE oel5racn1
ONLINE ONLINE oel5racn2
ora.LISTENER.lsnr
ONLINE ONLINE oel5racn1
ONLINE ONLINE oel5racn2
ora.OCRS_FILES.dg
ONLINE ONLINE oel5racn1
ONLINE ONLINE oel5racn2
ora.asm
ONLINE ONLINE oel5racn1 Started
ONLINE ONLINE oel5racn2 Started
ora.eons
ONLINE ONLINE oel5racn1
ONLINE ONLINE oel5racn2
ora.gsd
OFFLINE OFFLINE oel5racn1
OFFLINE OFFLINE oel5racn2
ora.net1.network
ONLINE ONLINE oel5racn1
ONLINE ONLINE oel5racn2
ora.ons
ONLINE ONLINE oel5racn1
ONLINE ONLINE oel5racn2
ora.registry.acfs
ONLINE ONLINE oel5racn1
ONLINE ONLINE oel5racn2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE oel5racn1
ora.oc4j
1 OFFLINE OFFLINE
ora.oel5racn1.vip
1 ONLINE ONLINE oel5racn1
ora.oel5racn2.vip
1 ONLINE ONLINE oel5racn2
ora.racdb.db
1 OFFLINE OFFLINE
2 OFFLINE OFFLINE
ora.scan1.vip
1 ONLINE ONLINE oel5racn1
[grid@OEL5RACN1 ~]$
[oracle@OEL5RACN1 ~]$ echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0/db_1
[oracle@OEL5RACN1 ~]$ srvctl add database -d RACDB1 -o /u01/app/oracle/product/11.2.0/db_1
[oracle@OEL5RACN1 ~]$ srvctl start database -d RACDB1
Database RACDB1 cannot be started since it has no configured instances.
[oracle@OEL5RACN1 ~]$ srvctl config database -d RACDB1
Database unique name: RACDB1
Database name:
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: RACDB1
Database instances:
Disk Groups:
Services:
Database is administrator managed
[oracle@OEL5RACN1 ~]$ srvctl start database -d RACDB
[oracle@OEL5RACN1 ~]$ srvctl status database -d RACDB
Instance RACDB1 is running on node oel5racn1
Instance RACDB2 is running on node oel5racn2
[oracle@OEL5RACN1 ~]$

[Note : If your instance are not added you also need to add instance into CRS the following way ]
[oracle@OEL5RACN1 ~]$ srvctl add instance -d RACDB -i RACDB1 -n OEL5RACN1