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

Invalid objects after compilation

I have successfully installed Oracle 10g on Windows XP. After that, I ran the file catalog.sql. The problem is that some objects in SYS, mainly schema, are invalid and remain invalid after compilation. What can I do?

I have successfully installed Oracle 10g on Windows XP. After that, I ran the file catalog.sql, which creates the Oracle dictionary connecting as user sys (file C:oracleproduct10.2.0database10gRDBMSADMINcatalog.sql). Every command in this file executed successfully -- except for some commands for dbobjects which were already in the database (during the RDBMS installation). The problem is that some objects in SYS, mainly schema, are invalid and remain invalid after compilation. What can I do?
This does happen on occasion, although it's somewhat rare that it happens right after a clean database creation. Have you checked the alert log to ensure there were no errors during the database creation? I have seen this occur most often after a patch is applied or an Oracle option is installed or uninstalled; however, most SYS objects generally compile successfully. Because I don't know which SYS objects are invalid, it's difficult to say whether this will cause issues with your database and applications at a later date. I would recommend opening a TAR with Oracle on this one.

Dig Deeper on Oracle database installation, upgrades and patches

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