Workaround One:
ERROR:
ora-01034:oracle Not available
ora-27101:shared Memory Realm does not exist
Process id:0
session id:0 Serial number: 0
because this small mistake, has been tossing me for several hours, the special record as follows.
Search the Internet for the next solution, as follows:
sqlplus "Sys/password as SYSDBA"
connection succeeded, prompt "connected to idle routine"
sql> Startup
The ORACLE routine has started.
Total System Global area 535662592 bytes
Fixed Size 1375792 bytes
Variable Size 293601744 bytes
Database buffers 234881024 bytes
Redo buffers 5804032 bytes
database loading complete.
ORA-03113: End of file for communication channel
Process id:5412
session id:5 Serial number: 5
A new error occurred: ORA-03113: The end of the file for the communication channel; The analysis may be due to a database forced shutdown last night, resulting in inconsistent file status because the database is normally shut down in conjunction with each file, making the file time point consistent when restarting.
find the solution as follows:
sql> conn/as sysdba
You are connected to an idle routine.
sql> Startup Mount
The ORACLE routine has started.
Total System Global area 535662592 bytes
Fixed Size 1375792 bytes
Variable Size 293601744 bytes
Database buffers 234881024 bytes
Redo buffers 5804032 bytes
database loading complete.
sql> SELECT * from V$log;
group# thread# sequence# BYTES BLOCKSIZE members ARC
---------- ---------- ---------- ---------- ---------- ---------- ---
STATUS first_change# first_time next_change# next_time
---------------- ------------- -------------- ------------ -------------
1 1 52428800 1 NO
INACTIVE 8474486 February-April-11 8522856 February-April -11
3 1 342 52428800 1 NO
INACTIVE 8555222 June-April-11 8565162 November-April -11
2 1 343 52428800 1 NO
Current 8565162 November-April -11 2.8147E+14
sql> ALTER DATABASE open Resetlogs
2;
ALTER DATABASE open Resetlogs
*
Line 1th Error:
The ora-01139:resetlogs option is only valid after incomplete database recovery
sql> recover database until time ' 2011-04-11 12:12:12 '
Complete Media recovery.
sql> ALTER DATABASE open resetlogs;
The database has changed.
sql> shutdown
The database has been closed.
The database has been unloaded.
The ORACLE routine has been closed.
sql> Startup
The ORACLE routine has started.
Total System Global area 535662592 bytes
Fixed Size 1375792 bytes
Variable Size 293601744 bytes
Database buffers 234881024 bytes
Redo buffers 5804032 bytes
database loading complete.
The database is already open.
Workaround: Two font size: big middle and small when you try to log on to Pl/sql, when you enter a username (SYSTEM/PWD), Oracle reports the following errors:
ERROR:
ORA-27101 Shared Memory Realm does not exist
ORA-01034 ORACLE Not available &<60;
consulted the relevant
ORA-27101 Shared Memory Realm does not exist
ORA-01034 ORACLE Not available &<60;
Description, interpreted as Oracle_home or ORACLE_SID settings are incorrect.
But no error was found after checking bash_profile;
Error, no open Oracle service;
Solution to directly open the service of Oracle Relational data library;
or follow the steps below:
Lsnrctl start
Sqlplus '/as sysdba '
Sql> Startup
Emctl Start Dbconsole
Isqlplusctl start
