Go Ora-01034:oracle not available how to solve

This article transferred from: http://www.cnblogs.com/zhwl/p/3726003.html

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 realms 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 username: sys as SYSDBA enter password: connected to 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 * 1th row Error: 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 ORACLE routine has been started.

Total System Global area 6847938560 bytes Fixed size 2188768 bytes Variable Size 3422554656 by TEs database buffers 3405774848 bytes Redo buffers 17420288 bytes databases loaded. ORA-03113: File end of 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 ORACLE routine has been started.

Total System Global area 6847938560 bytes Fixed size 2188768 bytes Variable Size 3422554656 by TEs database buffers 3405774848 bytes Redo buffers 17420288 bytes databases loaded. ORA-03113: File end of 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, D ATA Mining and Real application testing options Disconnect

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 username: sys as SYSDBA enter password: connected to 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 realms 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 by TEs database buffers 3405774848 bytes Redo buffers 17420288 bytes databases 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 1 NO INACTIVE 34327500 December-March-13 34344047 12-3 Month-13

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

sql> ALTER DATABASE open; ALTER DATABASE Open * 1th error: ORA-03113: Communication channel end of file 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 is connected to the idle routine. Sql> select * from V$log; SELECT * FROM V$log * 1th line error: 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 STATUS------------------------(description= (address= (protocol=tcp) (host=hserptest) (port=1521)) LISTENER Aliases                        listener version                        tnslsnr for 64-bit windows:version 11.2.0.1.0-produ ction Start Date                    18-3-2013 15:30:27 normal operating hours                0 days 0 hours 14 minutes 0 seconds tracking level                    off Safety                      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 Monitoring Endpoint Overview ...    (description= (address= ( PROTOCOL=TCP) (host=hserptest) (port=1521))    (description= (address= (PROTOCOL=IPC) (pipename=\\.\pipe\ EXTPROC1521IPC)) Service Summary: The service "Clrextproc" consists of 1 instances.    instance "Clrextproc", State UNKNOWN, contains 2 handlers for this service ... The service "Hstestdb" consists of 1 instances.    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 a user name: Sys/sys as SYSDBA is connected to the idle routine.

Sql> select * from V$log; SELECT * FROM V$log * 1th line error: Ora-01034:oracle not available process id:0 session id:0 serial number: 0

sql> ALTER DATABASE open resetlog; ALTER DATABASE open Resetlog * 1th line error: Ora-01034:oracle not available process id:0 session id:0 serial number: 0

sql> ALTER DATABASE open resetlogs; ALTER DATABASE open Resetlogs * 1th line error: 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 n OT exist sql> startup mount; The ORACLE routine has been started.

Total System Global area 6847938560 bytes Fixed size 2188768 bytes Variable Size 3422554656 by TEs database buffers 3405774848 bytes Redo buffers 17420288 bytes databases loaded.
sql> ALTER DATABASE open resetlogs; ALTER DATABASE open Resetlogs * error on line 1th: ora-01139:resetlogs option 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 1 NO INACTIVE 34327500 December-March-13 34344047 12-3 Month-13

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

sql> ALTER DATABASE open resetlogs; ALTER DATABASE open Resetlogs * error on line 1th: ora-01139:resetlogs option 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 database is closed. The database has been uninstalled. The ORACLE routine has been closed. Sql> startup ORACLE routine has started.

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

-So far, problem solving.

Go Ora-01034:oracle not available how to solve