关闭DRM的时候,忘记加sid='*'。所以只在其中一个节点修改了,导致两个节点的配置不同。
正确修改:https://www.cndba.cn/Expect-le/article/108https://www.cndba.cn/Expect-le/article/108
https://www.cndba.cn/Expect-le/article/108https://www.cndba.cn/Expect-le/article/108
alter system set "_gc_read_mostly_locking"=false scope=spfile sid='*';
alter system set "_gc_bypass_readers"=false scope=spfile sid='*';
重启了该节点,报错https://www.cndba.cn/Expect-le/article/108
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 SYSTEM SET local_listener=' (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.203)(PORT=1521))' SCOPE=MEMORY SID='rac2';
ALTER DATABASE MOUNT /* db agent *//* {2:45263:625} */
NOTE: Loaded library: System
SUCCESS: diskgroup DATA was mounted
SUCCESS: diskgroup OCR_VOTE was mounted
NOTE: dependency between database rac and diskgroup resource ora.DATA.dg is established
NOTE: dependency between database rac and diskgroup resource ora.OCR_VOTE.dg is established
ORA-1105 signalled during: ALTER DATABASE MOUNT /* db agent *//* {2:45263:625} */...
Thu Jul 28 10:30:04 2016
Shutting down instance (abort)
License high water mark = 1
USER (ospid: 16249): terminating the instance
Instance terminated by USER, pid = 16249
Thu Jul 28 10:30:05 2016
Instance shutdown complete
3.解决方法:
alter system set "_gc_read_mostly_locking"=false scope=spfile sid='*';
alter system set "_gc_bypass_readers"=false scope=spfile sid='*';
然后重新启动问题节点。https://www.cndba.cn/Expect-le/article/108
版权声明:本文为博主原创文章,未经博主允许不得转载。