2015年7月7日 星期二

[Oracle]Oracle 9i Create Database Error Code:ORA-29807: specified operator does not exist

這是oracle bug,針對這個bug描述如下:

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.

解決方法:

安裝完成後,執行以下兩個語法後即可解決:

SQL> conn / as sysdba

Connected.

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

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

沒有留言:

張貼留言