March 28th, 2008 1,518 Views
Oracle今天宣布从Empirix 公司手中收购e-TEST suite系列软件。
自从Oracle 去年推出Unbreakable Linux计划和今年年初收购BEA之后，产品线就日趋完善了，覆盖了从操作系统，数据库，中间件，到应用程序的企业级一揽子解决方案。大家可能已经注意到，在Oracle 11g中一个重要的feature就是RAT （real application testing），我感觉这是oracle涉及软件测试市场的一个前兆，现在oracle收购了e-TEST suite并把它集成到Enterprise Manager中去，并和RAT进行集成，更大大加强了Oralce在测试工具和应用测试方面的力量。
目前在企业级的测试工具市场上，HP和IBM主导占据了主导地位，HP-Mercury和IBM-Rational的系列测试解决方案产品占据了绝大多数的市场份额。Oracle现在携e-TEST suite涉足这一领域，也有有自身的优势，那就是跟自己产品的融合以及全套的解决方案系列。另外e-TEST suite本身也是一套完整的测试工具套件，包括功能测试工具e-Tester（类似Mercury Quick Test Professional和WR和Rational Functional Tester），e-Load（类似HP LoadRunner和Rational 的Performance Tester），e-Manager Enterprise （类似Merucyr Quality Center和Rational Test Manager），每一部分的功能都有自己的优势，下面是一个完整的介绍，有兴趣的朋友可以下载试用版试用。
e-Tester介绍：
阅读全文 »
Share This
归类于 测试工具 | 目前才1 条评论 »
March 21st, 2008 1,747 Views
市面上关于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
归类于 数据库, 存储 | 就等您评论了 »
March 5th, 2008 1,533 Views
做Clusterware和RAC的测试的时候，节点多的时候，需要不停的在节点之间切换，而且容易出错，于是写了这样一个脚本，跟大家分享一下。
目前主要完成一些简单的功能，支持的平台有Linux，Solaris, AIX and HP，打算继续扩展。也欢迎使用并提出意见，
-
-
[ractest@sun880-1 ~]$ more console
-
#!/bin/bash
-
-
#This script is used to control the whole cluster nodes in one interface
-
-
echo "******************************************************************"
-
echo " Welcome to Cluster Console "
-
echo " "
-
echo "The console is used to control the whole cluster nodes in one node"
-
echo "now it can support start/stop stack,check stack status, process "
-
echo "priority, check node uptime and will support more in the future "
-
echo " "
-
echo " Any bug or comment please report to ricky.zhu@gmail.com "
-
echo "******************************************************************"
-
-
get_nodename () {
-
$CH/bin/olsnodes -n > tmp
-
name=`head -n $1 tmp | tail -1 | awk ‘{print $1}’`
-
echo "$name"
-
}
-
check_uptime() {
-
-
nl=`$CH/bin/olsnodes `
-
for node in $nl
-
do
-
echo "node=$node"
-
$RSH $node "hostname; date; /usr/bin/uptime"
-
done
-
}
-
-
UNAME=‘/bin/uname’
-
PLATFORM=`$UNAME`
-
阅读全文 »
Share This
归类于 脚本语言 | 就等您评论了 »
February 4th, 2008 1,548 Views
疯狂的家庭，对于理解oracle数据库的结构和工作原理非常有好处，转载自Alibaba DBA Team的博客，原始出处和作者不知道是某位高人
==
一个名叫Sid的男人，狂热地爱好拍摄、保存和整理照片。Sid的妻子名叫Debbie，他们有三个儿子Logan、Archie和Chuck。他有一所很大的房子，同住的有男管家Simon和女仆Pam。我将介绍他的家庭、他的房子和他的爱好：拍摄、收集和炫耀他的照片。
现在，Sid快乐地生活着—家庭、朋友和假期。他不时地拍照。事实上，他总是随身带着相机。他不想错过任何东西。每一个早餐、午餐和晚宴，都会被拍下来。当孩子们从学校回家，镜头摄入他们对父亲的问候。当孩子们做家庭作业的时候，“卡嚓、卡嚓、卡嚓”，照相机的快门响个不停。棒球赛上，儿子Archie的每一个投掷都被拍摄下来。学校的舞会上，Chuck的父亲拍下了每一个缓慢的舞步以及在苏打水机器旁的交谈。而他的狗——Sadie则是这个世界上被拍摄次数最多的狗。
他和他的家庭收藏了数以百万计的照片。一些照片被销毁掉了，一些则经历了改变。Sid有一套神奇的系统来处理这些照片。让我来告诉你一些关于他的家庭、他的房子的事，以及关于他和他的家人如何致力于发展、组织和保护所有这些照片。
Sid用一架特殊的相机拍摄。他的相机每拍摄一次，就同时产生一张照片和一张底片。他从来不用换胶卷（这是一种科幻技术）。照片被贴在房间的墙壁上，而底片则被保存在一个安全的地方。
1.1.1 Sid的家
我介绍过Sid的家了吗？嗯。那里非常的大而且到处都是照片。因为照片实在是太多了，所以Sid必须寻找地方来放置它们。一些照片被挂在墙上，一些被藏在照相簿内，一些被插入剪贴簿里，一些被放在储藏室的一个盒子里再也不会被撇上一眼。所有这些照片都被放在他家中的某处。他称呼这些放置照片的地方为“相片空间”。一个相片空间可能是一个有着很多墙壁的房间，或者是有着很多页的剪贴簿。一个房间是照片的逻辑存储单元。房间内的墙壁则是相片空间中保存照片的物理结构。
阅读全文 »
Share This
归类于 数据库 | 已经有2 条评论 »
January 28th, 2008 7,972 Views
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
阅读全文 »
Share This
归类于 数据库 | 已经有5 条评论 »
December 24th, 2007 1,038 Views
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
归类于 数据库 | 目前才1 条评论 »
December 21st, 2007 1,281 Views
昨天公司发布了第二季度财报，增长率创下了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
归类于 数据库 | 已经有3 条评论 »
December 8th, 2007 1,425 Views
因为测试需要，我会比较频繁的安装和卸载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.
阅读全文 »
Share This
归类于 数据库 | 就等您评论了 »
