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
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error:
"Error in invoking target install of makefile /opt/oracle/...../*.mk."
I'm getting errors while installing the Database Configuration Assistant.
Can I use /var/opt/oracle/oratab to specify listener information?