Shulou(Shulou.com)06/01 Report--

1. Phenomenon

Since the error report has been started before, first shut down the database, and then restart

$sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Tuesday May 26 15:36:50 2015

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Connect to:

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL > shutdown immediate

ORA-01507: database not mounted

The ORACLE routine has been closed.

SQL >

SQL > startup

The ORACLE routine has been started.

Total System Global Area 5.3447E+10 bytes

Fixed Size 2232248 bytes

Variable Size 3.2481E+10 bytes

Database Buffers 2.0938E+10 bytes

Redo Buffers 26517504 bytes

ORA-01102: cannot mount database in EXCLUSIVE mode

SQL >

SQL > exit

From Oracle Database 11g Enterprise Edition Release 11.2.0.2.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options disconnect

$sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Tuesday May 26 15:43:32 2015

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Connect to:

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL >

SQL > shutdown immediate

ORA-01507: database not mounted

The ORACLE routine has been closed.

SQL >

SQL > exit

From Oracle Database 11g Enterprise Edition Release 11.2.0.2.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options disconnect

two。 Analyze the reasons

Find the lk beginning file under $ORACLE_HOME/dbs. This error is mainly caused by the lk file.

Its main function is to explain that it is on DATABASE MOUNT, not on MOUNT; it will be deleted automatically after DATABASE UNMOUNT, but if the file exists in an abnormal situation, even if the database has been stopped, the system will think that the database has been mount.

$cd $ORACLE_HOME/dbs

$ls-l

Total 96

-rw-rw---- 1 oracle oinstall 1544 Nov 17 2014 hc_DBUA0.dat

-rw-rw---- 1 oracle oinstall 1544 Nov 17 2014 hc_itdb1.dat

-rw-rw---- 1 oracle oinstall 1544 May 26 15:43 hc_itsys.dat

-rw-rw---- 1 oracle oinstall 1544 May 26 15:43 hc_itsys1.dat

-rw-rw---- 1 oracle oinstall 1544 May 13 16:16 hc_orcl.dat

-rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora

-rw-r- 1 oracle oinstall 24 Nov 17 2014 lkITSYS1

-rw-r- 1 oracle oinstall 24 Aug 04 2014 lkORCL

-rw-r- 1 oracle oinstall 1536 Nov 17 2014 orapwitsys1

-rw-r- 1 oracle oinstall 1536 Aug 04 2014 orapworcl

-rw-r- 1 oracle oinstall 2560 May 05 10:15 spfileitsys1.ora

-rw-r- 1 oracle oinstall 2560 Feb 10 22:00 spfileorcl.ora

3. Solution method

Kill the process that occupies the lkITSYS1 file with the fuser command

$fuser-k lkITSYS1

LkITSYS1: 5701814 5767372 5832954 6946854 7209198 7667712 7930062 8323164 8388624 8847426 9306156 9633968 9699564 9895986 16187422

$fuser-u lkITSYS1

LkITSYS1:

$

$

$sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Tuesday May 26 15:46:35 2015

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Connected to an idle routine.

SQL >

SQL > startup

The ORACLE routine has been started.

Total System Global Area 5.3447E+10 bytes

Fixed Size 2232248 bytes

Variable Size 3.2481E+10 bytes

Database Buffers 2.0938E+10 bytes

Redo Buffers 26517504 bytes

The database is loaded.

The database is already open.

SQL >

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.