Archive

Posts Tagged ‘Oracle’

Oracle这些年的并购

August 6th, 2010 ricky.zhu 2 comments

记得早在07年的时候就总结过一个list,今天看到一个类似的图表,更加直接展示了收购的公司,规模和产业链中的位置。

who is next

refer

Categories: 业界, 数据库 Tags:

Oracle RAC Team招聘

July 27th, 2010 ricky.zhu No comments

Oracle RAC Team再次招兵买马,这次是社招职位,详细描述如下,欢迎高手自荐或者推荐。工作地点Prefer 深圳/北京

大家应该多少对Oracle RAC Team有所了解,在这里还是简单介绍几句:这支team主要成员在深圳和北京,从2006年成立至今,已经发展成30多人的队伍,承担了Oracle Clusterware/RAC/ASM 从10gR2,到11gR1, 11gR2的大大小小的版本和Patchset的Release测试。其中主要负责包括性能测试,功能测试,破坏性和压力测试在内的内容。

Title: (Senior) Member of Technical Staff, Server Technologies
Department: Real Application Cluster (RAC) Development.
Category: RAC Clustering and RDBMS testing
Salary Ranges: Competitive
Location:ShenZhen
Contact: ricky.zhu###oracle.com (replace ### with @)

Brief Description:
Responsible for RAC-DB stability and performance testing on varies platforms;responsible for understanding RAC functionality and Oracle rdbms&asm new features on varies releases and responsible for implementing, maintaining, and enhancing test infrastructure/tools and verifying testing results.

This is the golden opportunity to learn Oracle within Oracle, the challenging position provides training to lay the foundation of RAC and database stability, 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:
· Logs and tracks product defects as encountered.
· Specific Projects include: RAC stability bundle testing:
o Understand the vulnerabilities for each release.
o Ensure quality of post-release bundle deliverables by understanding new feature/enhancement and verifying various fixes.
o Enhance the test tools/infrastructure, aim to an automated testing framework with flexibility and simplicity.
o Understand RDBMS functions, especially in RAC environment, for detecting failure in functionality and usability.
· Various Workload understanding, placement, maintenance and enhancement.
In addition to these primary duties, the incumbent will also participate in additional tasks with other senior team members, e.g.:
· Product testing (beta and pre-release stress/destructive tests)
· Product training and user documentation review

Technical Background:
· At least 2 years experience in database environments and configuring/or testing/or administrating in Oracle 10g/11g. (Production/Testing environment).
· Good understanding of database architecture and terminology.
· Proficiency in Perl and other scripting languages; and plsql
· 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 in clustered server environments or Oracle RAC is preferred.
· Experience as an Oracle dba or Plsql developer 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

Categories: 数据库, 求职招聘 Tags:

如何修改Oracle 11gR2中的资源属性

July 25th, 2010 ricky.zhu Comments off

今天简单介绍下Oracle GI 11gR2中CRS相关资源属性的修改。

在Oracle 11gR2中,所有的资源在安装结束的时候都有一些默认属性。这里的资源不仅仅包含CRS资源比如nodeapps, asm, listener, db等等,也包括在11gR2中新引入的ohasd资源(当然crs也是OHASD资源的一种),包括crsd, gpnpd, gipcd, ctssd等等。这些属性比如超时时间,启动脚本,依赖关系等等。当然这里提供的只是一个方法,至于是否需要修改,什么时候修改则请慎重使用,而且很多资源资源是不被官方支持的。

在11gR2中,资源属性的查看方法是使用crsctl命令,另外简单提一句,经常看到很多人在查看资源的时候习惯于使用之前版本(10gR2, 11gR1)的一些命令,比如crs_stat, crs_start ,其实这些命令在11gR2已经废弃,保留他们的目的也只是为了向后兼容。在11gR2中另外一个推荐的命令就是srvctl。这两个命令在11gR2都得到了很大的增强,而且基本可以完成所有的管理任务了。

crsctl status resource -t 可以显示所有的CRS资源及状态

crsctl status resource -t -init 可以显示所有的OHASD资源及状态
bash-3.00# /u01/app/crshome/bin/crsctl stat res -t -init
——————————————————————————–
NAME           TARGET  STATE        SERVER                   STATE_DETAILS      
——————————————————————————–
Cluster Resources
——————————————————————————–
ora.asm
      1        ONLINE  ONLINE       node2                 Started            
ora.crf
      1        ONLINE  ONLINE       node2                                    
ora.crsd
      1        ONLINE  ONLINE       node2                                    
ora.cssd
      1        ONLINE  ONLINE       node2                                    
