Tip: 看不到本站引用 Flickr 的图片? 下载 Firefox Access Flickr 插件 | AD: 订阅 DBA notes -- ![]()
2008-06-21 Sat
Author:NinGoo posted on NinGoo.net
假如使用ASM做为Oracle数据库的数据存储方式,那么Oracle数据库是怎么来识别ASM的diskgroup的呢,也就是数据库的instanc和ASM的instance之间是如何沟通的呢?简单的说,就是ocssd(Oracle Cluster Support Services daemon)。本文假设为Linux环境下的RAC+ASM系统。
对于ASM来说,ocssd是必须的,所以在使用dbca创建ASM Instance的时候,就会提示要先安装ocssd。如果是单机,执行$ORACLE_HOME/bin/localconfig add安装ocssd。ocssd通过initta自动启动,在安装的时候就会在/etc/inittab中加入以下条目(rac环境):
h2:35:respawn:/etc/init.d/init.cssd fatal >/dev/null 2>&1 null
其中,35表示在os的运行级别(runlevel)为3或者5的时候启动/etc/init.d/init.cssd
respawn表示init.cssd进程如果异常终止,则自动重新启动
ocssd进程启动后会打开一系列的文件(通过/proc/pid/fd或者lsof -a -p pid可以获得filedescriptor的信息):
消息文件
– $CRS_HOME/srvm/mesg/procus.msb
– $CRS_HOME/css/mesg/clssus.msb
– $CRS_HOME/has/mesg/clsdus.msb
日志文件
– $CRS_HOME/log/hostname/cssd/cssdOUT.log
– $CRS_HOME/log/hostname/cssd/ocssd.log
– $CRS_HOME/log/hostname/alertSID.log
OCR(Oracle Cluster Registry),本例中在裸设备上,如果是单机也可能在本地文件系统中,典型路径$ORACLE_HOME/cdata/localhost/local.ocr
– /dev/raw/raw1
– /dev/raw/raw2
以及一些socket端口
– socket:[578057]
– socket:[578062]
…
ASM instace启动以后,通过gmon进程和osccd通信,将ASM的一些信息告诉给ocssd,而数据库则从ocssd获得这些信息,也就是说,ocssd是ASM Instance和Database之间的纽带。
ASM/ocssd/database之间具体通信的步骤,可以参考这里。
Related Articles
PermLink: http://www.ningoo.net/html/2008/how_an_asm_diskgroup_found_by_oracle_database.html
周五跑去新世界,本来不是特意去看电影的,因为从杜莎夫人蜡像馆里面出来离吃饭时间还早,想想上去看看有什么电影可以看的。
顺便说下,杜莎夫人蜡像馆里面的黑暗迷宫里面的鬼竟然是真人扮演,够劲的。
跑到顶楼一看刚好是功夫熊猫上映的日子,作为动画片的fans,没理由错过的:)
电影蛮搞笑的,整个剧院里面笑声不断,动画特技也不错,情节嘛比较老套,典型的励志型好莱坞动画片情节。
个人感觉蛮值得一看的

晕,周五登录,发现打不开,以为被GFW和谐了,想想不会吧,两年以来都没有被和谐过,今年走霉运了。
ping不通,然后siteuptime.com发来邮件说,site is unavailable,才知道美国访问也是不行。
登录cPanel才发现有通告,说是服务器硬盘坏了,将进行修理和恢复,为期6-8小时,晕死。
今天去看了一下GoogleAnalytics发现了网站浏览数降到了个位数。当然原本也没多少。
这样的事故级故障在做了这么多年成熟的webhosting的公司Bluehost.com来说,应该不多见啊,基本上Q2的KPI就没了。
所以要保持4个9还是难的,上次看了一下siteuptime.com对我的网站的统计,基本上都在98%左右,有一个月居然是95%,也就是说一个月30天中,有1.5天网站是宕机的。
天哪,要是搁在Alibaba.com,是多么的不可思议。前段时间看Donews,Amazon.com也宕机了,一宕就是2个小时,周五宕机的,周一又断断续续宕机,导致股票一下子跌了11%。Amazon新闻发言人说,没办法,架构太复杂了,已经尽全力解决了。根据我的经验来看,基本上是某个程序员发布了一个小需求或者小bugfix,导致一个很严重的问题,成为了压死骆驼的最后一根稻草。
互联网公司的质量是最重要的,这点都不能做好,顷刻间就损失好几千万,甚至上亿。
2008-06-20 Fri
In the news:
- Red Hat in Boston, Part 2.1: Fixing Patent Failure Without A Bulldozer (Serdar Yegulalp for Information Week)
- Red Hat, Amazon Team Up in the Cloud (Dan Berthiaume for eWeek)
- A new virtualizer for Red Hat (Gordon Haff for CNet News.com)
- Red Hat debuts new hypervisor, open-sources Linux management platform (Jon Brodkin for Network World)
- Red Hat chief: We are hard to do business with (Andrew Donoghue for ZDNet.co.uk
- Red Hat to embrace virtualisation (Egan Orion for The Inquirer)
- Red Hat Summit: Single sign-on via IPA server (from heise online)
Other voices:
- Paul Frields (Fedora Project Leader): Saturday Morning Fever (FUDCon info)
- Jeremy Katz (Red Hat engineer): Jim Whitehurst at FUDcon (including a summary of his Q&A)
- Jesse Keating (Red Hat): FUDcon
Welcome to the 102nd edition of Log Buffer, the weekly review of database blogs.
Since it was DB2’s 25th birthday this week, as Anant Jhingran reports, let’s start with it.
From ZDNet this week came a story that IBM was considering the open-sourcing of DB2 — big news, naturally, whether true or not. Matthew Aslett of 451 CAOS Theory says, Open source DB2? I don’t think so, suggesting that it was merely theorizing on the part of one IBM executive, and hype on the part of ZDNet. “Then of course,” Matthew continues, “there is the issue of why IBM would open source DB2. Where is the business driver? Despite solid competition from Oracle and Microsoft, the company is doing pretty well with DB2 as it stands, thanks very much, and open source databases have had minimal impact on the established vendors.”
Matt Asay of The Open Road likewise comes down on the uh-uh side of this. “It was . . . no surprise to see IBM quickly follow up ZDNet’s article with a blunt statement: ‘IBM has no plans to open source DB2.’ Of course it doesn’t. . . . The day that it needs DB2 to undermine Oracle’s database, however, we may see IBM making a similarly bald statement…in the other direction.”
On An Expert’s Guide to DB2 Technology, Chris Eaton offers some news on DB2 videos, including ChannelDB2’s video tutorials, IDUG’s video competition, and a funny video from IBM on the making of a “viral” industrial video. Such as itself.
On to MySQL now. Keith Murphy made his debut on the Pythian blog this week, with a link to some video tutelage of his own — his presentation to the Boston MySQL Users Group on backups. Jay Pipes also offers the slides for his address on Join-Fu: The Art of SQL (I and II). (I rarely cover presentation materials when I do Log Buffer, but these ones of Jay’s looks fantastic.)
Mark Schoonover reports that Keith’s and his 2008 MySQL Magazine survey is officially closed, adding, “Now the fun begins compiling all the data and pretty charts made. We’ve had 432 responses!”
Baron Schwartz of xaprb describes how to write a lazy UNION in MySQL. No, it doesn’t deal with posting a complaint about undefended job benefits. Baron explains: “Something occurred to me a couple of weeks ago: why not write a UNION that stops executing as soon as one part of it finds a row? Then you can UNION to your heart’s content and not incur the overhead of that second lookup unless you need it. For lack of a better term, I’m calling this a lazy UNION.”
偶尔看到这篇文章,感觉对自己对单位里的同事都很有作用,就转载过来让大家共勉。
对于在公众场合演讲,我想大部分人都会面临一个最大的问题,那就是紧张。一旦紧张,就会导致不自信,很多问题就会出现,心跳加速,呼吸沉重,结巴,忘词,语速过快等等。对于如何克服紧张我也经过了一个过程,最早的时候每当当众发言就会紧张,刚才提到的演讲中的问题都会出现,但现在不管是在公司内部会议上,客户报告讲演,还是给别人提供培训,我已经能做不错的演讲了。
我是如何克服紧张的呢?实际上即使是最好的演讲者都会紧张的,问题是你如何控制紧张。如果你不能控制你的紧张,那糟糕的演讲不可避免,颤抖的声音甚至会让你的听众都觉得非常费劲。如果控制得好,紧张可以让你更加集中注意力,思维更清晰,眼见更流利。所以,记住了,面对紧张不要害怕,因为每个人都会紧张,关键是你如何控制它。以下是我控制紧张的小窍门:
- 不停的告诉自己,你准备的很好,一切尽在掌握中,完全不必要紧张
- 上台前深呼吸
- 上台前紧握自己的拳头然后松开,这样重复几次可以转移你的注意力
另外,从我自己的经验来说,要做一个好的演讲,还要注意以下几点:
- 注意仪表着装,好的仪表给你自信,如果现场灯光较暗,最好选择亮色衣服,这样可以吸引听众注意力
- 用眼光和你的听众交流
- 语速要适中,不能过慢,也不能过快,过快和过慢都是不自信的表现
- 正面面对你的听众,不要侧身或者背身
- 加一些手势或身体语言能让你的演讲更有感染力
记住,只要你准备充分,完全可以做一次出色的演讲,你所要做的就是要控制你的紧张,记住是控制而非消除。
2008-06-19 Thu
2008-06-18 Wed
AnySQL.net
DBA notes
Oracle & Starcraft
eagle's home
Give you some color to see see!
AnySQL.net English
Oracle Scratchpad
Oracle Life
OracleDBA Blog---请享受无法回避的痛苦!
Uploads from dbanotes
Chanel [K]
xzh2000的博客
Oracle Security Blog
ERN空间
Eddie Awad's Blog
MySQL Performance Blog
The Tom Kyte Blog
del.icio.us/fenng/oracle
AIXpert
O'Reilly Databases
Red Hat Magazine
DBASupport
DB2 Magazine 中文版
developerWorks 中国 : 技术文章 , 教程 AIX
Pythian Group Blog » Log Buffer
车东[Blog^2]
blue_prince
玉面飞龙的BLOG
此生 今世
人生就是如此
Orange Tiger 木匠 的 移民生活
生活帮-LifeBang
Hey!! Sky!
dba on unix
Oracle Notes Wiki
Brotherxiao's Home
柔嘉维则@life.oracle.eng
Fenng's shared items in Google Reader
jametong's shared items in Google Reader
缥缈游侠-logzgh
Tanel Poder's blog: Core IT for geeks and pros
DBA Tools
ilonng
yangtingkun
NinGoo@Net
Oracle & Unix
Inside the Oracle Optimizer - Removing the black magic
Ricky's Test Blog
DBA@Taobao
存储部落
Think in 88
Alibaba DBA Team
Oracle Team @SNC
淘宝数据仓库团队
OracleBlog.cn














