Troubleshoot Oracle database errors ORA-16040 and ORA-00312

I. Problem phenomena and troubleshooting process

After the database server restarts, the app does not start properly, prompting that the database cannot be connected. It appears that the problem may be on the database server, so check the database server first:

1. After logging into the database server, open the cmd command prompt and enter the command

/  as Sysdba

Connect to the native database, enter the Sqlplus program context, and enter the command

Select  from V$instance;

After execution, it is indicated that the database is in the mounted state, not in open state, and it will not be able to provide service externally. No wonder the app doesn't start properly! Reason for this!

2. Open a database with a command

Alter Database Open;

After execution, the program error, prompt database errors ORA-16040 and ORA-00312, in Baidu Search these two wrong solution, basically is said the database archive log file has a problem, need to repair to continue.

Ii. Solutions

Now that the problem is discovered and the solution is found, the next step is to go straight to the solution.

1.sqlplus program context, first determine the database in the mounted state, and then use the command

Alter Database Group 1 ; Alter Database Group 2 ; Alter Database Group 3;

Clears the archive log.

2. Using commands

Alter Database Open;

Open the database, at this time Sqlplus did not error, it seems to be successful.

3. Using commands

Select  from V$instance;

Check the status of the database and discover that the database is open.

4. Open a new CMD window and enter the LSNRCTL Listener management context to restart the database listener using the stop and Start commands, respectively.

5. Finally, restart the application, the application is not error, can start normally. Problem solved.

Iii. Summary

Information system will inevitably appear in the process of a variety of strange problems, when problems occur, the first reaction should be to look at the phenomenon, and then based on the phenomenon to speculate on the possible causes. This example is a direct application error, the hint can not connect to the database, then follow this clue to find the reason for the database.

On the database server, the key to resolving the problem becomes the problem of resolving the archive log error because the database is not started properly because of the database archive log. According to the database error information, on-line to find whether there is already a mature solution (method), this luck better, directly found a lot of similar solutions, through practice, found that really effective, solve the problem.

Troubleshoot Oracle database errors ORA-16040 and ORA-00312