标题: 启动数据库报ORA-01102: cannot mount database in EXCLUSIVE mode [打印本页] 作者: jiawang 时间: 2018-8-14 17:06 标题: 启动数据库报ORA-01102: cannot mount database in EXCLUSIVE mode 本帖最后由 jiawang 于 2018-8-14 18:03 编辑
OS:rhel 7.3 64bit
db:11.2.0.4 64bit
问题现象:
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Tue Aug 14 16:39:32 2018
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup;
ORACLE instance started.
Total System Global Area 1235959808 bytes
Fixed Size 2252784 bytes
Variable Size 788529168 bytes
Database Buffers 436207616 bytes
Redo Buffers 8970240 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode
查看later日志
[oracle@localhost trace]$ cd /u01/app/diag/rdbms/orcl/orcl/trace
[oracle@localhost trace]$ tail -100 alert_orcl.log
报错如下:
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /u01/app/
Tue Aug 14 16:46:04 2018
ALTER DATABASE MOUNT
sculkget: failed to lock /u01/app//product/11.2.0/db_1/dbs/lkORCL exclusive
sculkget: lock held by PID: 16503
ORA-09968: unable to lock file
Linux-x86_64 Error: 11: Resource temporarily unavailable
Additional information: 16503
ORA-1102 signalled during: ALTER DATABASE MOUNT...
大概意思为文件被占用,无法锁定(最后发现报错关系到一个文件和一个进程,就是日志里标出的两行)
解决办法:
[oracle@localhost ~]$ cd $ORACLE_HOME/dbs
[oracle@localhost dbs]$ ll
total 20
-rw-rw----. 1 oracle dba 1544 Aug 14 16:55 hc_orcl.dat
-rw-r--r--. 1 oracle dba 2851 May 15 2009 init.ora
-rw-r-----. 1 oracle dba 24 Aug 14 16:35 lkORCL
-rw-r-----. 1 oracle dba 1536 Aug 14 16:36 orapworcl
-rw-r-----. 1 oracle dba 2560 Aug 14 16:39 spfileorcl.ora