oracle rules manager 元件對應的升級sql

msdnchina發表於2011-11-27
原文網址 : http://blog.itpub.net/161195/viewspace-1056573/
Oracle元件SQL

The Oracle Rules Manager Component Is Invalid After Upgrade To 10.2.0.4 [ID 748699.1]
Solution

1. To upgrade "Rules Manager" component, please run the following script:

$ORACLE_HOME/rdbms/admin/rulpatch.sql

2. Verify if the "Rules Manager" component is upgraded/valid:

SQL> Select comp_name, version, status from dba_registry;
值得注意的是，執行類似這樣的升級sql，在正常的open 狀態下是不行的。必須在upgrade 下才能執行這些升級sql
[@more@]

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/161195/viewspace-1056573/，如需轉載，請註明出處，否則將追究法律責任。

相關文章