Problem solve Get help with specific problems with your technologies, process and projects.

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
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 2
Please 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

Dig Deeper on Oracle error messages