
11984 items (11984 unread) in 19 feeds
Blog
(67 unread)
Google
(2043 unread)
Oracle
(3668 unread)
OracleERP
(1622 unread)
ReadBlog
(1874 unread)
nix
(368 unread)
OpenSource
(370 unread)
TechNews
(1829 unread)
Design
(143 unread)
在Mac OS X中我们可以使用Android SDK直接将下载到电脑中的apk文件安装到Android设备中。
1. 下载Android SDK,可以从Android Developers网站直接下载,也可以通过MacPorts安装。我采取后一种方式。
$ sudo port install android Password: ---> Fetching archive for android ---> Attempting to fetch android-16_0.darwin_11.x86_64.tbz2 from http://packages.macports.org/android ---> Fetching android ---> Attempting to fetch android-sdk_r16-macosx.zip from http://dl.google.com/android ---> Attempting to fetch android-appbundles-r89422.tar.gz from http://distfiles.macports.org/android ---> Verifying checksum(s) for android ---> Extracting android ---> Configuring android ---> Building android ---> Staging android into destroot ---> Installing android @16_0 ---> Activating android @16_0 ---> Cleaning android
然后通过port contents命令可以获知Android SDK的安装路径。在我的机器上是/opt/local/share/java/android-sdk-mac_x86。
$ port contents android Port android contains: /Applications/MacPorts/Developer/.localized ...... /opt/local/share/java/android-sdk-mac_x86/tools/adb_has_moved.txt /opt/local/share/java/android-sdk-mac_x86/tools/android ......
默认安装的Android SDK是没有adb命令(该命令用于安装apk程序)的,需要运行Android SDK and AVD Manager来进行额外的下载安装。
2. 安装SDK Platform-tools
cd /opt/local/share/java/android-sdk-mac_x86/tools sudo ./android
会显示以下界面,在第一次运行的时候,Android SDK Platform-tools的状态是未安装的,因此我们需要选中该组件,然后点击右下方的“Install packages”按钮。而此处的截图是安装完毕以后的情况。

3. 安装apk软件,当然,这里先要用数据线将Android设备连接到Mac电脑上。
##adb命令是安装到platform-tools目录中,而非上一步android命令所在的tools目录。 $ cd /opt/local/share/java/android-sdk-mac_x86/platform-tools ##先探测是否可以正确识别设备,有设备号和device字样表示正确识别。 $ ./adb devices List of devices attached 01839c14 device ##安装apk软件,本例中安装的是高德移动导航 $ ./adb install /tmp/Autonavi_v1.2.apk 3225 KB/s (4027409 bytes in 1.219s) pkg: /data/local/tmp/Autonavi_v1.2.apk Success
Related posts:
Friends of BIP, STR Software have put together a great web based resource 'BIP University'
Focused on the E Business Suite flavor and their own integrations with BIP under EBS R12; its a great resource and well worth a few clicks and a read. Check it out here - http://www.bipuniversity.com/
假设我们想要在Mac OS X中安装:
MySQL,这是一个开源的免费的数据库,当然备Oracle收购之后有一些变化。
postgreSQL,这又是另外一个开源的免费的数据库。
perl,这是一种流行的编程语言。
lua,这又是另外一种流行的编程语言。
watch,这是一个实用程序,可以默认每隔2秒重复执行某条命令,比如你想监控一个目录下的文件生成情况,这条命令就很有用。
tree,这是一个实用程序,可以提供类似于ls -R的功能,但是输出是更加直观的树状结构。
当然,我们可以在网络中一个一个地找这些程序,然后一个一个地安装,用不同的安装方法,但是,你也可以选择非常简单的方法,这就是本文要介绍的MacPorts。
在Linux中如果我们要安装一些软件,要解决各个软件之间的包依赖性关系,我们会使用到apt-get(Ubuntu)或者yum(Redhat,CentOS)或者zypper(openSUSE),如果你熟悉一些Linux的话,对于这些软件包管理程序应该有所耳闻。而MacPorts正是在Mac OS X上的软件包管理程序。
安装MacPorts最简单的方法是直接下载dmg文件,双击安装 - Lion版安装文件 | Snow Leopard版安装文件。
MacPorts安装完以后,我们就可以通过命令行的方式来安装其它软件了,可以参看具体命令文档。以下列出常用的命令:
1. 更新本地软件库列表,该命令可以不定时多次执行(sudo以后需要输入密码,输入你自己用户的密码即可)。
sudo port selfupdate
2. 列出软件库中有哪些软件,注意,该命令会输出大量软件名称,因此建议添加more来查看,或者使用后面的search命令。
port list | more
3. 检索需要安装的软件。
port search <software_name>
当然,还有更精确地搜索,比如如果直接port search tree会出现上百个结果,但是如果执行以下命令,就只会出现一个结果。
$ port search --name --exact tree
tree @1.6.0 (sysutils)
display tree-view of directories with optional color/HTML output
4. 列出已经通过port安装的软件。
port installed
5. 安装软件,一些具有依赖性的软件会连带自动安装,比如安装LUA,会安装ncurses和readline。
sudo port install <software_name>
6. 卸载软件。
sudo port uninstall <software_name>
7. 清理未成功安装的软件,比如一些软件由于编译问题或者其它原因没有安装成功。
sudo port clean --all <software_name>
8. 查看安装的软件都安装了哪些内容。
port contents <software_name>
比如查看tree都安装了哪些内容。
$ port contents tree Port tree contains: /opt/local/bin/tree /opt/local/share/doc/tree/CHANGES /opt/local/share/doc/tree/LICENSE /opt/local/share/doc/tree/README /opt/local/share/man/man1/tree.1.gz
9. 升级当前安装过的软件。
sudo port upgrade <software_name>
Related posts:
Yep, found another integration with BIP. I get asked about Oracle Policy Automation quite a lot; I do not profess to know much; enough to be dangerous I guess. However, I was not aware that they had been working with BIP to help automate the generation of documents from the system.
For the uninitiated, here's the blurb care of :
Oracle Policy Modeling is a Windows desktop application for transforming legislation and policy documents into executable business rules. Rules are written in Word and Excel documents using phrases in languages such as English, Chinese and French. These rule documents can be shared amongst business and information technology stakeholders, and commentary can be added into the documents without affecting the structure of the rules themselves. Other features of Oracle Policy Modeling include integrated test case execution and debugging capabilities, and the definition of interviews for interactive rule-based assessments. Interview screen order and branching logic can be defined using visual flow diagrams.
In other words, a cool piece of technology, but tell us Tim how is it used? Well, it has been publicly deployed within several government web-sites. Australia's Department of Immigration uses it for visitors to check their eligibility for visas. The UK uses it for their Employment Status Indicator assessment tool, the UK governments online portal for businesses also uses OPA for over 60 interactive tools while the United States uses the software for guidance on tax law. The last one might be pertinent for me this weekend as W-2s have arrived and I have a night of misery trying to get a refund.
How does BIP fit in? Pictures are worth a thousands words and Fiona from the development team down under has recorded a great YouTube session explaining the integration and how to take advantage of it. I know I'm becoming more American cos I found it a little hard to place her accent at first, not to be rude Fiona but was it Brit, Aussie or maybe New Zealand? I plumped for Aussie, 10 points to me ... phew!
Direct link to the OPA YouTube channel - some other great vids on use cases and features.
You can find the OPA Homepage here lots of info on the tool and its possible applications.
Oracle的Apply Patchset的方法一直是为人诟病的,其实步骤复杂倒也罢了,怕的是Oracle总在不停地修改Apply Patch的方法,Oracle的原意是让Apply Patch的语法越来越简单,但是各种各样的Patch,各种不同的命令,特别是很大的Bundle Patch,如果不仔细阅读Readme,千万不要轻易出手。
这次尝试在自己的VirtualBox虚拟机OEL6中给之前安装的GI(Oracle Restart)+ ASM + Oracle Database安装最新的11.2.0.2.5 PSU,遇到各种问题。
1. Patch解压的目录必须是grid用户和oracle用户拥有写权限的,如果没有写权限,会报错:
Opatch version check failed for oracle home /u01/app/oracle/product/11.2.0/dbhome_1 Opatch version check failed update the opatch version for the failed homes and retry
安装需求是使用root用户来安装(这是我第一次看到在安装PSU的时候要求使用root用户),而我的虚拟机中由于没有足够的磁盘空间,所以将Mac中的下载目录作为Shared Folder映射到虚拟机中,因此改目录的属主是root,用户组是vboxsf,而且并不允许使用chmod直接修改。因此出现了权限问题。我的解决方法是将grid用户和oracle用户都加入vboxsf组中。
建议:在真实环境中,Patch解压目录应该属于dba用户组。
2. 我的Patch是解压在/media/sf_PSU目录下,解压以后生成了p13343447_112020_Linux-x86-64目录,其下有两个目录分别是13343424(这是DB PSU)和13343447(这是GI PSU),整个目录结构如下所示:
|-media |--sf_PSU |---p13343447_112020_Linux-x86-64 |-----13343424 |-----13343447
按照Readme文档中描述的,opatch的命令应该写为:
opatch auto <UNZIPPED_PATCH_LOCATION>
此处的UNZIPPED_PATCH_LOCATION按照文档描述应该就是/media/sf_PSU目录,因为这是解压目录,但是实际上这份文档是有问题的,如果opatch命令写为:
opatch auto /media/sf_PSU -ocmrf /home/grid/ocm.rsp
其中的-ocmrf是另外一个问题,这个OCM的配置文件,根据Readme文档中描述的方法创建即可。
运行以上命令会报错:
Opatch version check failed for oracle home /u01/app/oracle/product/11.2.0/dbhome_1 Opatch version check failed update the opatch version for the failed homes and retry
是的,你没有看错,我也没有贴错,确实报了一模一样的错误(虽然这两个错误都完全不是opatch版本的问题),所以,opatch的报错信息是不可信的,我们必须要去提示的log文件中仔细查看最后的错误信息。
ZOP-49: Not able to execute the prereq. OPatch cannot inform if the patch satisfies minimum version requirement. PatchObject constructor: Input file "/media/sf_PSU/p13343447_112020_Linux-x86-64/etc/config/actions" or "/media/sf_PSU/p13343447_112020_Linux-x86-64/etc/config/inventory" does not exist.
因此,正确的opatch命令应该是:
opatch auto /media/sf_PSU/p13343447_112020_Linux-x86-64 -ocmrf /home/grid/ocm.rsp
3. Oracle软件所在的文件系统剩余空间必须要大于3G,如果不足,会报错:
patch /media/sf_PSU/p13343447_112020_Linux-x86-64/13343447 apply failed for home /u01/app/grid/product/11.2.0/grid ACFS-9459: ADVM/ACFS is not supported on this OS version: 'error: file /etc/SuSE-release: No such file or directory
可以看到,又是一次很无稽的报错信息,/etc/SuSE-release?拜托,这里只有/etc/redhat-release。
那么,仔细检查log文件,会发现如下的报错:
Prerequisite check "CheckSystemSpace" failed. The details are: Required amount of space(3154696080) is not available. UtilSession failed: Prerequisite check "CheckSystemSpace" failed. Log file location: /u01/app/grid/product/11.2.0/grid/cfgtoollogs/opatch/opatch2012-01-27_18-23-48PM.log OPatch failed with error code 73
到此为止,我放弃了在虚拟机中安装PSU 11.2.0.2.5(如果要增加虚拟机中的文件系统剩余空间是非常麻烦的事情),但是我认为解决了磁盘空间问题之后,后面应该不会再有太多问题了。另外,如果在真实环境中这些问题可能都不存在,因为真实环境中文件系统的剩余空间应该远远不止3G,也应该不会有Shared Folder权限的问题,不过目录位置的问题应该还是会遇到,希望这里遇到的问题对将要在产品环境中Apply 11.2.0.2.5 PSU的朋友有帮助。
如果你成功Apply了该版本的Patch,那么也可以留言告诉我你遇到了什么障碍。
Related posts:


