ORA-01034，ORA-27101，ORA-12514

今天早上，公司的live 服务器出现以上问题。

 

原因是

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

 

这两个问题引起oracle的启动。

 

于是，正常google，

找到很多，都说要oracle未正常shut之类的。。

 

于是，重启oracle，重启服务器。。均失败！

 

后来就准备把oracle的数据文件搬走，到其他数据库来试试，正好也做备份的作用，

结果在oradata文件夹下发现一个文件，undotbs01.dbf 大的惊人！ 29G。。

 

反正也不知道如何处理，觉得这个文件太大吧，可能引起错误！

 

然后找解决方案。

 

http://www.xland.com.cn/article/74/77/0801/27851.htm

 

最后在此发现解决的方案，即压缩 undo 文件。

SQL> startup ORACLE instance started. Total System Global Area 135338868 bytes Fixed Size 453492 bytes Variable Size 109051904 bytes Database Buffers 25165824 bytes Redo Buffers 667648 bytes Database mounted. ORA-01157: cannot identify/lock data file 2 - see DBWR trace file ORA-01110: data file 2: ''D:ORACLEORADATAORCLUNDOTBS01.DBF'' SQL> alter system set undo_management=''MANUAL'' scope=spfile; System altered. SQL> alter database datafile ''d:oracleoradataorclundotbs01.dbf'' offline drop ; Database altered. SQL> alter database open; Database altered. SQL> SQL> create undo tablespace undotbs2 datafile ' 'd:oracleoradataorclundotbs02.dbf'' size 100M; Tablespace created. SQL> select * from v $tablespace; TS# NAME INC ---------- ------------------------------ --- 3 CWMLITE YES 4 DRSYS YES 5 EXAMPLE YES 6 INDX YES 7 ODM YES 0 SYSTEM YES 8 TOOLS YES 1 UNDOTBS1 YES 9 USERS YES 10 XDB YES 2 TEMP YES TS# NAME INC ---------- ------------------------------ --- 11 UNDOTBS2 YES 12 rows selected. SQL> alter system set undo_management=''AUTO'' scope=spfile; System altered. SQL> alter system set undo_tablespace=''UNDOTBS2'' scope=spfile; System altered. SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 135338868 bytes Fixed Size 453492 bytes Variable Size 109051904 bytes Database Buffers 25165824 bytes Redo Buffers 667648 bytes Database mounted. Database opened. SQL> show parameter undo NAME TYPE VALUE ------------------------------------ ----------- ----- undo_management string AUTO undo_retention integer 10800 undo_suppress_errors boolean FALSE undo_tablespace string UNDOTBS2 SQL>

 

 

完成以上操作后，重新连接oracle，ok！