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
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.
SQL> show parameter gc_files_to_locks;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
gc_files_to_locks string
检查两个节点的gc相关隐含参数,发现所有值也均一致
NAME DESCRIPTION VALUE
------------------------------ --------------------------------------------------------------------- -------
_gc_affinity_limit dynamic affinity limit 50
_gc_affinity_minimum dynamic affinity minimum activity per minute 6000
_gc_affinity_time if non zero, enable dynamic object affinity 10
_gc_async_memcpy if TRUE, use async memcpy FALSE
_gc_check_bscn if TRUE, check for stale blocks TRUE
_gc_coalesce_recovery_reads if TRUE, coalesce recovery reads TRUE
_gc_defer_time how long to defer down converts for hot buffers 3
_gc_dissolve_undo_affinity if TRUE, dissolve undo affinity after an offline FALSE
_gc_dynamic_affinity_locks if TRUE, get dynamic affinity locks TRUE
_gc_element_percent global cache element percent 103
_gc_global_lru turn global lru off, make it automatic, or turn it on AUTO
_gc_initiate_undo_affinity if TRUE, initiate undo affinity after an online TRUE
_gc_integrity_checks set the integrity check level 1
_gc_keep_recovery_buffers if TRUE, make recovery buffers current TRUE
_gc_latches number of latches per LMS process 8
_gc_maximum_bids maximum number of bids which can be prepared 0
_gcs_fast_reconfig if TRUE, enable fast reconfiguration for gcs locks TRUE
_gcs_latches number of gcs resource hash latches to be allocated per LMS process 64
_gcs_pkey_history number of pkey remastering history 4000
_gcs_process_in_recovery if TRUE, process gcs requests during instance recovery TRUE
_gcs_resources number of gcs resources to be allocated
_gcs_shadow_locks number of pcm shadow locks to be allocated
_gc_statistics if TRUE, kcl statistics are maintained TRUE
_gcs_testing GCS testing parameter 0
_gc_tsn_undo_affinity if TRUE, use TSN undo affinity TRUE
_gc_undo_affinity if TRUE, enable dynamic undo affinity TRUE
_gc_undo_affinity_locks if TRUE, get affinity locks for undo TRUE
_gc_use_cr if TRUE, allow CR pins on PI and WRITING buffers TRUE
_gc_vector_read if TRUE, vector read current buffers TRUE
仔细对比数据库参数，发现undo异常
--节点1
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string MANUAL
undo_retention integer 900
undo_tablespace string SYSTEM
--节点2
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1
数据库
发布于：2022-01-28 10:11
|
阅读数：317
|
评论：0
QQ好友和群
QQ空间