因为接近放假都在忙,预祝大家春节快乐。
转载请注明出自UCDChina.com,谢谢。
相关文章

By Ari Levy
President Barack Obama's effort to bring the health-care system into the digital age is boosting a couple of software startups -- ZocDoc and Practice Fusion -- that are trying to do just that.
ZocDoc, which lets patients book medical appointments via the web, said today that former Senate Majority Leaders Tom Daschle and Bill Frist have joined the advisory board to help the New York City-based company expand.
Practice Fusion, meanwhile, announced today it raised $2 million in debt from a group of angel investors, following a $23 million round of financing last year. Physicians use Practice Fusion's software to track their patients' medical history, schedule appointments, prescribe medication and provide referral letters.
While companies big and small have spent years trying to crack the electronic medical records market, it was President Obama's 2009 economic stimulus plan that sped up the process. As part of the plan, the government will invest up to $27.4 billion by 2021 to get health organizations on board.
ZocDoc is taking a bipartisan approach. Frist, a former heart and lung transplant surgeon, is a Republican and served as his party's leader in the Senate. Daschle led the Democrats in the Senate and now works at law firm DLA Piper, where he provides advice to clients on health care.
"They know a lot about the existing health-care establishment," said ZocDoc Chief Executive Officer Cyrus Massoumi. "Having people who have spent time at the highest level fixing the U.S. health-care system will help us leverage what we've done."
ZocDoc, founded in 2007, is used by about 800,000 people. The site lets users search for physicians in a particular practice and city and book the appointment online, rather than having to call around. Doctors pay $250 per month for the system, which is free for patients.
Practice Fusion, which opened its doors two years earlier, says its service for storing data is used by more than 130,000 medical professionals serving 29 million patients. The system is free for all users, and the San Francisco-based company currently generates all of its revenue from advertising on the site.
Venture capitalists and other investors have poured a combined $133 million into the companies, and there's plenty of overlap. Peter Thiel's Founders Fund and Ron Conway's SV Angel are investors in both. Salesforce.com CEO Marc Benioff backed ZocDoc, while his company is an investor in Practice Fusion.
The BI Publisher January patch for 11.1.1.5.0 is now available on Metalink; look for patch 13554951. Thanks to Shinji and team, this is one of the easiest posts of the year so far :0) Contents of the readme below, enjoy!
One-off patch for
Oracle Business Intelligence Publisher 11.1.1.5.0
READ ME File
==================================================
This patch contains fixes of following bugs for Oracle Business Intelligence Publisher 11.1.1.5.0.
9102877 - QA: QUERY BUILDER GENERATES INCORRECT SQL FOR MANY DBS 10071370 - IF 'USE SECURE FTP' IS CHECKD ON ADMIN PAGE, ITS SERVER IS NOT LISTD WHEN SCHED 10402890 - SETTINGS FROM "DELIVERY CONFIGURATION" PAGE NOT BEING HONORED WHEN REPORTS RUN 11725468 - ER: RTE HTML SUPPORT IN DATA XML 11828672 - QA: INCORRECT INACTIVE WARNING MESSAGE 11835845 - 11G SQL DATA SET CREATION ORA-01756 ERROR BECAUSE COLON IS READ AS BIND VARIABLE 11850902 - SHARE REPORT LINK "NO PARAMETERS" AND "DOCUMENT ONLY" RENDER INCORRECTLY 11870449 - BI PUBLISHER XDOXSLT:SDIV() FUNCTION RESULTS NOT CORRECT 12312539 - QA: REPORT VIEWER SCREEN FREEZES FOR A FLEX REPORT WHEN SESSION EXPIRES 12376386 - REMOVETEMPLATEFORREPORT API DOESN'T REMOVE TEMPLATE 12405904 - CANNOT DEPLOY BIP WHEN DEPLOYMENT PATH INCLUDES SPACE CHARACTERS 12406034 - CANNOT USE JAVA DB - DERBY - FOR SCHEDULER DATABASE 12570248 - PROJECTS : -GENERATE REV/INV PROCESS ERRORING OUT 12588342 - DELETEOBJECT RANDOM FAILURE 12595931 - WHEN PRINTING CHARTS TO PDF, NUMBERS BECOME ARABIC NUMBERS 12615821 - MISSING MEMBERS ON THE XML GENERATED BY BIP 12634030 - RE-PACKAGING MLR#11893189 TO XDOPARSER11G.JAR 12646493 - ORA-22902 CURSOR EXPRESSION NOT ALLOWED 12666066 - ER: EXCEL 2007 SUPPORT IN REST API 12705244 - JOINED MDX DATA SETS DO NOT PRODUCE CORRECT DATA - DATA MISSING 12726163 - NUMBER OF SESSIONS INCREASES AFTER RUNNING SCHEDULED JOBS 12737670 - GROUP BY FOR MDX DATA SET MISSING IN 11.1.1.5 - WAS PRESENT IN 11.1.1.3 12741858 - BI ASNWERS ANALYSIS IMPLEMENTING CASE WHEN STATEMENTS CAN NOT BE CONSUMED IN BIP 12750192 - ER: GENERATE NATIVE COMBINATION DUAL Y GRAPH IN PPTX OUTPUT FROM RTF AND XPT 12766932 - VERTICAL DUAL Y COMBO CHART MISSING SETTINGS TO ASSIGN VALUES TO AXIS 12775400 - DBFW:GENERATING IN XLXS OUTPUT IS THROWING AN ERROR 12822514 - SQL WITH CLAUSE - DATASET DOESN'T WORK (AND DIAGNOSTIC ISN'T HELPFUL) 12828845 - ISSUE WITH XDO_USER_NAME PARAMETER ON BIP 11.1.1.5.0 12835431 - INTRANSIT VALUATION REPORT QUERY GIVING ERROR IN EDITOR 12847306 - BI PUBLISHER DATA SET - WON'T SAVE 12872831 - EXCEL TEMPLATES GENERATING INCORRECT RESULTS FROM NESTED GROUPS 12879801 - ALLOW SAVING DATA MODEL WITH SPECIAL CHARACTER 12945367 - NOT ABLE TO EDIT DATA MODEL WHEN LINKS EXIT AMONG DATA SETS 12945475 - IE: NOT ABLE TO EDIT DATA MODEL WITH MANY DATA SET AND LINKS 12956901 - IN SQL SERVER CLOB IN DATA MODEL UI MARKED AS STRING DATA TYPE 12956915 - INCORRECT DATA WHEN PROCESSING OF CLOB COLUMNS FOR SQLSERVER 12956934 - DATA MODEL SHOULD RESPECT CASE SENSITIVITY FOR COLUMN AND TABLE NAMES 12972559 - XML DATA FILE TRUNCATED 12972852 - DYNAMIC IMAGES BROKEN FOR FO/PDF 12989467 - NEED TO CONVERT DOCUMENT FORMAT "EXCEL" TO "EXCEL2000" 13005659 - PSR:PERF:BIP:POOR PERF ACCESSING CATALOG FOLDER IN BIP 11G WITH SECURITY ENABLED 13007341 - DISPLAY ISSUES IN PARAMETER TAB OF OBI PUBLISHER 11G 13095050 - STRESS: OUTOFMEMORY ERRORS WITH VIEW REPORT STRESS 13100021 - BI PUBLISHER: QUERY BUILDER RESULTS RETURN COLUMN TYPE (APPEARS) INSTEAD VALUE 13100220 - HOW TO USE 11.1.1.5 WITH THE IDENTITY ASSERTER 13250009 - FOR METADATA LOGICAL SQL BIND WITH DUMMY VALUES INSTEAD OF NULL 13321449 - RESOURCELIMITEXCEPTION DURING ANY OPS THAT USE JNDI DATA SOURCE 13346737 - MULTIPLE VALUES IN A DASHBOARD PROMPT DOESN'T WORK WITH BI PUBLISHER INTEGRATED 13351305 - QUERY BUILDER DOES NOT BUILD CORRECT SYNTAX FOR SQL SERVER 13393658 - PRINTER DELIVERY [0] STATUS: FAILED PRINTING FROM WEB SERVICE CALL FROM EXTERNAL 13421264 - ADDING PARAMETER TO SQL BI SERVER DATA SET CORRUPTS DATA MODEL 13481659 - CAN'T SAVE ON BI DEV ENV RC2 13501838 - ORA-00923 ISSUE WHEN CREATING A BI PUBLISHER DATASET 13521951 - BIP UPGRADE FROM 10G TO 11.1.1.5.0 IS NOT SUCCESSFULL FOR TIAA-CREF 13529494 - BI REPORT NOT GENERATED WHEN HTML CONTAINS INVALID ATTRIBUTES----------------------------- INSTALLATION FOR ENTERPRISE -----------------------------
SELECT NON EMPTY Hierarchize([Product].Generations(3).Members) ON Axis(0), Hierarchize(Union([Market].Generations(3).Members, [Market].Generations(4).Members, ALL)) ON Axis(1) FROM Demo.BasicIt should be written using a With Set member:
with set [UnionMarket] as '{Union([Market].Generations(3).Members, [Market].Generations(4).Members, ALL)}'
SELECT
NON EMPTY Hierarchize([Product].Generations(3).Members) ON Axis(0),
Hierarchize(([UnionMarket]) ON Axis(1)
FROM Demo.Basic
This MDX set is recreated for the Join clause to:
with set [UnionMarket] as '{Union([Market].Generations(3).Members, [Market].Generations(4).Members, ALL)}'
SELECT
NON EMPTY Hierarchize([Product].Generations(3).Members) ON Axis(0),
Hierarchize(Filter([UnionMarket], [Market].CurrentMember.Member_Name = "Boston")) ON Axis(1)
FROM Demo.Basic
-----------------------------------------
Query Builder limitation with Microsoft SQL Server
-----------------------------------------
<?xml version="1.0" encoding="UTF-8"?> <RTECODE> <![CDATA[ <font style="font-style: italic; font-weight: bold;" size="3"><a href="http://www.oracle.com">oracle</a></font> <br/> <font size="6"><a href="www.oracle.com">www.oracle.com</a></font><br/><br/> ]]> </RTECODE>
<?html2fo:RTECODE?>Supported html formats: Paragraph Font style ( bold, italic, plain, underline, subscript, superscript and strikes-through) Font size Font family Background color Foreground color Paragraph alignment (center, left, right and justify) Paragraph indent URL link List Bullet List Number List Non-Supported formats: Nested List (List with Indent) Some HTML tags/attributes which manually inserted like Table, Image, etc... in stead of HTML editor Sample Report: XML: html_test.xml RTF tempalte: html_test.rtf
When “Mission: Impossible — Ghost Protocol” topped the box office last weekend, it was a surprising outcome to many.
本年度的最后一天,个人惯例,度过元旦的方式是做一下过去一年的个人总结。翻看了一下去年的总结和计划,完成度还过得去,这一年虽有遗憾,但没有虚度。
2011 年中在工作上多少做出了一点成绩,回顾了一下,上半年经历了从业以来几乎是最为严峻的考验,有段时间头发都急白了不少;下半年则相对顺利,团队效率提升很多,项目和产品上到了收获期,我甚至还能有时间顺路做做公关宣传。这是最有效率的一年。如果用一句话总结,那就是:丁香园全站过去一年中从传统的 1.0 模式升级到了 2.0 版本,打通了任督二脉,甚至还有一点延伸 --比如丁香园用药助手。作为第一款试水性的移动应用,一定程度上获得了用户的认可并且在业界有一点反响,这是整个团队乃至我个人都是始料未及的,很欣慰。总体来说,从大公司到小公司落了地,并且还能做点实际的事儿(某些人看这事儿:真是奇迹),也对自己有了一点信心,「如人饮水,冷暖自知」。
技术团队规模与去年相比,增加了60%。因为自己不喜欢大公司做事方式,己所不欲,勿施于人,所以对团队完全采取采取扁平结构、氛围尽量保持宽松,收效还不错。其实,一个团队负责人如果能充分调动大家的能动性,你会发现身边都是天才。《道德经》中有一句话:功成事遂,百姓皆谓:我自然。这是个值得努力的境界。
经济上,因为机会合适兑现了一些原公司的股票,算是过去几年的加班费吧,能让家里生活质量暂时提高一点点。投资方面,收获不错。投资老同事的项目成功出售,作为小小天使的另一个项目已经拿到风投并进入良性循环期;贝塔咖啡开了两家分店,「无形资产」起码增长了不少 ;) 允许我自我满足一下。尝试炒了一点美股,战绩还行,这个更大的收获还是了解到了一些公司的业务模式,其实也是在学习。顺便说一下,雪球是个有价值的网站。
这一年中,如果要问在那几个地方获取到有价值的信息最多?第一个是曹政大侠的神秘群组,让我了解到一个不一样的互联网生态圈;第二个地方是在知乎,内容质量非常好 ;第三个地方是新浪微博,获取到了很多有价值的产品反馈;然后是 Twitter,这一年发言少了很多。当然,要了解医学和健康知识,那还必须是丁香园,中立、客观是丁香园的准则。
拖延了好久的驾照考试终于通过(refer:学车记),虽然这事儿说出去挺丢人的,但对我自己来说,起码证明我的执行力终于改进了一点儿,自我满足一下。考过驾照之后出门也不怎么晕车了,伴随我这么多年的老毛病总算有所缓解。今年还有一件值得一提的事情是回到母校参加了毕业十周年的同学聚会,是啊,大学毕业10年了,从业也有10年了,就连我自己的个人站点都存在八年多了,时间真是个可怕的东西,不知道下一个十年会是怎样。我想,我应该抽空再修改一下上半年写的那篇《十年莽撞IT路》,算是一份人生的记忆。
这一年,自己完全变成了一个创业者。心态、思维模式改进了不少,人要改变自己很难,还好我不是不可救药。要批评自己的是在微博上不知不觉的暴露了个性上不那么讨好人的一面,有必要收敛一点。读书方面,阅读量还行,和去年相比不相上下(荐书清单)。参加的会议与往年相比,少了不少,只参加了QCon和移动开发大会等几个会议,全程免费的 Oracle Open World 也没时间去了,不过并不遗憾。Blog 数量少了很多(写邮件倒是多了),一是我不再想重复以前的那些东西,二是质量的确所下降,水分增加了,对读者朋友们说声抱歉! 对了,喝咖啡多了,但是失眠少了;几经折腾之后,开始尝试新的生物制剂药物,关节痛基本控制住了,体重居然也增加了 :)
身边的朋友多多少少对这狗日社会的渐渐有了幻灭感,只要我们相信有些事情会变好的,那不妨就积极的一点点做起来。从你我开始。
家庭生活上,有一点失落,但总有些事情是改变不了的,随遇而安吧。
我的 2011 榜单:
年度致敬:陈光诚 这个社会缺少有勇气的人;
年度媒体:知乎 在这里学到了很多知识,活到老,学到老嘛;
年度图书:吴军大作《浪潮之巅》。候选图书:《黑客与画家》...
年度视频:罗永浩 保利剧院演讲(一个理想主义者的创业故事II);
年度电影:钢的琴 ,有些生活总是让人感动;
年度音乐:左小祖咒《苦鬼2011》
2012 年的 TO-DO List:
Lean Startup. 过去的一年,其实团队做事一定程度上已经暗合 Lean 理念,2012 还要深入实践。如果还用老思路、老方式做事,不想办法做改进的话,成长自然不会好到哪里,所以,需要新思维。PS. 精益创业模式的理念和原则如下:1.创业第一天就设定收入目标 2. 持续的客户互动 3. 如果没有收入,就一定限制规模(别乱花VC的钱) 4.产品开发周期粒度减小:以小时/天计而不是月或者年为单位 5. 产品开发 - 最少的功能,最大的客户覆盖率 6. 客户驱动的产品开发.
产品研发. 如果2012不是世界末日的话,事情还要继续做下去。计划中还至少有两款有意思的产品要推动,要做出来;
运营意识. 毫不客气的说,过去一年中做的产品有几个并不那么成功,这并不都是产品本身的问题,运营能力不足的确存在,技术部门当然也要有运营意识。多和业界同仁学习,实践,还要勤奋一点。
寻觅人才. 丁香园技术团队仍然需要各方面的人才,尤其是移动应用开发的人才,我们有足够的耐心,也有足够的信心。如果你想在浮躁的环境中想静下心来做点对中国人有价值的事情,为什么不联系我一下呢?
好好生活. 新的一年要多出去走走。旅游,2011年两次国外旅游都挺有收获,怀念长滩的芒果沙冰。新的一年争取好好利用一下假期。另外,如果不是生活必需品,尽量少购买。简化一点生活,没什么不好。
最后,祝愿朋友们在新的一年更好的实现个人价值,让自己和家人生活得更好一些。
致谢:曹政、Hawk、召唤、大风、周拓、肖头、云风、Benjurry、Robbin、校长、Bluedavy、Hugo、国平、夏天天...... (不分先后,肯定还有遗漏的朋友,见谅! ),感谢各位朋友们一年来在技术上给我的帮助,让我学到很多很多,感谢!
--EOF--
这里有我的一份针对互联网的 2012 预测,仅供娱乐。
大环境的回顾,看子曰乐队的《2011盘点》吧:
最近文章|Recent Articles
本站赞助商:豆瓣网(Douban.com)
评论数(0)|添加评论 | 最近作者还说了什么? Follow Fenng@Twitter
DBA Notes 理念: 用简约的技术取得最大的收益...
需求:
1. 使用裸设备作为Oracle数据文件,而且要跳过操作系统或者其它软件提供的卷管理(比如Linux下的LVM)。
2. 由于small datafile限制,有大量磁盘分区需要创建。
以下测试环境操作系统为CentOS 6.0,如果你的操作是RHEL6或者OEL6,也同样适用,如果是RHEL5或者OEL5,那么udev部分的命令是不相同的。但是只需要在操作系统中man udev,查看一下相应的语法即可,思路是相同的。
解决方案:
1. 使用parted命令,脚本式创建多个分区,使用gpt类型分区表,这样可以创建大量primary分区,而如果使用msdos分区,则必须要要创建extend分区,然后再创建logical分区,这样在后面的udev规则文件中,还需要将extend分区排除出去,比较麻烦。
在我的测试环境中,对于/dev/sdc磁盘进行操作,分了11个分区,每个50M。
parted -s /dev/sdc mklabel gpt parted -s /dev/sdc unit MB mkpart primary 1 50 parted -s /dev/sdc unit MB mkpart primary 50 100 parted -s /dev/sdc unit MB mkpart primary 100 150 parted -s /dev/sdc unit MB mkpart primary 150 200 parted -s /dev/sdc unit MB mkpart primary 250 300 parted -s /dev/sdc unit MB mkpart primary 300 350 parted -s /dev/sdc unit MB mkpart primary 350 400 parted -s /dev/sdc unit MB mkpart primary 400 450 parted -s /dev/sdc unit MB mkpart primary 450 500 parted -s /dev/sdc unit MB mkpart primary 500 550 parted -s /dev/sdc unit MB mkpart primary 550 600
如果在生产环境的Oracle数据库中,block_size=2K的表空间,单个数据文件最大8G,可以使用:
parted -s /dev/sdc unit GB mkpart primary 1 8
2. 设置udev规则。如何在CentOS 6中设置udev,可以参看我之前的文章 - How to use udev for Oracle ASM in Oracle Linux 6。
vi /etc/udev/rules.d/99-oracle.rules
添加如下行:
KERNEL=="sd?[1-9]", SUBSYSTEM=="block", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="36000c293bd690056ce6834434765d3f4", NAME="oradisk0$number", SYMLINK="mapper/$name", OWNER="oracle", GROUP="dba", MODE="0660" KERNEL=="sd?1[0-9]", SUBSYSTEM=="block", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="36000c293bd690056ce6834434765d3f4", NAME="oradisk$number", SYMLINK="mapper/$name", OWNER="oracle", GROUP="dba", MODE="0660"
重启udev服务:
start_udev
然后可以发现/dev/mapper下的链接都成功创建,并且指向规则中定义的块设备名称。
# ls -l /dev/mapper/ total 0 crw-rw----. 1 root root 10, 58 Dec 29 03:29 control lrwxrwxrwx. 1 root root 12 Dec 29 03:29 oradisk01 -> ../oradisk01 lrwxrwxrwx. 1 root root 12 Dec 29 03:29 oradisk02 -> ../oradisk02 lrwxrwxrwx. 1 root root 12 Dec 29 03:29 oradisk03 -> ../oradisk03 lrwxrwxrwx. 1 root root 12 Dec 29 03:29 oradisk04 -> ../oradisk04 lrwxrwxrwx. 1 root root 12 Dec 29 03:29 oradisk05 -> ../oradisk05 lrwxrwxrwx. 1 root root 12 Dec 29 03:29 oradisk06 -> ../oradisk06 lrwxrwxrwx. 1 root root 12 Dec 29 03:29 oradisk07 -> ../oradisk07 lrwxrwxrwx. 1 root root 12 Dec 29 03:29 oradisk08 -> ../oradisk08 lrwxrwxrwx. 1 root root 12 Dec 29 03:29 oradisk09 -> ../oradisk09 lrwxrwxrwx. 1 root root 12 Dec 29 03:29 oradisk10 -> ../oradisk10 lrwxrwxrwx. 1 root root 12 Dec 29 03:29 oradisk11 -> ../oradisk11
注意,此时/dev目录下,sdc1至sdc11设备都不再存在了,但是我们可以通过比较设备的major号和minor号来确认绑定是正确的。
# ls -l /dev/mapper/oradisk01 lrwxrwxrwx. 1 root root 12 Dec 29 03:29 /dev/mapper/oradisk01 -> ../oradisk01 # ls -l /dev/oradisk01 brw-rw----. 1 oracle dba 8, 33 Dec 29 03:29 /dev/oradisk01 # cat /proc/partitions | grep 33 8 33 48128 sdc1
3. 直接使用/dev/mapper/oradisk*作为数据文件
由于在Oracle 10.2.0.2以后,Oracle已经可以用O_DIRECT标志直接打开块设备,而不是像以前版本那样,如果要跳过操作系统缓存直接读写磁盘设备,必须要用使用字符设备。在以前的版本中,因为要使用字符设备,所以才需要用raw命令去将某一个块设备映射为一个裸设备(字符设备)。而在Oracle 10.2.0.2以后则可以直接使用块设备(比如/dev/sdc1,比如udev映射以后的/dev/oradisk01,这些都是块设备),不过,虽然Oracle 10.2.0.2以后,Oracle可以直接读取块设备,但是在Oracle 11g以前,这个特性还不被OUI支持,如果要在OUI中使用,则需要使用符号链接(symbolic links),如我们用udev创建的/dev/mapper/oradisk*。
也就是在Oracle 10.2.0.2以后,Oracle 11g以前,需要使用/dev/mapper/oradisk*这样的符号链接作为数据文件。
在Oracle 11g以后,可以使用符号链接,也可以直接使用/dev/oradisk*作为数据文件。
如果你们认为有更优的最佳实践,欢迎讨论。当然我们也可以使用lvm或者Oracle ASM来处理数据文件的存储,这不在本文讨论范围内。
BTW: 一个有趣的bug?在测试中发现,如果在udev创建完符号链接之后,再使用parted来查看链接的分区情况,则会导致链接消失,而映射前的sdc1设备名重新出现。重启udev服务也无法将链接重新创建,但是用parted重新查看sdc1设备,则链接又重新出现,sdc1又重新消失。求解释。
--正常情况下有符号链接 [root@localhost ~]# ls -l /dev/mapper/oradisk01 lrwxrwxrwx. 1 root root 12 Dec 29 03:29 /dev/mapper/oradisk01 -> ../oradisk01 --映射前的sdc1设备是不存在的 [root@localhost ~]# ls -l /dev/sdc1 ls: cannot access /dev/sdc1: No such file or directory --用parted检查链接,或者检查/dev/oradisk01块设备,效果是一样的 [root@localhost ~]# parted /dev/mapper/oradisk01 GNU Parted 2.1 Using /dev/mapper/oradisk01 Welcome to GNU Parted! Type 'help' to view a list of commands. (parted) q --链接消失 [root@localhost ~]# ls -l /dev/mapper/oradisk01 ls: cannot access /dev/mapper/oradisk01: No such file or directory --映射的块设备还在 [root@localhost ~]# ls -l /dev/oradisk01 brw-rw----. 1 oracle dba 8, 33 Dec 29 03:29 /dev/oradisk01 --原先的sdc1设备出现 [root@localhost ~]# ls -l /dev/sdc1 brw-rw----. 1 root disk 8, 33 Dec 29 04:29 /dev/sdc1 --重新用parted检查sdc1 [root@localhost ~]# parted /dev/sdc1 GNU Parted 2.1 Using /dev/sdc1 Welcome to GNU Parted! Type 'help' to view a list of commands. (parted) q --符号链接重新出现 [root@localhost ~]# ls -l /dev/mapper/oradisk01 lrwxrwxrwx. 1 root root 12 Dec 29 04:38 /dev/mapper/oradisk01 -> ../oradisk01 --sdc1重新消失 [root@localhost ~]# ls -l /dev/sdc1 ls: cannot access /dev/sdc1: No such file or directory
Related posts:
在VMware Fusion中测试Cent OS 6中的udev功能时,发现scsi_id命令无法返回设备的SCSI ID。
# fdisk -l /dev/sdb Disk /dev/sdb: 1073 MB, 1073741824 bytes 255 heads, 63 sectors/track, 130 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk identifier: 0x00000000 Disk /dev/sdb doesn't contain a valid partition table # /sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/sdb
这个问题在Oracle VirtualBox中并不会出现,当然并不是说VirtualBox就比VMware好,作为Mac中的原生app,VMware Fusion确实要比VirtualBox美观,但是在功能上而言,VirtualBox毫不逊色,而且VirtualBox是免费的,所以如果要在自己的台式机或者笔记本中测试虚拟机,仍然强烈推荐使用VirtualBox。
言归正传,如何修改VMware Fusion,让其可以提供正确的设备SCSI ID呢?参考文章是:
The Case of VMware and the missing SCSI ID
方法如下:
1. 在虚拟机关闭以后,进入虚拟机的目录
2. 用文本编辑器修改vmx文件
$ ls *vmx [ VMplanet ] CentOS 6.0.vmx $ vi "[ VMplanet ] CentOS 6.0.vmx"
3. 在vmx文件中任意位置(通常在最后)添加如下行:
disk.EnableUUID = "TRUE"
4. 重新启动虚拟机,此时可以正确获取SCSI ID
#/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/sdb 36000c29577b5db74013db535e0155e01
注意:在手工修改完vmx文件以后,如果再进行任何虚拟机的设置,比如添加磁盘,修改网卡类型或者其它的操作,disk.EnableUUID参数又会重置为FALSE,所以每次进行虚拟机设置以后,都需要手工再次修改该参数。当然重启虚拟机,或者虚拟机内Guest操作系统中的任何操作,都不会重置该参数。
Related posts:
Whether you build dashboards using OBIEE, Cognos or SAP Business Objects, it is always a pain to build quick dashboard prototypes to demonstrate users and build project momentum.
Project Momentum is very important in predicting the outcome of your new project proposal.
Before the client approaches you for a quote and a POC they have definitely done some internal research and probably installed the basic setup. So why waste time in demonstrating the same packaged OBIEE stuff which your client has already done it by visiting various blogs and updates on the web.
What is so unique that you can demonstrate?
This is something that will catch your client’s attention among heaps of other consultant companies.
But producing them is time consuming with the toolset itself.
So why not just build some cool wireframes and prototypes and send your unique approach to your potential client?
This is so easy. Just login to https://www.wireframes.org and build your dashboard prototype, add some cool visualization, comments and demonstrate how different your dashboard can be.
For e.g OBIEE is fully web based and using jquery and various plugins it is possible to completely blow the minds of everyone when you demonstrate something so cool done in OBIEE which no one has ever dared to do it till now.
Good tidings for the season to all of you. Its been erratic I know but we have stumbled along this year ...
I have been working with Eric, a Siebel sales consultant whiz on the BIP integration. He shared some really useful tips with a Siebel-BIP customer yesterday which I thought were well worth sharing.
Date Formatting
Firstly, some help with formatting dates when you are using a Siebel integration objects to generate the data. Siebel IOs do not generate the XSD date format that BIP needs to let you format dates to your hearts content. Attached are a couple files that provide some examples on how to manipulate dates to get the desired formats. Some are easy to get working and some need a little effort.
MSWord Plugin Testing
Siebel development have shipped some Siebel-BIP functions that are deployed to the server. However, to be able to test them locally on your desktop you need to get the java libraries into your classpath prior to starting MSWord. Here is the code Eric uses for starting Word with the Siebel classes in a batch
file. It assumes that the jar files are available locally on the client machine
at C:\811DQSSIA\Client\CLASSES. This will make the classes used by some
Siebel report templates available to test directly in Word. I have two
versions, one for Word 2003 and one for Word 2007.
Word 2003:
echo %1
set _JAVA_OPTIONS=-Xbootclasspath/a:C:\811DQSSIA\Client\CLASSES\SiebelXMLP.jar;C:\811DQSSIA\Client\CLASSES\XMLP.jar;C:\811DQSSIA\Client\CLASSES\Siebel.jar;C:\811DQSSIA\Client\CLASSES\XSLFunctions.jar;C:\811DQSSIA\Client\CLASSES\SiebelCustomXMLP.jar;C:\811DQSSIA\Client\CLASSES\SiebelCustomXMLP_SIA.jar;
"C:\Program Files\Microsoft Office\Office12\Winword.exe" %1
Word 2007:
echo %1
set _JAVA_OPTIONS=-Xbootclasspath/a:C:\811DQSSIA\Client\CLASSES\SiebelXMLP.jar;C:\811DQSSIA\Client\CLASSES\XMLP.jar;C:\811DQSSIA\Client\CLASSES\Siebel.jar;C:\811DQSSIA\Client\CLASSES\XSLFunctions.jar;C:\811DQSSIA\Client\CLASSES\SiebelCustomXMLP.jar;C:\811DQSSIA\Client\CLASSES\SiebelCustomXMLP_SIA.jar;
"C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft Office\Microsoft Office Word 2007.lnk" %1
Happy Holidays!


