Oracle 9i database startup after abnormal shutdown

Oracle shutdown suddenly power off, resulting in the use of Sql/plus startup can not connect to the database, specifically described as:

Connection can not be permitted, shut in progress.

To the DOS prompt, type:

C:\> Sqlplus/nolog

Show:

Sql/plus:realease9.0.2........all Rights reserved

Sql> Connect/as SYSDBA

Show connected to idle routines

Sql>startup displays shutdown in progress.

To the sqlplus inside connection:

SYS/MANAGER@ORCL92 Display information connection succeeded.

Sql:select * from Tab;

Show NoRows selected;

Indicates that the database is not started.

The solution to the information obtained after the inspection:

To the DOS prompt, type:

C:\> Sqlplus/nolog

Show Sql/plus:realease9.0.2........all rights reserved

Sql> Connect/as SYSDBA

Show connected to idle routines

sql> Startup force

Display: Started. The database has started normally.

You can also stop the Oraclehome92 service in Windows Services before you start Oracle Enterprise Manager console, select Standalone startup, select a database, and click ORCL (Global database name). Pop-up dialog box, enter user Name System password password, connection identity: SYSDBA, select routines, configuration, under the General Information label to the routine state to close, in the open. If you are prompted to stop the Oraclehome92 service, you can also resolve the problem by starting the server up and then starting the database. Startup force forces a database that has not been shut down or failed to start properly; procedure: Close the instance first before starting. Startup restrict starts the database in restricted mode, restricting access to the database, and only users with restricted session permissions can connect to the database. alter system [Enable/disable] restricted session when the database is open, the statement starts or turns off the access restrictions feature. If the relative main structure makes changes or wants to export consistency, set the database to restricted mode. You can change the availability of the database with ALTER system [enable/disable] restricted session commands only if you have modify system permissions.

When an instance is started in the Nomount state, only the view that the SGA reads data can be accessed. A dictionary view of reading data from the SGA for information such as V$thread,v$controlftle. When the database is assembled, information about V$thread,v$controlftle is read from the control file. Analysis, when the database closes abnormally, shutdown does not exit in the program, so the shutdown is detected when the instance is started, then the system complains. Therefore, you need to close the database before starting the database.