【RAC】單節點 重啟 報ORA-1105 ORA-01606

版本 11.2.0.1.0
rac1 
rac2 
linux 5.3U  2.6.18-128.el5
   因為要修複一個bug做測試，在一個節點上修改隱含參數，然後重啟！在測試的過程中遇到
修改了rac1 上的參數
sys@rac1>alter system set "_gc_read_mostly_locking"=false scope=spfile sid='rac1';
sys@rac1>shutdown immedate
Database closed.
Database dismounted.
Oracle instance shut down.
在啟動的時候遇到如下報錯：
sys@rac1> startup
ORACLE instance started.
Total System Global Area 1653518336 bytes
Fixed Size                  2213896 bytes
Variable Size            1275070456 bytes
Database Buffers          369098752 bytes
Redo Buffers                7135232 bytes
ORA-01105: mount is incompatible with mounts by other instances
ORA-01606: parameter not identical to that of another mounted instance
警示日誌中
ALTER DATABASE   MOUNT
NOTE: Loaded library: /opt/oracle/extapi/64/asm/orcl/1/libasm.so
NOTE: Loaded library: System
SUCCESS: diskgroup DATA2 was mounted
NOTE: dependency between database rac and diskgroup resource ora.DATA2.dg is established
ORA-1105 signalled during: ALTER DATABASE   MOUNT...
Sun Jul 01 19:17:49 2012
Starting ORACLE instance (normal)

因為節點1 和節點2 上面 _gc_read_mostly_locking 參數不一樣，導致上面的錯誤。
解決辦法：
因為節點2沒有關閉,所以在節點上執行
sys@rac2>alter system set "_gc_read_mostly_locking"=false scope=spfile sid='*';
再次啟動rac1 的資料庫 就可以成功啟動！

拓展一下，如果修改隱含參數的時候sid指定為*,重啟一個節點 是ok的！
sys@rac1>alter system set "_gc_read_mostly_locking"=false scope=spfile sid='*';
System altered.
sys@rac1>shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
sys@rac1>startup
ORACLE instance started.
Total System Global Area 1653518336 bytes
Fixed Size                  2213896 bytes
Variable Size            1275070456 bytes
Database Buffers          369098752 bytes
Redo Buffers                7135232 bytes
Database mounted.
Database opened.
sys@rac1>