Oracle XDB組件的重建
--XDB組件狀態(tài):
SQL> selectcomp_id,comp_name,version,status from dba_registry;
COMP_ID COMP_NAME VERSION STATUS
--------------------------------------------- --------------- -----------------
XDB Oracle XML Database 11.2.0.4.0?INVALID
--卸載XDB:
SQL> @?/rdbms/admin/catnoqm.sql
--安裝XDB
SQL>shutdown immediate
SQL>startup
SQL> @?/rdbms/admin/catqm.sql oracle SYSAUX TEMP YES
SQL> @?/rdbms/admin/utlrp.sql
驗(yàn)證: XDB 已經(jīng)正常了:
SQL> selectcomp_id,comp_name,version,status from dba_registry;
COMP_ID COMP_NAME VERSION STATUS
--------------------------------------------- --------------- -----------------
XDB Oracle XML Database 11.2.0.4.0 VALID

標(biāo)簽: