remove a node from 11g r2 rac on OEL5(删除节点)

by

[grid@znode1 bin]$ cluvfy stage -post nodedel -n racnode3 -verbose
Performing post-checks for node removal
Checking CRS integrity…
Clusterware version consistency passed
The Oracle Clusterware is healthy on node “znode2”
The Oracle Clusterware is healthy on node “znode1”
CRS integrity check passed
Result:
Node removal check passed
Post-check for node removal was successful.

修改11g r2 RAC SCAN IP

by

SCAN简化了客户端连接的配置，只需指定SCAN Name在客户端的tnsnames.ora，不需要知道每个节点的vip就可以实现负载均衡
每个节点上的pmon会经常的发送本节点的负载情况到scan listener…

11G R2 Oracle Local Registry(OLR)

by

从oracle 11R2版本起在网格计算领域引进了新特性，其中之一就是grid Oracle Local Registry(OLR)，做为oracle clusterware的一部分，有些人喜欢叫Oracle Local Repository，因为这repositery记录了本地资源的信息和配置..

oracle 11g BaseLine(基线)指定application中不可修改sql的执行计划

by

11G前有sql profile、outline可以稳定执行计划，但有些文档中指出有时outline指定了但也有要能走新的执行计划，所以11g的BASELINE是OUTLINE的改进版。一般应用在版本升级或稳定特定SQL的执行计划，也可以修改指定SQL的执行计划，当OUTLINE与BASELINE有同时指定时BASELINE有优先权。

sqlserver 游标小例

by

总忘，小记 declare @c int declare @seq int set @seq=54000101 declare cur cursor for SELECT sectionid FROM StudySection WHERE (yearSemesterID = 2012001) open cur fetch next from cur into @c WHILE @@fetch_status=0 begin set @seq=@seq+1 print @seq update StudySection set oracleid=@seq where sectionid=@c fetch next from cur into @c end close cur deallocate cur