天行健，君子以自强不息

MySQL被Sun收购了，今天早上从Sun的官方网站得到证实，这肯定会成为2008数据库市场的标志性收购事件，收购金额大概一个billion，10亿美金。(对数字太不敏感，犯了两次错误，多谢NinGoo老兄提醒)

现在老牌的几个大厂纷纷挥军进入软件行业，比如HP去年收购了Mercury，Dell据说也要开发自己的软件，现在Sun突然收购MySQL，正式进入数据库市场，这样就好玩多了，以后Sun和Oracle也是竞争对手了。

官方报道：
Sun announced an agreement to acquire MySQL AB, an open source icon and developer of one of the world’s fastest growing open source databases. This acquisition accelerates Sun’s position in enterprise IT to now include the $15 billion database market and reaffirms Sun’s position as the leading provider of platforms for the Web economy and its role as the largest commercial open source contributor.

恐怕过两天还有更猛的消息出来吧，期待。。。

不用过两天了，更猛的消息已经出来了：
Oracle最终终于收购bea了，成交价是每股$19.375，总价85亿美金，比较早前的每股$17稍高一些
就在同一天，Oracle收购了另外一家公司：Captovation

看来，Oracle的收购又进入高发期了。

Share This

众所周知，在安装Oracle Clusterware（Former Oracle CRS）之前，有一些必备的条件，比如双网卡，同版本的操作系统，一些必需的补丁等等，还有一些比如同样ID的组和用户，这些都可以通过clusterware附带的一个检查工具cluvfy进行检查。详细的列表和检查方法可以参考oracle的官方安装文档
除此之外，安装之前另外一个重要的前提就是ssh或者rsh的配置，这就是oracle在节点之间进行文件copy时候必须的，下面就分十个步骤介绍如何进行ssh的配置。

1. Login as oracle user
2. create .ssh directory in the oracle user’s home directory
$cd
$mkdir ~/.ssh
$chmod 700 ~/.ssh

3. Generate an RSA and DSA key for SSH
$/usr/bin/ssh-keygen -t rsa
$/usr/bin/ssh-keygen -t dsa

4. After this, four files generated
~/.ssh/id_rsa.pub
~/.ssh/id_rsa
~/.ssh/id_dsa.pub
~/.ssh/id_dsa

5. Create an authorized key file
$touch ~/.ssh/authorized_keys
$cd ~/.ssh
$ls

6. Copy the contents of rsa.pub and dsa.pub files to authrorized file
[oracle@node1 .ssh]$ ssh node1 cat /home/oracle/.ssh/id_rsa.pub >> authorized_keys
oracle@node1’s password:
[oracle@node1 .ssh]$ ssh node1 cat /home/oracle/.ssh/id_dsa.pub >> authorized_keys
[oracle@node1 .ssh$ ssh node2 cat /home/oracle/.ssh/id_rsa.pub >> authorized_keys
oracle@node2’s password:
[oracle@node1 .ssh$ ssh node2 cat /home/oracle/.ssh/id_dsa.pub >>authorized_keys
oracle@node2’s password:

7. Use scp to copy the authorized file to other nodes in ~/.ssh
[oracle@node1 .ssh]scp authorized_keys node2:/home/oracle/.ssh/

8. Change the permissions on the oracle user’s authorized file on all cluster nodes
$ chmod 600 ~/.ssh/authorized_keys

9. Enable OUI to use ssh and scp
$ exec /usr/bin/ssh-agent $SHELL
$ /usr/bin/ssh-add

10. Verify ssh configuration on all nodes
$ ssh nodename1 date
$ ssh nodename2 date

其他的具体步骤可以参考oracle的手册B28264-03，地址如下：
http://download.oracle.com/docs/cd/B28359_01/install.111/b28264/toc.htm

Share This

Has been the contributor to below Oracle 11g document set. (the last one in the long list)

Oracle Real Application Clusters Installation Guide, 11g Release 1 (11.1) for Linux and UNIX (B28264-03)
Oracle Clusterware Installation Guide, 11g Release 1 (11.1) for Linux (B28263-03)
Oracle Database Oracle Clusterware Installation Guide, 11g Release 1 (11.1) for AIX (B28258-01)
Oracle Clusterware Installation Guide, 11g Release 1 (11.1) for Solaris Operating System (B28262-02)
Oracle Clusterware Installation Guide, 11g Release 1 (11.1) for HP-UX (B28259-05)

Seems i haven’t contribute anything to HP-UX platform.

Share This

昨天公司发布了第二季度财报，增长率创下了10年来又一个新高，第一季度license费用已经创造了10年来的最高增长记录35%，第二季度在第一季度的基础上又创新高，达到38%。

下面是详细的数据（来自甲骨文官方网址）

Oracle Corporation today announced fiscal 2008 Q2 GAAP earnings per share were up 36% to $0.25, compared to the same quarter last year. Second quarter total GAAP revenues were up 28% to $5.3 billion, while quarterly GAAP net income was up 35% to $1.3 billion. Total GAAP software revenues were up 29% to $4.2 billion with GAAP new software license revenues up 38% to $1.7 billion. Database and middleware new license revenues were up 28% and applications new license revenues were up 63%. Services revenues were up 22% to $1.2 billion, compared to the same quarter last year.

Second quarter non-GAAP earnings per share were up 40% to $0.31, and non-GAAP net income was up 38% to $1.6 billion, compared to the same quarter last year.

“In Q1 we reported new software license revenues up 35%, the strongest growth of any quarter in ten years,” said Oracle President and CFO, Safra Catz. “In Q2 we did even better with new software license sales up 38%. GAAP EPS were up 36%; non-GAAP EPS were up 40%. We exceeded our guidance and our best case forecast with strong revenue growth across all product lines and geographies.”

“In Q2 Oracle’s applications new license sales grew 63% compared to SAP’s new license sales growth rate of 15% in their most recently completed quarter,” said Oracle President, Charles Phillips. “We like our growth strategy of expanding beyond ERP into high-end industry specific vertical software in contrast to SAP’s strategy of moving down market to sell ERP systems to small companies.”

“Our database and middleware new license sales grew 28% in Q2,” said CEO, Larry Ellison. “We continue to take market share from IBM in both product categories.”

Share This

如何更好的理解SunCluster的Quorum，也就是选举盘，下面就结合例子做介绍。
其实说到底就是两个公式：

一个是计算选举盘是否足够的公式：
Q=TCV/2+1
TCV就是当前cluster中配置的总票数，Toally configured Votes.
至于如何计算总票数，就是第二个公式了：
TCV=node 票数+device 票数
node票数很容易计算，每个节点一票
device票数计算方法是：
QD=TCD-1
TCD就是连接当前共享设备的所有的节点数-1

下面是详细的说明：
To form a cluster and offer services, the nodes in a cluster must first reach quorum. The quorum equation states that a cluster must have the total number of configured votes, divided by two (remainders are discarded), plus one (Q = TCV/2 + 1). If a cluster cannot reach quorum, then it does not form. The individual cluster nodes do not boot fully, but wait until enough votes are available to reach quorum. If a running cluster loses quorum, the affected nodes panic and try to reboot (assuming auto-boot? is set to true on those nodes). Machines can be booted outside the cluster by issuing a boot -x from the OBP, but no cluster services will be available on these machines.

The key to understanding quorum is learning how votes are assigned and counted. Each node in a configured cluster has one (1) quorum vote. Each shared storage device configured as a quorum device has votes totaling the number of connected devices minus one (QD = TCD - 1). Ownership of a quorum device is assigned to one controlling node based on SCSI reservations.
(more…)

Share This

因为测试需要，我会比较频繁的安装和卸载Oracle Clusterware，RAC，卸载和安装本身都有OUI工具可以使用，但是速度比较慢，而且需要过多的人工干预。如果直接把OracleHome删掉，杀掉所有相关进程，重启机器也可以解决问题，不过我认为这是一种比较粗暴的方式。
如果采用自动化的手段不仅可以提高效率，而且对于了解卸载本身的过程有一定帮助，今天就结合我写的一个简单的脚本介绍一下如何用六步快速安全卸载Oracle RAC。

脚本分为这么几个部分：
1. stop and delete RAC instance, drop the database
2. stop and delete ASM instance
3. stop and delete listener
4. stop crs stack and clean related resource
5. clean ocr context
6. change permission and remove related ORACLE directory and Clusterware directory

其中4，5都可以直接利用Clusterware 目录install下面的脚本进行，所以这里主要介绍1，2，3，6.
(more…)

Share This

关于在Linux下如何安装Oracle的raw device以及raw设备，块设备之间的关系和差别，请参考下面的FAQ，本文系转载，转载地址：

Q: 1. What is a raw device?

A:Raw device, also known as a raw partition is a disk partition that is not mounted and written by Linux filesystem (ext2/ext3, reiserfs) or by Oracle Cluster File System (OCFS), but is accessed by a character device driver. It is the responsibility of the application to organize how the data is written to the disk partition.

[top]
(more…)

Share This

1. SPARC: If your cluster is running Oracle Parallel Server or Real Application
Clusters, shut down all instances of the database.
Refer to the Oracle Parallel Server or Oracle Real Application Clusters product
documentation for shutdown procedures.
2. Become superuser on any node in the cluster.
3. Shut down the cluster immediately.
From a single node in the cluster, type the following command.
# scshutdown -g0 -y
4. Verify that all nodes are showing the ok prompt on a SPARC based system or a
Boot Subsystem on an x86 based system.
Do not power off any nodes until all cluster nodes are at the ok prompt on a
SPARC based system or in a Boot Subsystem on an x86 based system.
5. If necessary, power off the nodes.
(more…)

Share This