oracle 组件在DBA_REGISTRY 中显示 invalid

 

LFXGX}S7}T}{12AF[M]46CD

 

1. connect to the database as sysdba:

sqlplus "/ as sysdba"

2. 
shutdown immediate
3. 
startup upgrade

4. 
spool catalog.log

@D:/Ora10gHome/rdbms/admin/catalog.sql
spool off

5. 
spool catproc.log
@D:/Ora10gHome/rdbms/admin/catproc.sql
spool off


6. 
spool utlrp.log
@D:/Ora10gHome/rdbms/admin/utlrp

spool off

7. 
shutdown immediate

8. 
startup


Check the dba_registry again.


SELECT COMP_ID, VERSION, STATUS FROM DBA_REGISTRY;

 

oracle text 、catproc

posted @ 2012-05-10 15:50  DB&*NIX  阅读(1372)  评论(0)    收藏  举报