Note:239304.1

Creating Database Using DBCA Under 9.2.0.2.0 or 9.2.0.3.0 - ORA-29807 Is Encountered

Problem

While using Database Creation Assistant (DBCA) to create a database (custom or template) after patchset 9.2.0.2.0 or 9.2.0.3.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.

Workaround

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

OR

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.

Solution

At the time of this posting, this issue is under investigation by Oracle development.

Reference

Bug:2810834 - ORA-29807: DBCA DURING INSTALLATION OF DICTIONARY VIEWS OF A NEW 9.2.0.2 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

CREATE NEWDB