Q
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
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 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


This was last published in May 2003

Dig Deeper on Oracle error messages

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close