So. I have an Oracle XE 11gR1. Of course, it does not support multiple paths for ORACLE_HOME at all, and even the creation of an additional database in the same way as ORACLE_HOME, however, it is still possible to create a second database in XE, which I am trying to do. However, immediately after I created the database instance, I configured it, created the tablespace, and then started the instance, to complete the creation of the second database, I started the scripts first, catalog.sql and catproc.sql in the wrong order (I had to catalog first. sql, and only then catproc.sql), resulting in some time when trying to open a database using the query alter database open; The following error occurred:
alter database open * error at line 1: ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00704: bootstrap process failure ORA-39700: database must be opened with UPGRADE option Blogs said that it was necessary to update the release and only then run these two scripts again to get out of such a situation as, for example, here:
http://sandeepbirineni.blogspot.com.ee/2013/03/ora-00704-bootstrap-process-failure-ora.html
I simply did not find any other advice. So I had to go this way. On re-running the scripts in the correct order, all the data dictionary objects gathered, however, some with compilation errors (for example, those associated with registers and Java). And some time after the forced upgrade, these errors, given above, returned. The trace file is attached ( https://vk.com/doc27309941_440899659?hash=daeafd7a ...), although I don’t understand exactly what’s wrong because the errors occur after the database reports an error with the bootstrap and therefore I don’t see the connection. Here it is. Tell me please: what should I do? What methods of error correction are suitable here and if it is possible to describe them in more detail. Or if this is the only solution besides reinstalling XE from scratch, is it worth it to downgrade the release with catdwgrd.sql to erase all the consequences of incorrectly generating objects with the catupgrd.sql script or do I need something else?
