Errors when running catalog.sql and catproc.sql files
I am working on Oracle9i on a Linux platform and have successfully created the database. But when I run the catlog.sql and catproc.sql files, I get the following error repeatedly:
ALTER PACKAGE dbms_registry_sys COMPILE * ERROR at line 1: ORA-04045: errors during recompilation/revalidation of SYS.CDC_ALTER_CTABLE_BEFORE ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at line 2 ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at line 2Please tell me how I can overcome this problem. It has repeatedly corrupted the data dictionaries.
Have you tried using the Database Configuration Assistant? You can step through the DBCA and at the end, it will create a set of scripts that create a database and runs the appropriate cat* scripts in the proper order. It may be that the order you're executing the cat* scripts is incorrect. If you use DBCA, you can get a good example from which you can make sure that what you're doing is in the proper order. You don't have to create a database from those scripts, but they are good references. But, using the generated scripts and actually running them may prove to you if a database can be created at all. If the scripts fail that are generated by DBCA, you've likely got a bigger problem somewhere and may need to check with Oracle support directly on that.
For More Information
- Dozens more answers to tough Oracle questions from Karen Morton are available.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.