V
V
Vaper672017-01-16 05:20:31
Oracle
Vaper67, 2017-01-16 05:20:31

How to get rid of the ORA-00704 error and preferably forever?

So. I have Oracle XE 11gR1. Of course, it does not support multiple paths for ORACLE_HOME at all, and even the creation of an additional database on the same ORACLE_HOME path, but creating a second database in XE is still real, which is what I'm trying to do. However, immediately after I created a database instance, configured it, created a tablespace, and only then launched the instance, to complete the creation of the second database, I launched the catalog.sql and catproc.sql scripts in it first in the wrong order (it was necessary first catalog. sql , and only then catproc.sql) , as a result of which, after a while, when trying to open the database using the 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
The blogs said that you need to update the release and only then run these two scripts again to get out of a situation like, for example, here: sandeepbirineni .blogspot.com.ee/2013/03/ora-00... I just couldn't find any other advice. So I had to go this route. On restarting the scripts, all data dictionary objects were already collected in the correct order, however, some with compilation errors (for example, related to 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 errors occur there after the database has notified about an error with bootstrap, so I don’t see the connection. Here. Please tell me what should I do? What error correction methods are suitable here and, if possible, describe them in more detail. Or if this is the only solution besides reinstalling XE from scratch, should I downgrade the release with catdwgrd.sql to erase all the effects of catupgrd.sql's misgenerating of objects, or will something else be needed?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question