1.错误原因
关闭DRM的时候,忘记加sid='*'。所以只在其中一个节点修改了,导致两个节点的配置不同。
正确修改:
alter system set "_gc_read_mostly_locking"=false scope=spfile sid='*'; alter system set "_gc_bypass_readers"=false scope=spfile sid='*';
重启了该节点,报错
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
2.日志信息:
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='*';
然后重新启动问题节点。
版权声明:本文为博主原创文章,未经博主允许不得转载。
- 上一篇:12C DDL日志说明
- 下一篇:Linux逻辑卷,卷组管理