Shulou(Shulou.com)06/01 Report--

Recently, dealing with an oracle for windows database failure, the early scenario is: the operator due to the execution of move commands in sqlplus

Move the database to the new tablespace to remove the fragmentation, but the execution time is long, so the operator thinks the command is dead, so he cancels it. I didn't expect to get it.

If it is stuck all the time, the operator will shut down the database and directly overwrite the current data file with the backup data file that the previous instance is still running.

Then, the operator reports an error while performing the operation, and the operator shuts down the database. As a result, the database cannot be started. During the subsequent recovery process

I rebuilt the control file, because there is no archiving, can not perform a full recovery, recovery must have data loss, which customers accept, restore

The process went well, but a startup was encountered during the recovery: the ORA-24324&ORA-01041 internal error hostdef extension does not exist.

The specific error messages are as follows:

What I do not understand is that in the course of operation, it failed to modify the default Undo table space of the database. I wanted to close the instance and modify it through pfile.

ORA-24324&ORA-01041 internal error hostdef extension does not exist. The process of troubleshooting and handling the problem is as follows:

1. First, check whether the oracle database service is started, and the result is that both the database and the listening service are started.

2. Check whether the oracle process exists and the oracle.exe process exists through the task manager, but the memory usage is not normal.

3. Start the instance directly through the startup command in sqlplus to prompt the hostdef problem.

4. Manually initiate and shut down the oracle instance service from the operating system level

5. Start the instance again through the pfile file, and still prompt the hostdef problem.

6. If you want to close the current cmd, open the cmd,sqlplus login empty instance to solve the hostdef, and the problem becomes a tns-related ORA-12560 error.

At this point, even the sqlplus cannot be logged in, and the empty instance cannot be connected. In desperation, I chose to restart the windows server and found that the problem was magically solved:

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.