ora.cssdmonitor
      1        ONLINE  ONLINE       node2                                    
ora.ctssd
      1        ONLINE  ONLINE       node2                 OBSERVER            
ora.diskmon
      1        ONLINE  ONLINE       node2                                    
ora.drivers.acfs
      1        ONLINE  ONLINE       node2                                    
ora.evmd
      1        ONLINE  ONLINE       node2                                    
ora.gipcd
      1        ONLINE  ONLINE       node2                                    
ora.gpnpd
      1        ONLINE  ONLINE       node2                                    
ora.mdnsd
      1        ONLINE  ONLINE       node2                                    
bash-3.00#

#修改资源的命令如下:

crsctl modify resource res -attr "xxxx=xxxx"

 

下面仅仅列举一个简单的例子,在11gR2的Solaris平台上,有一个IPMP技术,也就是IP multiple Path技术,配置多块public网卡在一个group里面,当一块网卡发生失败的时候,可以自动切换到另外一快(可以配置成使用probe-based或者link-based),关于IPMP的技术下次在做一些介绍。我们的11gR2也充分支持这一技术,前提就是在CRS管理的network resource上配置多块网卡,当其中的一块fail的时候,利用IPMP自动切换到另外一块,如果两块都不幸fail,那么利用CRS的漂移功能,把VIP和其他相应的服务和client请求漂移到另外的节点。

下面的命令演示了如何修改network资源,使之可以使用多块网卡。

bash-3.00# /u01/app/crshome/bin/crsctl stat res  ora.net1.network  -p | grep USR_ORA
USR_ORA_AUTO=static
USR_ORA_ENV=
USR_ORA_IF=e1000g0
USR_ORA_NETMASK=255.255.255.0
USR_ORA_SUBNET=10.11.191.0
bash-3.00#

crsctl modify resource ora.net1.network -attr "USR_ORA_IF=e1000g0 e1000g1"

bash-3.00# /u01/app/crshome/bin/crsctl stat res  ora.net1.network  -p | grep USR_ORA
USR_ORA_AUTO=static
USR_ORA_ENV=
USR_ORA_IF=e1000g0 e1000g1
USR_ORA_NETMASK=255.255.255.0
USR_ORA_SUBNET=10.11.191.0
bash-3.00#

 

注意上面的e1000g0, e1000g1是同一个IPMP group里面的两个网卡。

Categories: 数据库 Tags: ,

Oracle Real World Performance Group

July 15th, 2010 ricky.zhu No comments

这是Oracle内部比较牛的一个team,兼顾到技术细节,而且又不失实际的用户环境,所以比较有挑战,而且这次的职位技术级别比较高-Senior or Principle member,具体描述如下。欢迎高手自荐。

Title: Senior/Principle member-Real World Performance Group

Job description:

Real World Performance Group is part of the Oracle Database product management team. We do customer benchmarks and post-product escalations to help to shorten sales cycle, to make quality insurance of the Oracle database product, and master the competitive intelligence of the Oracle database product. We are a global team including people in US, EMEA and APAC and we need people to cooperating with people in other time zones.

Responsibilities:

1. Perform database benchmarks
2. File bugs and get rapid resolutions
3. Cooperate with other people in a global team

Qualifications

1. Bachelor or master degree of computer science, or have firm computer science basic knowledge
2. Deep understanding of Oracle database and operating system
3. Skilled in SQL tuning
4. Proficient in writing shell scripts
5. Minimum 3 years of work experiences, better in DBA area, SQL development area or OS area
6. Self-motivated and can work under tight timeline
7. Good team work spirit and can work in a global team
8. Fluent in English and Mandarin

Send your Chinese & English C.V. to ricky.zhu###gmail.com.

工作地点:深圳或者北京均可。

PS:据我知道,这个team的成员分布在美国总部,欧洲和亚太一些国家,在深圳也有一个优秀的小组。一些成员也曾经来国内跟部分大客户进行过技术方面的交流,所以相信大家对他们其实并不陌生。比如这位和鼎鼎大名的Structured Data都是这个team的一员。

有关Exadata的一些Technical的blog

Categories: 数据库, 求职招聘 Tags:

Oracle+Sun Product Line

February 2nd, 2010 ricky.zhu 5 comments

With SUN, oracle’s product line is complete now.

and comparison

Just record it for reference.

Categories: 业界 Tags:

欧盟批准Oracle收购SUN

January 22nd, 2010 ricky.zhu 1 comment

经过长达半年的谈判,欧盟终于批准了这笔74亿美金的交易,Oracle成功收购SUN,对于Oracle这将是一个标准性的事件。

