Creating Database Using DBCA Under 22.214.171.124.0 or 126.96.36.199.0 - ORA-29807 Is Encountered
While using Database Creation Assistant (DBCA) to create a database (custom or template) after patchset 188.8.131.52.0 or 184.108.40.206.0 has been applied, ORA-29807
'specified operator does not exist' is encountered during 'create data dictionary views.'
It has been determined that this error is being raised while DBCA is running the script prvtxml.plb.
Prvtxml.plb is a script which creates a particular package body. This script is called from the catxml.sql script - which in turn is called by the catproc.sql script - run automatically when creating a database using DBCA.
This workaround can be implemented either before invoking the DBCA or after the ORA-29807 has been encountered.
1. Go to the script catxml.sql and comment out the line which will run prvtxml.plb
2a. If the script has been edited before invoking DBCA, it is now safe to proceed with invoking DBCA
2b. If the script has been edited after the ORA-29807 is encountered, go back to your DBCA screen and click 'Ignore'
3. The database creation using DBCA should now proceed without additional errors.
4. Once DBCA has completed database creation, remember to run the 'prvtxml.plb' script independently, as the user SYS.
5. Check whether there are invalid objects: select * from dba_objects where owner = 'SYS' and status = 'INVALID' ; If so, run the 'utlrp.sql' script to validate those objects.
At the time of this posting, this issue is under investigation by Oracle development.
Bug:2810834 - ORA-29807: DBCA DURING INSTALLATION OF DICTIONARY VIEWS OF A NEW 220.127.116.11 DB
Bug:2925665 - WHILE CREATING DB BY DBCA, IT SHOWS ORA-29807 ERROR.
Bug:2816525 - WIN64 GET ORA-29807 WHEN CREATING DATA DICTIONARY VIEWS
Bug:2686156 - ORA-29807 SPECIFIED OPERATOR DOES NOT EXIST' ERROR WHEN TRYING TO