Chinaunix首页 | 论坛 | 博客
  • 博客访问: 69116
  • 博文数量: 15
  • 博客积分: 638
  • 博客等级: 上士
  • 技术积分: 155
  • 用 户 组: 普通用户
  • 注册时间: 2007-09-26 23:13
文章分类

全部博文(15)

文章存档

2012年(1)

2011年(1)

2009年(13)

分类: 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

 

 

阅读(2870) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~