EU Clears Oracle to Buy Sun Microsystems

毫无疑问,这是一家伟大的公司,是一个英雄辈出的公司,不过看到这个长长的列表,我还是有点震撼

【在Sun公司工作的杰出科学家和工程师】

Bill Joy(BSDvi之父)
Ivan Sutherland(图灵奖得主)
Bryan Cantrill(DTrace之父)
Steve Bourne(Bourne shell之父)
Jeff Bonwick(ZFS之父)
Joshua Bloch(Java教父)
Guy L. Steele, Jr.(Scheme之父)
James Duncan Davidson(Tomcat之父)
Whitfield Diffie(公钥算法之父)
Craig McClanahan(Struts之父)
Ian Murdock(Debian之父)
Jakob Nielsen(可用性权威)
Radia Perlman(Internet之母)
Marc Tremblay(UltraSPARC处理器)
Marc Fleury(JBoss之父)
Tim Bray(XML
Peter Norvig(Google研发总监)
John Ousterhout(Tcl之父)

【在Sun公司工作过的杰出企业家】

Eric Schmidt(Google,lex)
Andy Bechtolsheim(Sun创始人,Google的第一个投资者)
庄思浩(BEA) =>没想到BEA,SUN最后都被Oracle收购了…
Chris Malachowsky(NVIDIA)

Categories: 业界 Tags:

Oracle Database 11gR2 for HP-UX and AIX released

December 23rd, 2009 ricky.zhu 3 comments

Oracle Database 11gR2 for HP-UX and AIX released today

至此,Tier1的主要平台包括Linux32/64, Solaris.Sparc, Solaris.X64, HPI, AIX.PPC 已经悉数发布了,除了Windows,可能还要在等等。

下载地址

Oracle Database 11g Release 2
Standard Edition, Standard Edition One, and Enterprise Edition

(11.2.0.1.0)
 Linux x86                            Disk 1, Disk 2 (2.1 GB) | See All (Including Client, Gateways, Grid Infrastructure, more)
 Linux x86-64                      Disk 1, Disk 2 (2.2 GB) | See All (Including Client, Gateways, Grid Infrastructure, more)
 Solaris (SPARC) (64-bit) Disk 1, Disk 2 (2.3 GB) | See All (Including Client, Gateways, Grid Infrastructure, more)
 Solaris (x86-64)                Disk 1, Disk 2 (2.2 GB) | See All (Including Client, Gateways, Grid Infrastructure, more)
 HP-UX Itanium                  Disk 1, Disk 2 (2.3 GB) | See All (Including Client, Gateways, Grid Infrastructure, more)
 AIX (PPC64)                       Disk 1, Disk 2 (2.2 GB) | See All (Including Client, Gateways, Grid Infrastructure, more)

 

Categories: 数据库 Tags:

Oracle Patchset Reference

November 22nd, 2009 ricky.zhu 2 comments

Oracle Database针对不同版本的patchset的一个参考,Metalink note 554256.1

请注意,所有下载都是需要OTN帐号的,第一个版本就是初始release。

PatchSets For 9.2.0.X.0

PatchSet Number Link To Download
9.2.0.2.0
9.2 Patch Set 1
2632931 Patch 2632931
9.2.0.3.0
9.2 Patch Set 2
2761332 Patch 2761332
9.2.0.4 .0
9.2 Patch Set 3
3095277 Patch 3095277
9.2.0.5.0
9.2 Patch Set 4
3501955 Patch 3501955
9.2.0.6 .0
9.2 Patch Set 5
3948480 Patch 3948480
9.2.0.7.0
9.2 Patch Set 6
4163445 Patch 4163445
9.2.0.8.0
9.2 Patch Set 7 (terminal)
4547809 Patch 4547809

PatchSets For 10.1.0.X.0

PatchSet Number Link To Download
10.1.0.3.0
10.1 Patch Set 1
3761843 Patch 3761843
10.1.0.4.0
10.1 Patch Set 2
4163362 Patch 4163362
10.1.0.5.0
10.1 Patch Set 3 (Terminal )
4505133 Patch 4505133

PatchSets For 10.2.0.X.0

Patchset Number Link To Download
10.2.0.2.0
10.2 Patch Set 1
4547817 Patch 4547817
10.2.0.3.0
10.2 Patch Set 2
5337014 Patch 5337014
10.2.0.4.0
10.2 Patch Set 3
(Current)
6810189 Patch 6810189

PatchSets For 11.1.0.X.0

Patchset Number Link To Download
11.1.0.7.0 6890831 Patch 6890831

Categories: 数据库 Tags: