论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2011-12-19 13:56 |只看该作者 |倒序浏览

<DIV><SPAN class=Apple-style-span style="WORD-SPACING: 0px; FONT: medium 文泉驿正黑; TEXT-TRANSFORM: none; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BORDER-COLLAPSE: separate; orphans: 2; widows: 2; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px">
After installed Oracle 10g on CentOS 5.4, I startup the Oracle, I met this problem: ORA-01102: cannot mount database in EXCLUSIVE mode 
After googling find this post: <A style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; FONT-WEIGHT: bold; PADDING-BOTTOM: 0px; MARGIN: 0px; COLOR: rgb(60,108,146); PADDING-TOP: 0px; BORDER-BOTTOM: rgb(221,221,221) 1px solid; TEXT-DECORATION: none; outline-style: none; outline-width: initial; outline-color: initial" href="http://www.orafaq.com/forum/t/40030/0/">http://www.orafaq.com/forum/t/40030/0/</A>
This analysis and solution works for me: A database is started in EXCLUSIVE mode by default. Therefore, the ORA-01102 error is misleading and may have occurred due to one of the following reasons:
- there is still an "sgadef.dbf" file in the "ORACLE_HOME/dbs" directory - the processes for Oracle (pmon, smon, lgwr and dbwr) still exist - shared memory segments and semaphores still exist even though the database has been shutdown - there is a "ORACLE_HOME/dbs/lk" file
The "lk" and "sgadef.dbf" files are used for locking shared memory. It seems that even though no memory is allocated, Oracle thinks memory is still locked. By removing the "sgadef" and "lk" files you remove any knowledge oracle has of shared memory that is in use. Now the database can start.
POSSIBLE SOLUTION: Verify that the database was shutdown cleanly by doing the following:
1. Verify that there is not a "sgadef.dbf" file in the directory "ORACLE_HOME/dbs".
% ls $ORACLE_HOME/dbs/sgadef.dbf
If this file does exist, remove it.
% rm $ORACLE_HOME/dbs/sgadef.dbf
2. Verify that there are no background processes owned by "oracle"
% ps -ef | grep ora_ | grep $ORACLE_SID
If background processes exist, remove them by using the Unix command "kill". For example:
% kill -9
3. Verify that no shared memory segments and semaphores that are owned by "oracle" still exist
% ipcs -b
If there are shared memory segments and semaphores owned by "oracle", remove the shared memory segments
% ipcrm -m
and remove the semaphores
% ipcrm -s
NOTE: The example shown above assumes that you only have one database on this machine. If you have more than one database, you will need to shutdown all other databases before proceeding with Step 4.
4. Verify that the "$ORACLE_HOME/dbs/lk" file does not exist
5. Startup the instance</DIV>

返回列表

Chinaunix › 论坛 › IT运维 › Hadoop和大数据技术 › [Archived move] ORA-01102 during startup

[Hive] [Archived move] ORA-01102 during startup [复制链接]