建立數據庫時遇到ORA-29807錯誤

今天﹐在oracle9.2.0.7上用dbca建立數據時遇到ORA-29807錯誤。

metalink say﹕

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' script from $ORACLE_HOME/rdbms/admin independently, as the user SYS. It is also advised to run the 'utlrp.sql' script to ensure that there are no invalid objects in the database at this time.

按照metalink說法﹐我Ignore了該錯誤。在建立完成后看到如下信息﹕

[oracle@pactest bin]$ ./dbca
NVFactory: _readNVPair expected )
NVFactory: _readNVPair expected )
NVFactory: _readNVPair expected )
[oracle@pactest bin]$

接著我又安metalink上說的﹐執行了

[oracle@pactest bin]$ sqlplus /nolog

SQL*Plus: Release 9.2.0.7.0 - Production on 25 11:10:21 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> conn / as sysdba
Connected.

SQL> @$ORACLE_HOME/rdbms/admin/prvtxml.plb

Library created.

Package body created.

SQL>@$ORACLE_HOME/rdbms/admin/utlrp.sql

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

转载于:http://blog.itpub.net/33600/viewspace-266413/