admin管理员组

文章数量:1609936

今天做巡检的时候，发现客户数据库的组件状态异常

查了下MOS，记录下DBA_REGISTRY的状态说明

 QREF: Interpretation of STATUS in DBA_REGISTRY [ID 789626.1]
S.No

Status

Description

1

INVALIDSome objects for the component were invalid at the completion of the upgrade. If there were no errors during the component upgrade, then running utlrp.sql might change the status to VALID without rerunning the entire upgrade. Check the DBA_REGISTRY view after running utlrp.sql.

2

VALIDThe upgrade is complete AND all of the Oracle objects for that component are valid.

3

LOADINGThe component load script. has started.  Status before LOADED.

4

LOADEDThe component load script. has completed  Status before VALID (or INVALID).

5

UPGRADINGThe component upgrade script. has started.  Status before UPGRADED.

6

UPGRADEDThe component upgrade script. has completed.  Status before VALID (or INVALID).

7

DOWNGRADINGThe component downgrade script. has started.  Status before DOWNGRADED.

8

DOWNGRADEDThe component downgrade script. has completed.  Status before VALID (or INVALID).

9

REMOVINGThe component remove script. has started.  Status before REMOVED.

10

REMOVEDThe component remove script. has completed.  Status before VALID (or INVALID).

11

OPTION OFFThe server option required for the component was not installed or was not linked with the server. Check the V$OPTION view as well as the install logs. Install the component or relink the server with the required option, and then rerun catupgrd.sql

12

NO SCRIPTThe component upgrade script. was not found. Check the install logs, install the component software, and then rerun catupgrd.sql.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub/8242091/viewspace-680998/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub/8242091/viewspace-680998/

本文标签： interpretationstatusDBAREGISTRY

版权声明：本文标题：Interpretation of STATUS in DBA_REGISTRY 内容由热心网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：https://m.elefans.com/dongtai/1728576802a1164567.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。