ORA-01102: cannot mount database in EXCLUSIVE mode的解决办法
来源:互联网 发布:医院平台优化方案 编辑:程序博客网 时间:2024/06/07 23:39
安装完oracle 数据库后启动时,遇到ora-01102错误。
oracle@r05a11016.yh.com:/home/oracle>sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.2.0 Production on Fri Apr 15 16:17:39 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1.7103E+10 bytes
Fixed Size 2243608 bytes
Variable Size 8455717864 bytes
Database Buffers 8623489024 bytes
Redo Buffers 21712896 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode
查了metalink,了解到 ORA-1102 错误原因:
1 在ORACLE_HOME/dbs/存在 "sgadef<sid>.dbf" 文件或者lk<db_name> 文件。这两个文件是用来用于锁内存的。
2 oracle的 pmon, smon, lgwr and dbwr等进程未正常关闭。
3 数据库关闭后,共享内存或者信号量依然被占用。
lk<SID>说明DATABASE 已经是MOUNT状态了,不用再次MOUNT.当 DATABASE 被UNMOUNT 后会被自动删除,如果DATABASE没有MOUNT,却依然存在这个问题,只有手工将其删除。
具体解决ORA-01102问题的步骤:
--------------------
oracle@r05a11016.yh.com:/apsarapangu/disk1/opt/oracle/products/11.2.0>cd dbs
oracle@r05a11016.yh.com:/apsarapangu/disk1/opt/oracle/products/11.2.0/dbs>ll lk*
-rw-r----- 1 oracle oinstall 24 Apr 15 15:43 lkORCL
使用fuser -u lkORCL 查看使用 lkORCL 文件的进程和用户。-u 为进程号后圆括号中的本地进程提供登录名。
oracle@r05a11016.yh.com:/apsarapangu/disk1/opt/oracle/products/11.2.0/dbs>/sbin/fuser -u lkORCL
lkORCL: 21007(oracle) 21009(oracle) 21015(oracle) 21019(oracle) 21023(oracle) 21025(oracle) 21027(oracle) 21029(oracle) 21031(oracle) 21033(oracle) 21035(oracle) 21037(oracle) 21039(oracle) 21041(oracle)
使用 fuser -k lkORCL 杀死这些正在访问lkORCL的进程 -k 杀死这些正在访问这些文件的进程。
oracle@r05a11016.yh.com:/apsarapangu/disk1/opt/oracle/products/11.2.0/dbs>/sbin/fuser -k lkORCL
lkORCL: 21007 21009 21015 21019 21023 21025 21027 21029 21031 21033 21035 21037 21039 21041
确认:相关进程全被终止。
oracle@r05a11016.yh.com:/apsarapangu/disk1/opt/oracle/products/11.2.0/dbs>/sbin/fuser -u lkORCL
重新启动:
sqlplus"/as sysdba"
SQL*Plus: Release 11.2.0.2.0 Production on Fri Apr 15 16:30:16 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1.7103E+10 bytes
Fixed Size 2243608 bytes
Variable Size 8455717864 bytes
Database Buffers 8623489024 bytes
Redo Buffers 21712896 bytes
Database mounted.
Database opened.
- ORA-01102: cannot mount database in EXCLUSIVE mode的解决办法
- ORA-01102 cannot mount database in EXCLUSIVE mode 解决办法
- ORA-01102: cannot mount database in EXCLUSIVE mode
- ORA-01102: cannot mount database in EXCLUSIVE mode
- ORA-01102: cannot mount database in exclusive mode
- ORA-01102: cannot mount database in EXCLUSIVE mode - Linux Servers
- ORA-01102: cannot mount database in EXCLUSIVE mode
- ORA-01102: cannot mount database in EXCLUSIVE mode
- ORA-01102: cannot mount database in EXCLUSIVE mode
- ORA-01102: cannot mount database in EXCLUSIVE mode
- ora-01102:cannot mount database in exclusive mode
- ORA-01102: cannot mount database in EXCLUSIVE mode处理方法
- ORA-01102: cannot mount database in EXCLUSIVE mode
- ORA-01102: cannot mount database in EXCLUSIVE mode
- ORA-01102: cannot mount database in EXCLUSIVE mode
- ORA-01102: cannot mount database in EXCLUSIVE mode
- ORA-01102: cannot mount database in EXCLUSIVE mode
- Oracle ORA-01102故障: cannot mount database in EXCLUSIVE mode
- ModelSim打开已建立过的工程
- easyUI datagrid中combobox默认选中问题
- Json概述以及python对json的相关操作
- php识别电脑还是手机访问网站
- 富文本编辑器
- ORA-01102: cannot mount database in EXCLUSIVE mode的解决办法
- 冒泡排序Bubble sort
- 【导出EXCEL汇编】asp.net 将数据导出到excel中,并设置其格式 .
- Android SystemProperties设置/取得系统属性的用法总结
- C#中如何安装和卸载【Windows服务】?
- DNN使用非80端口和总是跳转到http://localhost问题的解决
- 二叉树的创建与递归遍历
- java 断言 assert 初步使用:断言开启、断言使用
- static作用