今天装一台9i的数据库,软件从9.2.0.4升级到9.2.0.8后用DBCA建库,出现ORA-29807的错误

wKioL1LiVK2AbiHDAAEa-IjTyX0203.jpg

经查metalink是一个已知的BUG:2686156,并且这个bug可以被忽略,我们可以单击ignore继续安装

有这样一段话:


ORA-29807: specified operator does not exist
This is a known issue (bug 2925665). You can click on the “Ignore”button to continue.
Once DBCA has completed database creation, remember to run the ‘prvtxml.plb’scrīpt
from $ORACLE_HOME/rdbms/admin independently, as the user SYS. It is alsoadvised
to run the ‘utlrp.sql’ scrīpt to ensure that there are no invalid objects inthe database at this time.


为了保证数据库没有失效对象,我们后续安装完成后可以通过在sys用户下在$ORACLE_HOME/rdbms/admin 目录下运 行utlrp.sql ,修复ORA-29807 错误