Oracle ORA-01033: ORACLE initialization or shutdown in progress error Solution

At work this morning, the customer called and said that the system could not be accessed. the user name and user number could not be loaded! When I heard this problem, I first thought about whether the server was restarted. Why was Oracle database services not started? When I checked the services, I found that the services were all started. The second idea is to check whether the program configuration file has been modified, and there is no exception. The third is to use PL/SQL to connect to the Oracle database. after entering the login name and password, the following error is prompted :;

 

After searching through the Internet, I finally found several solutions with detailed steps. For details, refer to the following:

 

Solution 1:

Step 1: Run cmd

Sqlplus/NOLOG

SQL> connect sys/change_on_install as sysdba

Tip: Successful

SQL> shutdown normal

Tip: the database has been closed. The database has been uninstalled. The ORACLE routine has been closed.

SQL> startup mount

SQL> alter database open;

 

Tip :()

Row 1st error: ORA-01157: unable to identify/lock data file 19-see DBWR trace file

ORA-01110: Data File 19: ''' C: \ oracle \ oradata \ oradb \ FYGL. ORA''

The file part of this prompt varies depending on different situations.

Continue with step 6, SQL> alter database datafile 19 offline drop;

Shutdown normal, startup mount is OK

 

Content Source: http://www.2cto.com/database/201202/118194.html

Http://yuxisanren.iteye.com/blog/1754018

I tested it and found that the problem still did not solve;

 

Method 2:

 

After the Oracle services are stopped, restart the service and check that the services can be logged on normally.