Oracle initialization or shutdown in progress problem resolution

Oracle initialization or shutdown in progress this error message when you log in to Oracle today, searching the web, trying out a lot of ways, and finally combining several methods to successfully conquer the problem!

cause : I mistakenly delete a database file that I have backed up and prompt for errors when I log in to the database to load data again

Operation Steps :

1.< /span> First execute cmd under Windows and enter the DOS environment.

2. log in as DBA user, verbose command is
sqlplus/nolog
sql>connect Sys/change _on_install as Sysdba
hint: succeeded

3.

      S ql >shutdown immediate       stop service
     SQL> Startup                         start-up service to see if there are any data file loading errors at startup and keep in mind Error data file designator
     sql>shutdown immediate       Stop the service again
      SQL>&NBSP; alter database DataFile ' G:\SP001. DBF ' offline drop;

The database has changed.

sql> ALTER DATABASE open;

The database has changed.

Sql>startup start service, this time normal.

4. Enter Sql*plus login without prompting for errors

Oracle initialization or shutdown in progress problem resolution