Oracle login error encountered ORA-01033 Solution

Today, when logging on to oracle Data encountered a ora-01033: oracleinitializationorshutdowninprogress this problem, the company server database is 9i,

Today, when logging on to oracle Data encountered a ora-01033: oracle initialization or shutdown in progress this problem, the company server database is 9i,

Today, when logging on to Oracle Data encountered a ora-01033: oracle initialization or shutdown in progress this problem, the company server database is 9i, using vm login on the server db and API have restarted the login or error, and then on the Internet to check the ora-01033 related information my solution is as follows:

First, I first determine whether the oracle service oracle instance and the listening service are started. When I check that the two services are started properly, so in case that I restart these two services once, I still cannot log on again;

Then, check oracle_sid in the registry. ORACLE_SID is not found in HKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE \ HOMEO. Therefore, a system variable is added to my computer-properties-advanced-environment variable, new system variable: variable name = oracle_sid. The variable value is the host string (tnsnames. the name configured in the ora file). After the variable is created, you can log on and find that the problem persists.

Then, use sqlplus/nlog in cmd to log on,

Then SQL> conn sys/sys as sysdba

SQL> startup start the service, observe that there is no data file loading error at startup, and remember the Error Data File

SQL> select group #, sequence #, archived, status from v $ log

It can be found that the deleted log is not a member of the current log group, and the solution is simple:

Because my library is non-archive, we need to use alter database clear unarchived logfile group1;

In this step, log on to the database again and enter the database smoothly. The problem is solved.