天行健，君子以自强不息

Oracle RAC Team Hiring……
在Oracle公司内部学习Oracle，学习Oracle的最佳学习环境，Oracle RAC是Oracle数据库产品中最富有发展潜力的技术和选件，Oracle RAC team招人进行中。。。如果你还不知道RAC是什么，也许可以先看看RAC的介绍或者白皮书

本次开放的职位是专门针对应届硕士毕业生（注意，是今年毕业的应届毕业生），今年7月或者年底之前毕业的均可，欢迎自荐或者推荐你的亲朋好友，工作地点在深圳，中英文简历请发送至： ricky.zhu@oracle.com （勿用163信箱发送，勿压缩，Oracle邮件系统拒收）

职责和要求如下仅供参考：(注意，是仅供参考）
Department:
Real application cluster (RAC) development.

Brief description:
responsible for implementing, maintaining, and enhancing test scripts, plan, and methodologies that ensure exhaustive testing of all assigned software areas to ensure software quality by exposing defects, and verifying resolutions. this is the golden opportunity to learn oracle within oracle, the challenging position provides training to lay the foundation of rac and database high availability. engineer will expose to latest oracle technologies on varies platforms. those experiences are extremely valuable toward the building solid foundations of rac and high availability systems for future system architecture integration and consulting work.

Detailed description:· leads the technical logistics behind installation, configuration, testing, defect tracking and reporting of all assigned projects
· projects include rac high availability and cluster ready system, oracle 11g’s plug & play features, oracle file system testing.
· oracle certification environment program
· oracle rac integration/upgrade tests among different platforms (linux, aix, hp-ux, solaris 64, and windows)
· product training and user documentation review
· oracle rac destructive and stress testingprofessional background

the candidate must either have a minimum of 2 years in the enterprise software industry or degree in computer science or related fields. prior experiences as a member of oracle dba, customer support, technical consulting, product development or qa teams are preferred.

Technical background:· proficient knowledge of unix/linux, and at least one of shell scripting languages.
· must have experiences in any one of the following platforms: linux, hp-ux, solaris 64, ibm/aix, windows.
· experience designing and executing destructive or performance tests is a plus.
· experience with software development lifecycle or software testing is a plus.
· experience with oracle rac is a plus.
· experience in clustered server environments or oracle rdbms is preferred.personal profile / skills:
· quick and willing to learn, self-motivator, attention to details and team player
· good verbal and written communication skills in english
· ability to multitask and deliver under pressure
· good academic records for entry-level position, new graduate welcome

Share This

Oracle database 10.2.0.4 patchset的Windows版本和Linux版本发布已经有一段时间了
在最新的Oracle数据库产品中，Windows和Linux平台是基础平台，新版本或者patchset的发布一般首先是这两大平台，然后是三大UNIX平台即AIX，HP-UX和Solaris

现在Oracle Database 10.2.0.4也就是Oracle Database的第三个大的patchset Solaris版本和HP版本已经发布几天了，在metalink上已经提供下载，AIX平台估计很快也提供下载。patch number是6810189 ，大小大概1个G左右，够大的。

请到updates.oracle.com下载（需要Metalink帐号）

….
230-
230- Welcome to the Oracle Patch Download FTP Server
230-
230- For detailed help, use command “quote site help”.
230
ftp> cd 6810189
250 Changed directory OK.
ftp> dir
200 PORT command OK.
150 Opening data connection for file listing.
total 1
-r–r–r– 1 root other 1758061824 Apr 30 20:58 p6810189_10204_HPUX-IA64.zip
-r–r–r– 1 root other 1195551830 Mar 17 05:36 p6810189_10204_Linux-x86-64.zip
-r–r–r– 1 root other 1053748381 Feb 22 18:58 p6810189_10204_Linux-x86.zip
-r–r–r– 1 root other 1276477084 Apr 30 19:25 p6810189_10204_Solaris-64.zip
-r–r–r– 1 root other 1034079272 Mar 18 00:03 p6810189_10204_Win32.zip
226 Listing complete. Data connection has been closed.
ftp: 收到 444 字节，用时 0.00Seconds 444000.00Kbytes/sec.
ftp>

从上面的截图看，Solaris和HPUX-IA都是在4月30号发布的。

2008-05-15 update: 10.2.0.4 Patch Set for AIX also released

Share This

市面上关于Oracle RAC的书不多，关于ASM的新书更是少之又少，隆重向大家推荐一本ASM的新书。

Oracle Automatic Storage Management
Under-the-Hood & Practical Deployment Guide

作者是Oracle公司RAC部门的几位数据库专家。Rich Long更是ASM的开发总监。
下面是本书的简单介绍:

http://www.mhprofessional.com/product.php?isbn=0071496076

Streamline data management and provisioning using Oracle Automatic Storage Management (Oracle ASM) and the detailed information contained in this exclusive Oracle Press resource. Written by a team of database experts, Oracle Automatic Storage Management: Under-the-Hood & Practical Deployment Guide explains how to build and maintain a dynamic, highly available Oracle database storage environment. Inside, you’ll learn how to configure storage for Oracle ASM, build disk groups, use data striping and mirroring, and optimize performance. You’ll also learn how to ensure consistency across server and storage platforms, maximize data redundancy, and administer Oracle ASM from the command line.

* Manage Oracle ASM Instances and configure Oracle RDBMS instances to leverage Oracle ASM
* Define, discover, and manage disk storage under Oracle ASM
* Create external, normal-redundancy, and high-redundancy disk groups
* Add and remove Oracle ASM storage without affecting RDMS instance availability
* Learn how Oracle ASM provides even I/O distribution
* Work with Oracle ASM directories, files, templates, and aliases
* Improve storage performance and integrity using the ASMLIB API
* Simplify system administration with the Oracle ASM command line interface
* Understand key internal Oracle ASM structures and algorithms

作者简介：
Nitin Vengurlekar works at Oracle in the Real Application Cluster (RAC) engineering group, with specific emphasis on ASM. Nitin is a popular conference presenter on this topic.
Murali Vallath is an Oracle Certified Database Administrator and is president of the Oracle RAC Special Interest Group.
Rich Long is Director of Development for Automatic Storage Management at Oracle and has managed ASM development since the project’s inception.

Share This

疯狂的家庭，对于理解oracle数据库的结构和工作原理非常有好处，转载自Alibaba DBA Team的博客，原始出处和作者不知道是某位高人

==

一个名叫Sid的男人，狂热地爱好拍摄、保存和整理照片。Sid的妻子名叫Debbie，他们有三个儿子Logan、Archie和Chuck。他有一所很大的房子，同住的有男管家Simon和女仆Pam。我将介绍他的家庭、他的房子和他的爱好：拍摄、收集和炫耀他的照片。
现在，Sid快乐地生活着—家庭、朋友和假期。他不时地拍照。事实上，他总是随身带着相机。他不想错过任何东西。每一个早餐、午餐和晚宴，都会被拍下来。当孩子们从学校回家，镜头摄入他们对父亲的问候。当孩子们做家庭作业的时候，“卡嚓、卡嚓、卡嚓”，照相机的快门响个不停。棒球赛上，儿子Archie的每一个投掷都被拍摄下来。学校的舞会上，Chuck的父亲拍下了每一个缓慢的舞步以及在苏打水机器旁的交谈。而他的狗——Sadie则是这个世界上被拍摄次数最多的狗。
他和他的家庭收藏了数以百万计的照片。一些照片被销毁掉了，一些则经历了改变。Sid有一套神奇的系统来处理这些照片。让我来告诉你一些关于他的家庭、他的房子的事，以及关于他和他的家人如何致力于发展、组织和保护所有这些照片。
Sid用一架特殊的相机拍摄。他的相机每拍摄一次，就同时产生一张照片和一张底片。他从来不用换胶卷（这是一种科幻技术）。照片被贴在房间的墙壁上，而底片则被保存在一个安全的地方。

1.1.1 Sid的家
我介绍过Sid的家了吗？嗯。那里非常的大而且到处都是照片。因为照片实在是太多了，所以Sid必须寻找地方来放置它们。一些照片被挂在墙上，一些被藏在照相簿内，一些被插入剪贴簿里，一些被放在储藏室的一个盒子里再也不会被撇上一眼。所有这些照片都被放在他家中的某处。他称呼这些放置照片的地方为“相片空间”。一个相片空间可能是一个有着很多墙壁的房间，或者是有着很多页的剪贴簿。一个房间是照片的逻辑存储单元。房间内的墙壁则是相片空间中保存照片的物理结构。
(more…)

Share This

Oracle性能分析入门学习中，遇到Oracle数据库的性能问题，一般首要的步骤就是导出AWR的分析报告，AWR是10g中新引入的一个工具，在这之前一般是利用statspack。要导出AWR报告，只要利用Oracle的一个脚本即可以完成，下面是我利用script录制的一段导出AWR report的过程。
首先进入$ORACLE_HOME/rdbms/admin目录，在sqlplus下运行@awrrpt脚本，按照提示一步一步就可以达成，导出的格式有两种，txt格式和html格式。

在OTN上，有一个DBA新feature系列，第六周就是专门讲的这个feature，大家可以去那里了解一下（中文的）

Script started on Sun 27 Jan 2008 08:47:15 PM PST
[ractest@sun880-1 /u01/app/oracle/orahome/rdbms/admin]$ cd $ORACLE_HOME/rdbms/admin

[ractest@sun880-1 /u01/app/oracle/orahome/rdbms/admin]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Sun Jan 27 20:47:38 2008

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> @awrrpt
(more…)

Share This

之前好几个同事聊天的时候，说想自己装个RAC玩玩，怎么的也得两个节点吧，不行就整个虚拟机。VM team的同事干脆就用Oracle VM了。其实个人玩RAC也不是不可能，只要解决几个关键的问题就行了，比如双网卡，共享设备等。其中最关键的就是共享设备了，在一个独立硬盘上创建裸设备，作为OCR和Voting DISK甚至ASM的磁盘，下面就介绍一下，在Linux下面如何创建裸设备，也就是create raw device. 大致这么几个步骤：

1. Check iscsi has been autoenable;
using “/sbin/chkconfig –list|grep iscsi”. If it is enabled, using “/sbin/chkconfig –level 2345 iscsi on” to enable it.
2. using “fdisk -l ” to check the partition information;
“/sbin/fdisk -l /dev/sde”, and then use “fdisk” to create new partitions
3. Create “/etc/udev/devices/raw” directory if it does not exist;
4. Create “/dev/raw” directory if it does not exist;
5. Create new raw device on each node, using:
“mknod /etc/udev/devices/raw/name c 162 2″
And then change the device permissions;
6. Edit “/etc/sysconfig/rawdevices” to add new items referring to new partitions on each node; such as “/etc/udev/devices/raw/name /dev/b_name”;
7. run “/sbin/udevstart” and check whether new raw devices have been generate in “/etc/udev/devices/raw” and “/dev/raw/”;
8. Changt the mode and own of the raw devices under “/dev/” directory;
9. service rawdevices restart

至此，就基本可以了，注意OCR和VD只能建在raw device上。
多谢blue_prince指正：其实OCR和VOTING DISK不一定非要在祼设备上面不可，以OCFS或者共享的NFS上面也可以的，只是可靠性不如祼设备那么强而已

Share This

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