如果转载本站文章到其他任何博客,论坛,股吧,请提供引用链接。违者必究!
March 4th, 2010 | Categories: Boring | Tags:

Votedisk can’t be add & remove while CRS is running, or else it would corrupt something.

OCR can be added & replaced while CRS is running.

Read more…

February 25th, 2010 | Categories: ELNINO | Tags:

高科技的能源产品,有氧气和天然气,就可以供给家庭或者办公室,甚至服务器用电,据说节约不少成本,很绿色。

Bloom’s fuel cell works like this: Oxygen is pumped in on one side and natural gas on the other. The two combine inside the cell to create a chemical reaction that produces electricity. No burning, no combustion, no power lines from outside.

fuel cell的internal如此,不管结果怎么样,有VC投钱就有大把的工作岗位。

February 11th, 2010 | Categories: Favorites | Tags:
February 4th, 2010 | Categories: Boring | Tags:

说EXPDP无语,那是因为它完全不customer focus,特别是导出数据量很大表很多的schema的时候,经常”假寐”。
“假寐”就是假死,hang.

今天用expdp作用户级别的逻辑备份,该用户有2200多个表,导出文件共85G,没有使用并行大概花费了3个小时不到。

运行命令后的半个小时内,导出文件大小没有任何变化,察看active session,有个在长时间等待”wait for unread message on broadcast channel”,给人的感觉是hang住,不靠普。

后来准备开窗口使用传统的exp,继续观察expdp。”假寐”后,EXPDP先把最大的一个表给导出来了,后来又导出了几个10g的表。原来我没有碰见真死的bug。观察日志文件,expdp基本按照表从大到小进行数据导出。倒是比exp快,可惜用户体验不行。

详细命令和日志如下

Read more…

February 3rd, 2010 | Categories: Boring | Tags:
January 19th, 2010 | Categories: NoFeeling, economy | Tags:

蜗居便是吃饱混天黑。
事业有成+大房+二奶 便是享受生活。

周末去朋友家做客后的感想

如果你觉的时间过得快,便是吃饱混天黑。相反觉得慢的,便是享受生活。

January 7th, 2010 | Categories: Boring | Tags:

CRS_STAT -p 可以看到资源之间的依赖性。可以通过crs_register来修改,控制crs_start -all的顺序。

./crs_stat -p ora.rac1.LISTENER_RAC1.lsnr >> /tmp/ora.rac1.LISTENER_RAC1.lsnr.cap
./crs_stat -p ora.rac2.LISTENER_RAC2.lsnr >> /tmp/ora.rac2.LISTENER_RAC2.lsnr.cap
./crs_stat -p ora.rac1.ASM1.asm >> /tmp/ora.rac1.ASM1.asm.cap
./crs_stat -p ora.rac2.ASM2.asm >> /tmp/ora.rac2.ASM2.asm.cap
./crs_stat -p ora.orcl.orcl1.inst >> /tmp/ora.orcl.orcl1.inst.cap
./crs_stat -p ora.orcl.orcl2.inst >> /tmp/ora.orcl.orcl2.inst.cap

–modify REQUIRED_RESOURCES item for all tempfiles.(多个dependence 资源用空格隔开)

./crs_register -u ora.rac1.LISTENER_RAC1.lsnr -dir /tmp
./crs_register -u ora.rac2.LISTENER_RAC2.lsnr -dir /tmp
./crs_register -u ora.rac1.ASM1.asm -dir /tmp
./crs_register -u ora.rac2.ASM2.asm -dir /tmp
./crs_register -u ora.orcl.orcl1.inst -dir /tmp
./crs_register -u ora.orcl.orcl2.inst -dir /tmp

January 7th, 2010 | Categories: Boring | Tags:

Document can be applied to 10gR1 and 10gR2. Keep for reference.

Read more…