Ora-01033:oracle initialization or shutdown in progress

Borrowing the experience of others

The client Oracle server enters the PL/SQL developer times ora-01033:oracle Initializationg or shutdown in progress error message that the application system cannot connect to the Oracle service. Solve the problem by remote guidance. The process is as follows:

1. Enter cmd and execute set Oracle_sid=fbms to ensure the correct SID is connected.
2, running Sqlplus "/as sysdba"
Sql>shutdown Immediate Stop Service
Sql>startup start the service, observe that there is no data file loading error at startup, and remember the error data file label
Sql>shutdown Immediate Stop service again
Sql>startup Mount
sql> Recover datafile 2 Recovering an error data file
Sql>shutdown Immediate Stop service again
Sql>startup start service, this time normal.
3, into the PL/SQL developer check, no longer prompt error.