分类: Oracle
2009-11-21 10:15:32
Cause:An instance tried to mount the database in exclusive mode, but some other instance has already mounted the database in exclusive or parallel mode.
Action:Either mount the database in parallel mode or shut down all other instances before mounting the database in exclusive mode.
============================================
solaris 10 oracle10g
bash-3.00$ sqlplus sys as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Nov 20 10:59:34 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 8589934592 bytes
Fixed Size 2090672 bytes
Variable Size 1369315664 bytes
Database Buffers 7214202880 bytes
Redo Buffers 4325376 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode
SQL> shutdown immediate
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 8589934592 bytes
Fixed Size 2090672 bytes
Variable Size 1369315664 bytes
Database Buffers 7214202880 bytes
Redo Buffers 4325376 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode
SQL> shutdown immediate
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
bash-3.00$ sqlplus system as
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Nov 20 11:02:59 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown immediate
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 8589934592 bytes
Fixed Size 2090672 bytes
Variable Size 1369315664 bytes
Database Buffers 7214202880 bytes
Redo Buffers 4325376 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode
SQL> shutdown abort
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
bash-3.00$ lsnrctl stop
LSNRCTL for Solaris: Version 10.2.0.1.0 - Production on 20-NOV-2009 11:04:13
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
The command completed successfully
bash-3.00$
bash-3.00$ kill -9 `ps -ef|grep ora |awk '{print $2}'`
bash: kill: (24766) - No such process
bash: kill: (24765) - No such process
bash: kill: (24764) - No such process
bash: kill: (24763) - No such process
Killed
# su - oracle
Sun Microsystems Inc. SunOS 5.10 Generic January 2005
$ bash
bash-3.00$ sqlplus sys as
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Nov 20 11:05:10 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 8589934592 bytes
Fixed Size 2090672 bytes
Variable Size 1369315664 bytes
Database Buffers 7214202880 bytes
Redo Buffers 4325376 bytes
Database mounted.
Database opened.
==============================================
ORACLE_HOME/dbs
#fuser -k lk[sid]
============================================
conclusion:still lack in experience about oracle