9.2.0.8에서 DBCA를 통해 DB생성시 ora-29807에러 발생
ignore로 계속 진행하니..문제없이 종료됨.
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