Ora-01034:oracle not available how to solve

A little problem, let me toss a morning, three o'clock in the afternoon completely solved, share a solution for everyone, although on the test server, but the experience is worth summarizing and sharing.

ERROR:
Ora-01034:oracle Not available
Ora-27101:shared Memory realm does not exist
Process id:0
Session id:0 Serial Number: 0

----This is a phenomenon.

Sql*plus:release 11.2.0.1.0 Production on Monday March 18 15:30:38 2013

Copyright (c) 1982, Oracle. All rights reserved.

ERROR:
Ora-01031:insufficient Privileges

Please enter user name: SYS as SYSDBA
Enter Password:
Connected to the idle routine.

Sql> show parameter;
Ora-01034:oracle Not available
Process id:0
Session id:0 Serial Number: 0

Sql> select Group#,sequence#,members,archived,status from V$log;
Select Group#,sequence#,members,archived,status from V$log
*
An error occurred on line 1th:
Ora-01034:oracle Not available
Process id:0
Session id:0 Serial Number: 0
-----

In this process I refer to a lot of information, can not solve

sql> Startup Open Hstestdb
The ORACLE routine has been started.

Total System Global area 6847938560 bytes
Fixed Size 2188768 bytes
Variable Size 3422554656 bytes
Database buffers 3405774848 bytes
Redo buffers 17420288 bytes
The database is loaded.
ORA-03113: End of file for communication channel
Process id:2984
Session Id:5 Serial Number: 3

-----

Or ORA-03113: What is the reason for the end of the file in the communication channel?

sql> Startup Open Hstestdb
The ORACLE routine has been started.

Total System Global area 6847938560 bytes
Fixed Size 2188768 bytes
Variable Size 3422554656 bytes
Database buffers 3405774848 bytes
Redo buffers 17420288 bytes
The database is loaded.
ORA-03113: End of file for communication channel
Process id:2984
Session Id:5 Serial Number: 3

Sql> exit
From Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production
With the partitioning, OLAP, Data Mining and Real application testing options break
Open

C:\Documents and Settings\administrator>set Oracle_sid=hstestdb

C:\Documents and Settings\administrator>sqlplus "/as sysdba

Sql*plus:release 11.2.0.1.0 Production on Monday March 18 15:37:02 2013

Copyright (c) 1982, Oracle. All rights reserved.

ERROR:
Ora-01031:insufficient Privileges

Please enter user name: SYS as SYSDBA
Enter Password:
Connected to the idle routine.

Sql> stop
sp2-0042: Unknown Command "Stop"-the remaining lines are ignored.
sql> shutdown immediate;
Ora-01034:oracle Not available
Ora-27101:shared Memory realm does not exist
sql> startup Mount;
The ORACLE routine has been started.

Total System Global area 6847938560 bytes
Fixed size                   2188768 bytes
Variable size             3422554656 bytes
Database buffers          3405774848 bytes
Redo buffers                17420288 bytes
Database is loaded.
Sql> SELECT * from V$log;

    GROUP#    THREAD#  SEQUENCE#       bytes  blocksize    members ARC
---------------------------------- -----------------------------
Status           first _change# first_time     next_change# next_time
------------------------------------- --------------------------------
         1           1       3823    52428800        512           1 NO
current                34344047 December-March -13       2.8147e+14

         3           1       3822   52428800         512          1 NO
INACTIVE               34327500 December-March -13          34344047 December-March -13

2 1 3821 52428800 1 NO
INACTIVE 34324562 December-March-13 34327500 December-March-13

sql> ALTER DATABASE open;
ALTER DATABASE Open
*
An error occurred on line 1th:
ORA-03113: End of file for communication channel
Process id:2592
Session Id:5 Serial Number: 7

sql> ALTER DATABASE Archivelog;
ERROR:
ORA-03114: Not connected to ORACLE

Sql> select * from V$log;
ERROR:
ORA-03114: Not connected to ORACLE

Sql> Conn Sys/sys as Sysdba
Connected to the idle routine.
Sql> select * from V$log;
SELECT * FROM V$log
*
An error occurred on line 1th:
Ora-01034:oracle Not available
Process id:0
Session id:0 Serial Number: 0

sql> archive log list;
Ora-01012:not logged on
Sql> exit
Disconnected

C:\Documents and Settings\administrator>lsnrctl status

