The ORACLE tutorial is as follows: startup after Oracle 9i Database is shut down abnormally. Oracle Database startup
A sudden power failure occurs during Oracle shutdown, and the database cannot be connected when SQL/plus is used for startup. The specific description is as follows:
Connection can not permitted, shut in progress.
Enter the following at the dos prompt:
C: \> sqlplus/nolog
Display:
SQL/plus: Realease9.0.2 ........ All rights reserved
SQL> connect/as sysdba
Show idle routines connected
SQL> startup: shutdown in progress is displayed.
Connect to sqlplus:
Sys/manager @ orcl92: The information connection is successful.
SQL: select * from tab;
Show norows selected;
Indicates that the database is not started. Later, I checked the relevant information to find a solution:
Enter the following at the dos prompt:
C: \> sqlplus/nolog
Show SQL/plus: Realease9.0.2 ........ All rights reserved
SQL> connect/as sysdba
Show idle routines connected
SQL> startup force
Display: started. The database has started properly.
You can also stop oraclehome92 service in windows services, start oracle enterprise manager console, select start independently, select database, and click orcl (Global Database Name). The dialog box is displayed, enter the user name, system password, and connection identity: sysdba. Select a routine and configure it. Under the general information tab, change the routine status to disabled. If you are prompted that oraclehome92 service is stopped, you can start the service and then start the database.
Appendix: startup force forces a database that is not closed or cannot be started normally. process: first shut down the instance and then start it.
Startup restrict: starts the database in restricted mode to restrict access to the database. Only users with restricted session permissions can connect to the database.
Alter system [enable/disable] After the restricted session is opened in the database, this statement starts or disables the access restriction function. If you want to make changes to the master structure or want to export consistency, set the database to the restricted mode. Only with the alter system permission can the alter system [enable/disable] restricted session command be used to change the Database Availability.
When an instance is started in nomount state, it can only access the view where sga reads data. The dictionary view for reading data from sga about v $ thread and v $ controlftle. When the database is assembled, information such as v $ thread and v $ controlftle is read from the control file.
Analysis: When the database is shut down abnormally, shutdown does not exit in the program, so shutdown is detected when the instance is started, and the system reports an error. Therefore, you must first shut down the database and then start the database.