Author: mac

How to Uninstall/Reinstall 10g CRS Clusterware?

如何重装10g clusterware集群软件? 一般情况下我会说把DB、CRS停掉,手动删除ORA_CRS_HOME及/etc(或者/opt)目录下的ora*配置文件，使用dd命令清理LUN的头部。再重装一般就没有问题了，但实践过程中往往会因为清理地不够彻底而出现问题。今天同事问我有没有彻底卸载CRS的文档，到metalink上搜了一圈结果还真没有，最后从Alejandro Vargas’ Blog上找到一份比较权威的文档，这里分享一下。 Oracle 10g clusterware_reinstall&uninstall View more presentations from Maclean Liu

July 27, 2011
Basic Oracle For Developer & Beginner

得闲做了一个给初学者和开发人员介绍基础概念的PPT,本来还想把前前后后写的SMON功能的帖子汇总到一个PPT里，但是现在要开始忙婚礼的事了，估计这半年里是没空了。。 Basic oracle for developer&beginner View more presentations from Maclean Liu

July 26, 2011
Oracle RAC内部错误:ORA-00600[kjbmprlst:shadow]一例

一套Linux x86-64上的11.2.0.1 4节点RAC系统中LMS GCS服务进程遭遇到内部错误ORA-00600[kjbmprlst:shadow],导致节点实例意外终止,具体日志如下: Fri Jul 08 02:04:43 2011 Errors in file /u01/app/oracle/diag/rdbms/PROD/PROD1/trace/PROD1_lms1_536.trc (incident=1011732): ORA-00600: internal error code, arguments: [kjbmprlst:shadow], [], [], [], [], [], [], [], [], [], [], [] Incident details in: /u01/app/oracle/diag/rdbms/PROD/PROD1/incident/incdir_1011732/PROD1_lms1_536_i1011732.trc Fri Jul 08 02:04:44 2011 Trace dumping is performing id=[cdmp_20110708020444] Errors in file /u01/app/oracle/diag/rdbms/PROD/PROD1/trace/PROD1_lms1_536.trc: ORA-00600: internal error code, arguments: [kjbmprlst:shadow],…

July 25, 2011
Know Difference between Oracle Reserved Words and Keywords

与C和JAVA体系类似,Oracle中存在一些保留词(Reserved Words)或关键词(Keywords)以及少量的命名空间(Namespace)。保留词(Reserved Words)是优先级最高的词汇，在Oracle中这些词都有着特殊的意义。所以这些词不允许被重定义 (redefine),换而言之就不是不允许用作对象的名字。以下为Oracle 10g中保留词的列表: Oracle Reserved Words ACCESS ELSE MODIFY START ADD EXCLUSIVE NOAUDIT SELECT ALL EXISTS NOCOMPRESS SESSION ALTER FILE NOT SET AND FLOAT NOTFOUND SHARE ANY FOR NOWAIT SIZE ARRAYLEN FROM NULL SMALLINT AS GRANT NUMBER SQLBUF ASC GROUP OF SUCCESSFUL AUDIT HAVING OFFLINE SYNONYM BETWEEN IDENTIFIED ON SYSDATE BY IMMEDIATE…

July 25, 2011
Critical Patch Update July 2011 Released

2011年7月的CPU在19日发布了，Database相关的PSU/CPU包括: 11.2.0.2:CPU Patch 12419321, or DB PSU Patch 12419331, or GI PSU Patch 12419353, or Exadata BP9 Patch 12681774 11.2.0.1:CPU Patch 12419278, or DB PSU Patch 12419378, or Exadata BP11 Patch 12608545 11.1.0.7: CPU Patch 12419265, or PSU Patch 12419384 10.2.0.5:CPU Patch 12419258, or PSU Patch 12419392 10.2.0.4:CPU Patch 12419249, or PSU Patch 12419397 Oracle…

July 20, 2011
了解你所不知道的SMON功能(八):Transaction Recover

SMON的作用还包括启动(startup)时的Transaction Recover: SMON: enabling cache recovery Archived Log entry 87 added for thread 1 sequence 58 ID 0xa044e7d dest 1: [15190] Successfully onlined Undo Tablespace 2. Undo initialization finished serial:0 start:421305354 end:421305534 diff:180 (1 seconds) Verifying file header compatibility for 11g tablespace encryption.. Verifying 11g file header compatibility for tablespace encryption completed SMON: enabling tx…

July 15, 2011
Know more about commit

COMMIT操作是RDBMS中事务结束的标志，在Oracle中与commit紧密相关的是SCN(System Change Number)。引入SCN的最根本目的在于：为读一致性所用为redolog中的记录排序，以及恢复 SCN由SCN Base和Scn Wrap组成，是一种6个字节的结构(structure)。其中SCN Base占用4个字节，而SCN wrap占用2个字节。但在实际存储时SCN-like的stucture常会占用8个字节。 ub4 kscnbas ub2 kscnwrp struct kcvfhcrs, 8 bytes @100 Creation Checkpointed at scn ub4 kscnbas @100 0x000a8849 ub2 kscnwrp @104 0x0000 在Oracle中一个事务的开始包含以下操作: 绑定一个可用的rollback segment 在事务表(transaction table)上分配一个必要的槽位从rollback segment中分配undo block 注意system rollback segment是一种特殊的回滚段，在10g以后普通回滚段的类型都变成了”TYPE2 UNDO”，而唯有system rollback segment的类型仍为”ROLLBACK”，这是由其特殊性造就的: SQL> col segment_name for a20 SQL> col rollback for…

July 13, 2011
Know about RDBMS market share

2005年IDC调查的RDBMS市场份额: 2008年IDC调查的Data Warehouse市场份额: 2008年做的未来dbms安装部署计划调查: 2008 rdbms market share: Worldwide RDBMS Product Revenue by Top 10 Vendor and Operating Environment, 2009: 根据IDC以往的调查，2006年关系型数据库的市场总额为167亿美元，2007年为188亿美元。大量报告显示Oracle仍维持着RDBMS市场的龙头老大地位，当然这种领导优势并不显著。 Analyzing the RDBMS Market in 2009 The RDBMS market, as reported in Worldwide Database Management Systems 2009 Vendor Shares (IDC #223912, June 2010), grew slightly…

July 12, 2011
Configuring JD Edwards Deployment Server and Development Client on Oracle VM VirtualBox

Oracle virtualboxe1 View more documents from Maclean Liu

July 12, 2011
Oracle等待事件KJC:Wait for msg sends to complete

KJC: Wait for msg sends to complete是一种只会发生在RAC环境中的等待事件，目前对于该等待事件已知的信息不多。 KJ意为Kernel Lock Management Layer，Messaging Enhancements (KJC)。猜测该等待事件为global enqueue message的网络传输等待,前台进程和后台进程如LMS、LMD均可能发生该等待事件。 select name,parameter1,parameter2,parameter3,wait_class from v$event_name where name like ‘%KJC%’; NAME PARAMETER1 —————————————————————- —————————————————————- PARAMETER2 PARAMETER3 —————————————————————- —————————————————————- WAIT_CLASS —————————————————————- KJC: Wait for msg sends to complete msg dest|rcvr mtype Other SQL> select * from gV$system_Event where event like ‘%KJC%’;…

July 10, 2011