Oracle undo_management参数不一致错误
前端之家收集整理的这篇文章主要介绍了
Oracle undo_management参数不一致错误，
前端之家小编觉得挺不错的，现在分享给大家，也给大家做个参考。
环境Linux 5.8 10.2.0.5 RAC,两个节点只能一个节点mount,如果尝试mount另外节点就报ORA-01105和ORA-01606错误
数据库版本
<div class="codetitle"><a style="CURSOR: pointer" data="56582" class="copybut" id="copybut56582" onclick="doCopy('code56582')"> 代码如下:
<div class="codebody" id="code56582">
sql> select
from v$version; BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/sql Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for Linux: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production
crs资源情况
<div class="codetitle">
<a style="CURSOR: pointer" data="48296" class="copybut" id="copybut48296" onclick="doCopy('code48296')"> 代码如下:
<div class="codebody" id="code48296">
[oracle@node1 dbs]$ $ORA_CRS_HOME/bin/crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....D1.inst application OFFLINE OFFLINE
ora....D2.inst application ONLINE ONLINE node2
ora.PROD.db application ONLINE ONLINE node2
ora....SM1.asm application ONLINE ONLINE node1
ora....E1.lsnr application ONLINE ONLINE node1
ora.node1.gsd application ONLINE ONLINE node1
ora.node1.ons application ONLINE ONLINE node1
ora.node1.vip application ONLINE ONLINE node1
ora....SM2.asm application ONLINE ONLINE node2
ora....E2.lsnr application ONLINE ONLINE node2
ora.node2.gsd application ONLINE ONLINE node2
ora.node2.ons application ONLINE ONLINE node2
ora.node2.vip application ONLINE ONLINE node2
节点1 mount报错
<div class="codetitle">
<a style="CURSOR: pointer" data="26270" class="copybut" id="copybut26270" onclick="doCopy('code26270')"> 代码如下:
<div class="codebody" id="code26270">
sql> startup
ORACLE instance started. Total System Global Area 171966464 bytes
Fixed Size 2094832 bytes
Variable Size 113248528 bytes
Database Buffers 50331648 bytes
Redo Buffers 6291456 bytes
ORA-01105: mount is incompatible with mounts by other instances
ORA-01606: gc_files_to_locks not identical to that of another mounted instance
Error: ORA 1105
Text: mount is incompatible with mounts by other instances
-------------------------------------------------------------------------------
Cause: An attempt was made to mount the database,but another instance has already mounted
a database by the same name,and the mounts are not compatible.
dditional messages will accompany this message to report why the mounts are incompatible.
Action: See the accompanying messages for the appropriate action to take. Error: ORA 1606
Text: GC_FILES_TO_LOCKS not identical to that of another mounted instance
-------------------------------------------------------------------------------
Cause: The initialization parameter GC_FILES_TO_LOCKS is not the same as
another instance mounted in parallel mode.
This parameter must be the same as that for all shared instances.
Action: Modify the parameter to be compatible with the other instances,then
shut down and restart the instance.