Best 2-CPU server result ever - with Violin's chips. Oracle claims a world-record TPC-C result with its database running on a Cisco server and not an Exadata system, although doesn't mention that two Violin memory flash arrays were needed.
今天有客户的数据库意外被删除了整个目录中的数据文件,操作系统级别的删除,然而幸运的是这个数据库没有崩溃,仍然处于open状态的时候,客户就发现了问题,求助到我们,最终完整地恢复了所有数据文件。
在Linux下大致重新演示一下恢复的过程,恢复的步骤与数据库版本没有太大关系,与操作系统的不同会有所不同。
1. 在数据库open的时候,直接删除users表空间中的数据文件。
SQL> select name from v$datafile; NAME -------------------------------------------------------------------------------- /app/oracle/oradata/ORCL/datafile/o1_mf_system_555wqbnk_.dbf /app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_555wqxgl_.dbf /app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_555wr5p6_.dbf /app/oracle/oradata/ORCL/datafile/o1_mf_users_555wrj4o_.dbf SQL> host rm /app/oracle/oradata/ORCL/datafile/o1_mf_users_555wrj4o_.dbf
2. 尝试在users表空间中创建表,开始报错。
SQL> create table t tablespace users as select * from dual;
create table t tablespace users as select * from dual
*
ERROR at line 1:
ORA-01116: error in opening database file 4
ORA-01110: data file 4:
'/app/oracle/oradata/ORCL/datafile/o1_mf_users_555wrj4o_.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3
在告警日志中,同样也可以看到类似信息。
Mon Dec 19 21:48:17 CST 2011 Errors in file /app/oracle/admin/orcl/bdump/orcl_m000_3897.trc: ORA-01116: error in opening database file 4 ORA-01110: data file 4: '/app/oracle/oradata/ORCL/datafile/o1_mf_users_555wrj4o_.dbf' ORA-27041: unable to open file Linux Error: 2: No such file or directory Additional information: 3
3. 检查dbwr的进程PID
$ ps -ef|grep dbw0|grep -v grep oracle 2879 1 0 21:38 ? 00:00:00 ora_dbw0_orcl
4. dbwr会打开所有数据文件的句柄。在proc目录中可以查到,目录名是进程PID,fd表示文件描述符。
$ cd /proc/2879/fd $ ls -l total 0 lr-x------ 1 oracle dba 64 Dec 19 21:50 0 -> /dev/null lr-x------ 1 oracle dba 64 Dec 19 21:50 1 -> /dev/null lr-x------ 1 oracle dba 64 Dec 19 21:50 10 -> /dev/zero lr-x------ 1 oracle dba 64 Dec 19 21:50 11 -> /dev/zero lr-x------ 1 oracle dba 64 Dec 19 21:50 12 -> /app/oracle/product/10.2.0/db_1/rdbms/mesg/oraus.msb lrwx------ 1 oracle dba 64 Dec 19 21:50 13 -> /app/oracle/product/10.2.0/db_1/dbs/hc_orcl.dat lrwx------ 1 oracle dba 64 Dec 19 21:50 14 -> /app/oracle/product/10.2.0/db_1/dbs/lkORCL lrwx------ 1 oracle dba 64 Dec 19 21:50 15 -> /app/oracle/oradata/ORCL/controlfile/o1_mf_555wq3ng_.ctl lrwx------ 1 oracle dba 64 Dec 19 21:50 16 -> /app/oracle/oradata/ORCL/datafile/o1_mf_system_555wqbnk_.dbf lrwx------ 1 oracle dba 64 Dec 19 21:50 17 -> /app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_555wqxgl_.dbf lrwx------ 1 oracle dba 64 Dec 19 21:50 18 -> /app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_555wr5p6_.dbf lrwx------ 1 oracle dba 64 Dec 19 21:50 19 -> /app/oracle/oradata/ORCL/datafile/o1_mf_users_555wrj4o_.dbf (deleted) lr-x------ 1 oracle dba 64 Dec 19 21:50 2 -> /dev/null lrwx------ 1 oracle dba 64 Dec 19 21:50 20 -> /app/oracle/oradata/ORCL/datafile/o1_mf_temp_555wrbnz_.tmp lr-x------ 1 oracle dba 64 Dec 19 21:50 21 -> /app/oracle/product/10.2.0/db_1/rdbms/mesg/oraus.msb lr-x------ 1 oracle dba 64 Dec 19 21:50 3 -> /dev/null lr-x------ 1 oracle dba 64 Dec 19 21:50 4 -> /dev/null l-wx------ 1 oracle dba 64 Dec 19 21:50 5 -> /app/oracle/admin/orcl/udump/orcl_ora_2871.trc l-wx------ 1 oracle dba 64 Dec 19 21:50 6 -> /app/oracle/admin/orcl/bdump/alert_orcl.log lrwx------ 1 oracle dba 64 Dec 19 21:50 7 -> /app/oracle/product/10.2.0/db_1/dbs/lkinstorcl (deleted) l-wx------ 1 oracle dba 64 Dec 19 21:50 8 -> /app/oracle/admin/orcl/bdump/alert_orcl.log lrwx------ 1 oracle dba 64 Dec 19 21:50 9 -> /app/oracle/product/10.2.0/db_1/dbs/hc_orcl.dat
注意其中“/app/oracle/oradata/ORCL/datafile/o1_mf_users_555wrj4o_.dbf (deleted)”字样,表示该文件已经被删除,如果是Solaris操作系统,ls命令不会有如此清晰的显示,为了在Solaris系统中确认哪个句柄对应哪个文件,则需要使用lsof程序。
5. 直接cp该句柄文件名回原位置。
cp 19 /app/oracle/oradata/ORCL/datafile/o1_mf_users_555wrj4o_.dbf
6. 进行数据文件recover
SQL> alter database datafile 4 offline; Database altered. SQL> recover datafile 4; Media recovery complete. SQL> alter database datafile 4 online; Database altered.
完成数据文件恢复。
恢复的原理是,在Linux操作系统中,如果文件从操作系统级别被rm掉,之前打开该文件的进程仍然持有相应的文件句柄,所指向的文件仍然可以读写,并且该文件的文件描述符可以从/proc目录中获得。但是要注意的是,此时如果关闭数据库,则此句柄会消失,那么除了扫描磁盘进行文件恢复之外就没有其它方法了,因此在数据库出现问题的时候,如果不确认情况的复杂程度,千万不要随便关闭数据库。重启数据库往往是没有意义的,甚至是致命的。
当然,客户的操作系统是Solaris,并且客户删除的文件还包括current online redo log,因此还有其它更复杂的操作,不在这里描述。
Related posts:
今天上午为2011中国软件技术大会作的演讲,题目是《VLDB Statistics Gathering Strategy – Something You Need to Know But Maybe You Don’t》
Vldb Statistics Gathering Strategy View more presentations from kamusis内容实际上是分为两个部分:
1. 我认为理想的数据库表直方图信息收集的策略,这在我之前的文章-Oracle Histogram Investigation也有所描述。
2. 在使用granularity参数进行分区表统计信息收集的时候,有一些需要注意的问题,产生聚合统计信息是高效的方法,但是聚合统计信息在某些场景下却并不会如你所愿的生成。
Related posts:
By Ari Levy
Jive Software's initial public offering this week sparked a debate over the meaning and merits of "cloud software."
As a decade-old company that got started when business software was delivered in packages, Jive didn't start selling Web-based subscriptions until 2007. About 60 percent of its business is now in the cloud. Clients use their software to collaborate with each other and customers.
The cloud model is cheaper to operate, allows for faster product updates and is better at collecting large amounts of data. Companies like Salesforce.com and SuccessFactors, which SAP agreed to acquire this month, are completely Web-based and valued more highly by the public markets on a price-to-sales basis than Oracle and Microsoft.
At the close of trading today, Jive had a stock market valuation of $859.5 million, or 12 times revenue over the past year. SAP paid 11.7 times sales for SuccessFactors, while Oracle has a ratio of 4.1 and Microsoft's is 3.
"There's just one problem with Jive trying to ride the coattails of SuccessFactors and other cloud company valuations: Jive is not cloud," says David Sacks, founder of Yammer, which also provides social-networking software to businesses.
If you believe Jive's pitch, it gets the best of both worlds. The company competes for customers that are pure cloud and comfortable having all their data hosted off-site. Yet, it can also sell to more highly-regulated companies in health care and financial services that need dedicated servers and aren't ready to make the move.
"We're not religious about it," Jive CEO Tony Zingale said in an interview yesterday, after ringing the opening bell on the Nasdaq Stock Market. "We let customers choose."
Taleo, like Yammer, prefers not to offer the choice. Its software, which competes with SuccessFactors in delivering talent management software, is for companies that are in the cloud or quickly migrating. Trying to deliver products the old way would just slow it down, says Jason Blessing, an executive vice president at Taleo.
What about security and privacy concerns? Those are overblown, he says. Taleo sells to the U.S. Department of Justice, and it doesn't get much more sensitive than that.
"Security issues have almost faded completely into oblivion," he says.
By Adam Satariano
Apple has given developers a holiday deadline if they want the most recent versions of their games, photography, productivity or other applications available in the App Store when people start cashing in their iTunes gift cards.
According to a note Apple sent to developers last month, the company is shutting down from Dec. 22-29 for the winter holidays. That means in addition to engineers setting aside the development of future iPhones and iPads, the company's developer relations and application review teams are also heading for the eggnog. (Apple's retail operation will remain open.)
Apple approves each application that's available in its App Store. While it's Cupertino, California, headquarters are closed, no apps can be approved. Apple, which also closed the week of Thanksgiving, warned developers that any apps scheduled to go live during the company shutdown would be delayed until after employees return from the holiday reprieve.
Those not paying attention to the warning may find their apps temporarily dropped from the App Store. Apple told developers not to schedule any app pricing changes during that period because the system will be closed and the price change will cause the app to be unavailable for purchase.
After rushing to get their apps turned in, perhaps the slew of startups making the more than 500,000 applications available in the App Store will use the shutdown to take their own holiday break.
By Olga Kharif
A joint venture of AT&T Mobility, T-Mobile USA and Verizon Wireless wants to bring its mobile-payment technology to markets outside the U.S., as companies try to grab a piece of the fast-growing digital wallet business.
The venture, ISIS, has held discussions to explore international opportunities, said Jaymee Johnson, a spokesman. He declined to name prospective partners, who could choose to use ISIS's brand or its technology.
ISIS is competing with Google Inc. and other consortiums and startups in the mobile payments arena. Their goal: To allow consumers to use their phones to make credit- or debit-card purchases in stores. The worldwide market is expected to reach $670 billion in total transactions by 2015, up from $240 billion this year, according to Juniper Research.
``The underlying equity partners in ISIS give us some degree of visibility and awareness beyond the U.S.,'' Johnson said in an interview. One of Verizon Wireless's two parent companies is Vodafone Group Plc, based in the U.K., while T-Mobile USA is owned by Germany's Deutsche Telekom AG.
ISIS is playing catch-up with Google in the U.S. The company's Google Wallet service launched in September, while ISIS's effort will start in two cities in mid-2012. Google's service has recently run into problems: Verizon Wireless blocked it from the new Galaxy Nexus smartphone, citing security concerns.
Industry support for ISIS is growing. This week, the venture announced that Gemalto NV will be one of its technology providers in the U.S. The company is the world's biggest maker of smart cards, which contain embedded memory chips used to carry out various functions such as access control and payment transactions.
ISIS has also announced agreements with payment networks including Visa Inc. and handset makers including Motorola Mobility Holdings Inc.
By Brian Womack
Rocket Fuel Inc., an online advertising company, may join what's becoming a long parade of technology companies.
If market conditions allow, Rocket Fuel is aiming for an initial public offering in 2012 as the company expands its sales, said Chief Executive Officer George John. Rocket Fuel will have more than $40 million in revenue this year, up from about $16 million in 2010, he said. That's more than Zillow Inc., the online real estate company, had before its IPO earlier this year, John said.
The company, which helps companies place ads on websites and mobile devices in real time, is benefiting from international growth and strong demand from current customers. More than 90 percent of its clients renewed spending on Rocket Fuel in the third quarter from the second quarter, he said. Those customers increased their spending by an average of 50 percent.
The company's backers include Nokia Growth Partners and Northgate Capital. Before a potential public offering, the Redwood City, California-based company plans to raise capital in the first quarter to fund growth and acquisitions, he said.
``If there's a speed limit for us, we haven't found it yet,'' John said.
Other initial public offerings this past year include Groupon Inc., the daily deals site, and LinkedIn Corp., the professional services networking service.
各城市书友会地址:
北京,西直门附近奇遇花园,
18号(周日)、下午14:30,
联系人:Kent.Zhu 13716983554
上海,长宁区江苏路369号(愚园路口)兆丰世贸大厦28楼 分众传媒 第一会议室(分众驿站旁)
主题:坎坎坷坷又一年 —— 年终大盘点
18号(周日)、下午14:30,
联系人:EOL 13661653237
南京,长江后街6号6号楼3楼 途牛旅游网
18号(周日)、下午14:30,
联系人:JunChen 18602513365
深圳,
本期暂停
联系人:周陟 13723766365
广州,广州市天河区建中路26号315房(广州科韵路工业园管理处左侧)
17号(周六)、下午14:30,
联系人:胡晓 18666088119
杭州,西湖区通普路41号 BetaCafe
主题:去你的2011. 年终盘点
18号(周日)、下午14:30,
联系人:稻草 13858008642
厦门,厦门市洪莲路20号楼19号(厦门牛庄文创园·@爱特咖啡)
主题:跨平台产品设计、年终盘点
17日(周六)、下午14:30,
联系人:中华 18605926895
成都,春熙路小科甲巷1号第一城B座6楼,民土咖啡馆(电话028-86730998)
18号(周日)、下午14:30,
联系人:老妖 13550272317
福州,鼓楼区温泉支路58号杨振华851(网龙公司)飘渺庄 形体房
18号(周日)、下午14:30,
联系人:苏伟华 18659139527
书友会详细信息:http://ucdchina.com/club/
转载请注明出自UCDChina.com,谢谢。
相关文章
![]() | Oracle CEO's beautiful Woodside farm - Rediff.com Business Passionate about buying land, Ellison, co-founder and chief executive officer of Oracle Corporation, has acquired some of most beautiful houses and land since the 1990's. | Oracle CEO's beautiful... |
By Olga Kharif
California Attorney General Kamala Harris today unveiled a new push to fight technology crimes and identity theft in a state that's home to companies such as Google Inc., Apple Inc. and Facebook Inc.
Comprising 20 investigators and prosecutors, a high-tech unit announced today may be the largest such team in the country and will tackle crimes such as identity theft, child pornography and software piracy, as well as thefts of iPads and other devices made and imported into California, said Shum Preston, a spokesman for the California State Department of Justice. The agency's ECrime unit, formed in August, has filed 20 criminal cases to date and is investigating an additional 24, Preston said in a telephone interview.
More than 1 million Californians become victims of identity theft every year and total losses in the state exceeded $46 million in 2010, according to a department statement.
The ECrime unit will target criminals who ``increasingly use the Internet, smartphones, and other digital devices to victimize people online and offline,'' Harris said in the statement.
By Danielle Kucera
Christmas-tree farmers like Joe and Kay Gersch helped push Square Inc. past the one-million merchant customer mark in time for the yearend holidays.
Square, the mobile-payments provider created by Twitter Inc. co-founder Jack Dorsey, reached the milestone last week.
Small businesses like Yawn Station Christmas Tree Farm , located in Independence, Louisiana, are crucial to helping Square compete in the market for mobile payments, which may exceed $170 billion by 2015, compared with an estimated $60 billion this year, according to Juniper Research. The company is vying with companies such as EBay Inc.'s PayPal, which has 103 million users and also is encouraging shoppers to use smartphones to buy through its payments network.
Square's technology lets businesses handle payments via Apple Inc.'s iPhone and iPad, as well as devices running on Google Inc.'s Android software. The card reader plugs into the headphone jack of the mobile device and lets merchants swipe customers' credit and debit cards.
The ability to take credit cards has increased sales by about 40 percent at Yawn Station Christmas Tree Farm, Joe Gersch said. ``If everyone came and paid with credit or debit it would save me money, because it would cost me less than I pay in gas to go to the bank and deliver the deposits,'' he said. ``Most of my older customers already knew I only accepted cash or check, so the people that I've already used Square with have been new.''
Square is targeting small businesses that may not be able to afford traditional machinery that handles credit cards, Chief Operating Officer Keith Rabois has said. Gersch, 65, had to buy his first smartphone to operate the card reader. He signed up for the service about three weeks ago after Square called and pitched its service, he said.
Customers who visit Yawn Station sometimes spend the whole day at the farm, picking a tree and chopping it down themselves. Before now, someone without cash would have to drive 20 miles to the nearest automated teller machine before they bought a tree or any of the add-ons the farm offers - wreaths, for instance, or a horse-drawn carriage ride, Gersch said.
The sales will help Yawn Station sell 1,000 to 1,200 trees this season at an average $55 to $60 apiece, more than the 800 it sold last year, Gersch said. ``Customers don't realize I work 365 days a year to provide that tree,'' said Gersch, whose farm has about 7,000 trees. ``We're trying to provide an entire experience when you come here.''
(This story was updated to include Ranadive's title in the headline).
By Aaron Ricadela
Meg Whitman, Chad Hurley, Tom Siebel and a passel of Golden State Warriors joined more than 300 other guests crammed in Tibco Software CEO Vivek Ranadive's Atherton, Calif., mansion Saturday night for the executive's annual Christmas bash. Amid the Indian buffet, sushi station and several wet bars deployed around the manse, Whitman took time out to tell me about her long-term plans at Hewlett-Packard, where she's CEO.
Whitman, who took the reins Sept. 22, says she plans to stay at HP for a while. The company needs a CEO who's going to stick around, she says, and she decided when accepting the job that she wouldn't take a future position working for her friend and political ally Mitt Romney, should he win next year's presidential election. Whitman is HP's third CEO in a year and a half; she replaced Leo Apotheker, who lasted less than 11 months after succeeding Mark Hurd.
"I couldn't take it and then leave," says Whitman, who attended with her husband, the neurosurgeon Griffith Harsh.
After losing last year's California gubernatorial election to Jerry Brown, Whitman -- who was CEO of EBay for 10 years until 2008 -- didn't plan on becoming a CEO again, she says. Now, she's taking a pragmatic approach to solving HP's woes, which included several quarters of disappointing sales forecasts under Apotheker and his ill-fated decision to explore a spin-out of HP's PC group.
Other guests at the swanky soiree, staffed by legions of waiters, bartenders and valets, included the Siebel Systems founder, YouTube founder Hurley, SAP Chief Technology Officer Vishal Sikka, and the academic Vivek Wadhwa. Also in attendance were players for the NBA's Golden State Warriors, which Ranadive partly owns.
Ranadive, who runs business software maker Tibco, has also been profiled by the New Yorker's Malcolm Gladwell for the way he coached his daughter's school basketball team, which ended up at the national championships. During the party, Ranadive's home basketball court, which sits below his finished basement, became a dance floor for the younger attendees.
By Douglas MacMillan
As Mark Pincus enters the final days of Zynga's road show, he's aiming to sell investors on the prospects for the social-gaming startup, set to raise $1 billion in an initial public offering later this week.
It's a reversal of roles for Pincus, a finance whiz who once worked as an investment banking analyst and who has, over the past decade-and-a-half, amassed a portfolio of early investments in some of tech's hottest startups.
Pincus is one of the earliest and most consistent backers of social media. Through an acquaintance with Peter Thiel, Pincus got a chance in 2004 to participate in the first outside funding round of Facebook, as I wrote in a profile this week.
According to Thiel, Pincus and Reid Hoffman were the only angel investors who were interested in taking a chance on the startup at the time. Pincus was also an investor in Friendster, the social media pioneer that was quickly overshadowed by MySpace and Facebook. While that bet soured as Friendster fizzled, Pincus may fare better from his stakes in three social-Web up-and-comers: Twitter, Buddy Media and LikeALittle.
A few of the bets placed by Zynga founder have already paid off. Impulse Buy Network, an e-commerce service provider, was acquired in 1999 by Inktomi for about $112 million. Spam blocker Brightmail, another Pincus investment, was bought by Symantec in 2004 for about $300 million.
Other startups he's backed include Napster, Xoom, Seesmic, Grockit, EVDB (later renamed Eventful), Technorati, Feedster, Socialtext, Nanosolar, Mahalo and 360buy.
Pincus is also an avid investor in the public markets, and has described his investing strategy on his blog. "I love investing, especially in public securities where you get an immediate score card of how you're doing," he wrote in 2005. "My reality is that I will always be a macro investor, meaning I invest in big picture themes rather than based on detailed fundamental analysis."
He got in on Google's IPO in 2004, a bet that has netted fivefold returns. In 2005, he recommended buying Amazon.com and shorting eBay, writing, "it seems clear that Amazon should one day be worth more than eBay." Six years later, Amazon's $86 billion market cap is more than double eBay's. Pincus also bragged in 2007 that he sold Yahoo when the stock was trading at $32. It's now trading at less than half that.
Pincus is not one to shy away from sharing investing insights. In late 2002, he called his friend and fellow tech entrepreneur Auren Hoffman, advising him to buy shares of Corio Inc., a little-known software outfit then trading at about 50 cents. Hoffman shrugged off the stock tip, and then watched as Corio shares rose seven-fold over the next year. It was later bought by IBM.
"He's incredibly perceptive financially -- much more so than any tech entrepreneur I know," says Hoffman, who now runs Web analytics firm Rapleaf. "You should always bet on Mark."
By Peter Burrows
After Sarbanes-Oxley became the law of the land in 2002, there was hand-wringing over whether public companies would be able to keep great directors on their boards. In the tech industry, at least, the more pressing issue seems to be getting them to leave.
According to a survey in late November by recruiting firm Spencer Stuart, board turnover at tech firms fell for the third year in a row this year. Only 29 percent of Silicon Valley firms added a new director in 2011, compared to 50 percent in 2008.
That's not necessarily a bad thing. During turbulent economic times, it's best to stick with proven quantities rather than introduce even more change, says study co-author Jonathan Visbal. "Boards have been battening down the hatches to ensure consistency," he says.
Another reason to stick with known quantities is the increasing difficulty in finding the people most CEOs would most like to have on their boards: other CEOs. In recent years, many boards have added by-laws that restrict their CEO from sitting on more than one or two outside boards. In particularly short supply: CEOs who have expertise in digital media, to help companies acclimate to the post-Facebook world.
"Often companies go with younger candidates who may not have much experience, but that's the trade-off they need to make," says Visbal.
As for the directors themselves, it seems the trade-offs are getting easier. For the year, the average number of board meetings fell to 8, from 9.7 two years ago. Yet director pay increased 14 percent, to an average of $251,630. And the pay is far more reliable, since more of it is paid in cold hard cash. The number of companies that gave stock options to directors fell to 60 percent, from 72 percent in 2010. Restricted stock awards were also down, to 58 percent from 65 percent in 2010. While cash retainers fell slightly as well for the year, they're up 78 percent since 2003, says study co-author Nyla Rizk.
The data comes in a year that has had more than its share of corporate governance fiascos. Yahoo fired Carol Bartz without having a successor in place. HP pushed out Leo Apotheker after less than a year on the job, and replaced him with director Meg Whitman. Still, the co-authors say the data does not suggest a decline in the quality of governance in tech.
"Governance has gotten better," says Rizk, who notes that the number of boards that separate the chairman and CEO duties has risen from 45 percent in 2003 to 73 percent.
Since one wouldn't expect a recruiter to bash his potential clients, I asked Paul Hodgson, a researcher with the Corporate Library, a corporate governance advisory firm, if he agreed that the fall in turnover was no cause for concern. He did.
"It's a smart thing to do to stick with people who know the business well -- unless, of course, you have a lousy board," he says.

