ORA-01034: ORACLE not available,ORA-27101: shared memory realm does not exist,ORA-03113: 通信通道的文件结尾
来源:互联网 发布:测量数据如何导入cad 编辑:程序博客网 时间:2024/05/29 14:36
转载地址:http://www.cnblogs.com/sirc/archive/2011/04/12/2013754.html,已验证,确实(在11G中)可以解决所述问题。
Oracle ORA-01034&ORA-03113错误解决方案
昨天晚上Oracle还可以使用,早上用sqlplus连接,出现如下错误:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
进程 ID: 0
会话 ID: 0 序列号: 0
因为这个小小的错误,折腾了我好几个小时,特记录如下。
上网搜索了下解决方案,如下:
sqlplus "sys/password as sysdba"
连接成功,提示"已连接到空闲例程"
SQL> startup
ORACLE 例程已经启动。
Total System Global Area 535662592 bytes
Fixed Size 1375792 bytes
Variable Size 293601744 bytes
Database Buffers 234881024 bytes
Redo Buffers 5804032 bytes
数据库装载完毕。
ORA-03113: 通信通道的文件结尾
进程 ID: 5412
会话 ID: 5 序列号: 5
出现一个新错误:ORA-03113: 通信通道的文件结尾;分析可能由于昨晚数据库强制关闭,导致文件状态可能不一致,因为正常关闭数据库会同步校验各文件,使得重新启动的时候文件时间点一致。
找到解决方案如下:
SQL> conn / as sysdba
已连接到空闲例程。
SQL> startup mount
ORACLE 例程已经启动。
Total System Global Area 535662592 bytes
Fixed Size 1375792 bytes
Variable Size 293601744 bytes
Database Buffers 234881024 bytes
Redo Buffers 5804032 bytes
数据库装载完毕。
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC
---------- ---------- ---------- ---------- ---------- ---------- ---
STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------------- ------------- -------------- ------------ -------------
1 1 340 52428800 512 1 NO
INACTIVE 8474486 02-4月 -11 8522856 02-4月 -11
3 1 342 52428800 512 1 NO
INACTIVE 8555222 06-4月 -11 8565162 11-4月 -11
2 1 343 52428800 512 1 NO
CURRENT 8565162 11-4月 -11 2.8147E+14
SQL> alter database open resetlogs
2 ;
alter database open resetlogs
*
第 1 行出现错误:
ORA-01139: RESETLOGS 选项仅在不完全数据库恢复后有效
SQL> recover database until time '2011-04-11 12:12:12'
完成介质恢复。
SQL> alter database open resetlogs;
数据库已更改。
SQL> shutdown
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。
Total System Global Area 535662592 bytes
Fixed Size 1375792 bytes
Variable Size 293601744 bytes
Database Buffers 234881024 bytes
Redo Buffers 5804032 bytes
数据库装载完毕。
数据库已经打开。
福建省空间信息工程研究中心
Detail.lee
- ORA-01034: ORACLE not available,ORA-27101: shared memory realm does not exist,ORA-03113: 通信通道的文件结尾
- oracle异常:ORA-27101: shared memory realm does not exist ;ORA-03113: 通信通道的文件结尾(错误解决)
- oracle异常:ORA-27101: shared memory realm does not exist ;ORA-03113: 通信通道的文件结尾(错误解决)
- ORA-27101: shared memory realm does not exist 错误的处理(ORA-01034 - Oracle not available )
- 解决ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist的问题
- ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist的原因分析
- ORA-01034: ORACLE not available ORA-01034ORA-27101 shared memory realm does not exist
- Oracle - ora-01034:oracle not available ora-27101:shared memory realm does not exist
- ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist
- ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist
- ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist
- ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist
- 解决ORA-01034: ORACLE not available和ORA-27101: shared memory realm does not exist
- ora-01034:oracle not available ora-27101:shared memory realm does not exist
- error: ora-01034:oracle not available ora-27101:shared memory realm does not exist
- ora-01034:ORACLE not available ORA-27101:shared memory realm does not exist
- error: ora-01034:oracle not available ora-27101:shared memory realm does not exist
- ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist
- 聚焦时提示内容变淡,输入文字时提示内容消失的输入框
- J2EE学习笔记——Servlet操作数据库(编辑数据)
- 看,天空发现一只无比巨大的鸟
- 想要的是全世界唯你一人的温暖:伤感日志
- Hadoop
- ORA-01034: ORACLE not available,ORA-27101: shared memory realm does not exist,ORA-03113: 通信通道的文件结尾
- Missing artifact javax.jms:jms:jar: Missing artifact com.sun.jdmk Missing artifact com.sun.jmx:jmxri
- sqlite3 修改字段值的问题
- 判断 iframe 是否加载完成的完美方法
- <转载>Mac OS 安装oracle client
- 相逢相失两如梦 秋风一叹半池泪
- C#与C++的混合编程
- 二叉树的基本操作
- AForge学习笔记(3):AForge.Fuzzy