Lsnrctl for 64-bit windows:version 11.2.0.1.0-production on 1 August-March-2013 15:4
4:24

Copyright (c) 1991, Oracle. All rights reserved.

Connecting to (Description= (address= (protocol=tcp) (host=hserptest) (port=1521))
The STATUS of LISTENER
------------------------
Alias LISTENER
Version Tnslsnr for 64-bit windows:version 11.2.0.1.0-produ
Ction
Start date 1 August-March-2013 15:30:27
Uptime 0 days 0 hours 14 minutes 0 seconds
Trace level off
Security On:local OS Authentication
SNMP OFF
Listener parameter File D:\app\Administrator\product\11.2.0\dbhome_1\network\a
Dmin\listener.ora
Listener log File D:\app\administrator\diag\tnslsnr\hserptest\listener\a
Lert\log.xml
Listener Endpoint Summary ...
(Description= (address= (protocol=tcp) (host=hserptest) (port=1521)))
(Description= (address= (PROTOCOL=IPC) (PIPENAME=\\.\PIPE\EXTPROC1521IPC)))
Service Summary:
The service "Clrextproc" consists of 1 instances.
The instance "Clrextproc", State UNKNOWN, contains 2 handlers for this service ...
The service "Hstestdb" consists of 1 instances.
The instance "Hstestdb", State UNKNOWN, contains 1 handlers for this service ...
Command execution succeeded

C:\Documents and Settings\administrator>sqlplus "/as sysdba"

Sql*plus:release 11.2.0.1.0 Production on Monday March 18 15:45:23 2013

Copyright (c) 1982, Oracle. All rights reserved.

ERROR:
Ora-01031:insufficient Privileges

Please enter user name: Sys/sys as Sysdba
Connected to the idle routine.

Sql> select * from V$log;
SELECT * FROM V$log
*
An error occurred on line 1th:
Ora-01034:oracle Not available
Process id:0
Session id:0 Serial Number: 0

sql> ALTER DATABASE open resetlog;
ALTER DATABASE open Resetlog
*
An error occurred on line 1th:
Ora-01034:oracle Not available
Process id:0
Session id:0 Serial Number: 0

sql> ALTER DATABASE open resetlogs;
ALTER DATABASE open Resetlogs
*
An error occurred on line 1th:
Ora-01034:oracle Not available
Process id:0
Session id:0 Serial Number: 0

sql> shutdown immedate;
sp2-0717: illegal SHUTDOWN option
sql> shutdown Immediate
Ora-01034:oracle Not available
Ora-27101:shared Memory realm does not exist
sql> startup Mount;
The ORACLE routine has been started.

Total System Global area 6847938560 bytes
Fixed Size 2188768 bytes
Variable Size 3422554656 bytes
Database buffers 3405774848 bytes
Redo buffers 17420288 bytes
The database is loaded.

sql> ALTER DATABASE open resetlogs;
ALTER DATABASE open Resetlogs
*
An error occurred on line 1th:
The ora-01139:resetlogs option is only valid after incomplete database recovery

Sql> select * from V$log;

    GROUP#    THREAD#  SEQUENCE#       bytes  blocksize    members ARC
---------------------------------- -----------------------------
Status           first _change# first_time     next_change# next_time
------------------------------------- --------------------------------
         1           1       3823    52428800        512           1 NO
current                34344047 December-March -13       2.8147e+14

         3           1       3822   52428800         512          1 NO
INACTIVE               34327500 December-March -13          34344047 December-March -13

2 1 3821 52428800 1 NO
INACTIVE 34324562 December-March-13 34327500 December-March-13

sql> ALTER DATABASE open resetlogs;
ALTER DATABASE open Resetlogs
*
An error occurred on line 1th:
The ora-01139:resetlogs option is only valid after incomplete database recovery

Sql>
sql> recover database until time ' 2013-03-01 12:12:12 ';
Complete media recovery.

---

I resumed the March 1
sql> ALTER DATABASE open resetlogs;

The database has changed.

sql> shutdown
The database is closed.
The database has been uninstalled.
The ORACLE routine has been closed.
Sql> Startup
The ORACLE routine has been started.

Total System Global area 6847938560 bytes
Fixed Size 2188768 bytes
Variable Size 3422554656 bytes
Database buffers 3405774848 bytes
Redo buffers 17420288 bytes
The database is loaded.
The database is already open.
Sql>

-So far, problem solving.