加入dbDao.com Oracle技术学习QQ群：171092051
如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!
诗檀软件专业数据库修复团队
服务热线 ：13764045638 QQ: 47079569 邮箱：service@parnassusdata.com
AskMaclean 网站地图
-
站内搜索 请使用左侧栏的 《好用的站内搜索》
-
百度版网站地图： http://feed.askmaclean.com/sitemap.html
-
google版网站地图：http://feed.askmaclean.com/sitemap.xml
-
向Maclean 提问Oracle技术问题： http://t.askmaclean.com/forum.php
-
PRM-DUL Oracle数据库灾难恢复工具
Maclean Liu 中文名：刘相兵
商务合作电话： +86 13764045638
技术咨询邮箱： service@parnassusdata.com
所在企业:诗檀软件 www.parnassusdata.com
个人技术博客地址：http://www.askmaclean.com
如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!
诗檀软件专业数据库修复团队
服务热线 ： 400-690-3643 备用电话：13764045638 邮箱：service@parnassusdata.com
ORACLE PRM是诗檀软件独立研发的ORACLE数据库灾难恢复软件，其具有全程图形化界面、简单高效等特点。
刘相兵(Maclean Liu):
Maclean Liu， 诗檀（上海）软件系统有限公司(ParnassusData Software , Inc.) 联合创始人，联系诗檀软件。
同时Maclean也是上海Oracle用户组(Shanghai Oracle Users Group)的创始人之一。
拥有8年数据库领域从业经验，目前在甲骨文公司中国上海工作，离开Oracle甲骨文中国后创建了诗檀软件公司(ParnassusData Software) 。
所服务的行业包括电信运营商、通讯设备制造商、银行、金融业等。
主要客户包括：
工商银行、中国银行、交通银行、外汇交易中心、中国人寿保险、浦发银行、上海银行、人民银行、银联数据、银商资讯、太平人寿保险
上海电信、上海联通、上海移动、浙江电信、湖北电信、湖北联通、湖北移动、江苏移动、德邦物流、东方航空
Maclean Liu对研究Oracle 内部原理、新特性、高可用和性能调优饶有兴趣，同时撰写了大量Oracle数据库技术相关的专题文章。
Maclean Liu愿意通过网络同大家分享Oracle知识和经验，也愿意在能力范围能帮助大家解决实际工作中遇到的问题。
视角不同，不一样的Oracle！
Maclean Liu 的Timeline :
- 2007 年初 正式参加工作 加入TATA Consultancy Services TCS
- 2007 年底 获得Oracle Certified Database 10g Administrator Profession(10g ocp)认证
- 2008 年底 离开TCS 加入Multnovo.com 从事Oracle技术支持工作
- 2009 年初 获得Oracle Certification RAC expert(OCE)认证
- 2009 年中 开始在网络上撰写Oracle技术文章 最初使用的域名是youyus.com ，后来换成现在的oracledatabase12g.com
- 2009 年底 获得Oracle Certified Database 10g Administrator Master(10g OCM)认证
- 2010 年初 获得IBM system p administrator(CATE)认证
- 2011 年初 受到邀请加入Independent Oracle Users Group IOUG
- 2011 年初 获得Oracle Certified Database 11g Administrator Master(11g OCM)认证
- 2011 年底 建立了Oracle Clinic的镜像站AskMaclean.com，并搭建了论坛形式的提问板T.AskMaclean.com
- 2012年7月Oracle Clinic正式站迁移到www.askmaclean.com域名上，并更名为Ask Maclean Oracle Blog
- 2012 年8月Maclean Liu加入甲骨文(中国)软件系统有限公司 ACS部门
- 2013 年5月Maclean Liu和Todd Bao 创建了SHOUG 上海Oracle用户组,Maclean Liu任用户组主席
- 2013年12月Maclean与其他2位Oracle原厂的同事一起成立了 诗檀（上海）软件系统有限公司 暨 ParnassusData Software, Inc.
- 2014年4月PanassusData Software诗檀软件发布了PRM-DUL for Oracle数据库灾难恢复工具
- 2014年6月SHOUG举办了第一届SHOUG Forum上海Oracle用户组高峰论坛
- 2014年7月Got An Oracle ACE
- 2014年11月SHOUG组织了首届Orcl-Con甲骨文技术控大会
Oracle (OTN) Discussion Forum User Profile:https://community.oracle.com/people/LiuMaclean(%E5%88%98%E7%9B%B8%E5%85%B5)
微博 ： http://weibo.com/liumaclean
He is very influential person in Oracle Database community in China and Asia-Pacific. He would like to answer Questions Posted on both OTN and other Oracle Forum, till now he had answered about 4000 Oracle Database Questions on internet.
- Maclean has been very active with the community and setup a Q&A section on his blog, amazingly 4000+ Oracle RDBMS questions had been answered by him.
- Maclean published several introduction videos about Oracle technology to the internet and they are widely watched by Chinese audience.
- Active Shanghai Oracle User Group field activities participant and organizer.
- A qualified evangelist for Oracle 12c and Exadata products.
- Have a special passion on Oracle database related products, eager to share his Oracle knowledge with the community every day.
- 2012~Now Answered Hundreds of Questions About Oracle DB on OTN,you can find them here:https://www.google.com.hk/#newwindow=1&q=maclean+site:community.oracle.com&safe=strict
- 2011~Now Answered more than 3000 Questions About Oracle DB on Forum, you can find them here:http://t.askmaclean.com/forum-4-1.html
- 2009~Now Posted more than 1000 blog about Oracle DB on http://www.askmaclean.com/
- 2013 President of SHOUG Shanghai Oracle Users Group
- 2014.3 Presenter in SHOUG COLLABORATE Forum
- 2013.6 Lecturer in Oracle ACS proseminar
网络会议与视频分享
- 《How to Learn Oracle Database: Wings of liberty》http://www.tudou.com/programs/view/46S4t6wwaQw/
- 《Install 11gR2 RAC Using VirtualBox Best Practice》http://www.tudou.com/programs/view/xAOpQowNlU0/
- 《Install 10gR2 RAC Using VirtualBox Best Practice》http://t.askmaclean.com/thread-891-1-1.html
- 《Install 12.1.0.1 RAC Using VirtualBox Best Practice》http://www.tudou.com/programs/view/rPYR4H6GKZ8/?bid=03&pid=02&resourceId=78129035_03_05_02
- 《Oracle Database tuning: Hawk Eyes on AWR I》 http://www.tudou.com/programs/view/Dp_YYjvX-KM/
- 《Oracle Database tuning: Hawk Eyes on AWR I》http://www.tudou.com/programs/view/ORRvMVNLKaU/
会议演讲
- SHOUG Forum COLLABORATE 14: 《Oracle Database 12c New Feature:Information Lifecycle Management ILM and Storage Enhancements》 http://www.askmaclean.com/archives/12c-ilm.html
- SHOUG Forum COLLABORATE 13 : 《Oracle Database 12c New Feature:12c Pluggable Database Container Database》 http://www.askmaclean.com/archives/pluggable-container-db-12c.html
- Orcl-Con 2014 :http://f.shoug.info/?/question/16 《oracle数据库的保护之手》
- Oracle ACS 技术研讨会: 《Oracle Tuning: An ADDM DBA》http://t.askmaclean.com/forum.php?mod=attachment&aid=MjAyNHxhNzYxNTU2YXwxMzcyMDYzNTY0fDJ8MjYwNw%3D%3D
来读一读 Maclean Liu 发表的一些文章吧！
Slide:Oracle数据库升级前必要的准备工作
Slide:11g新特性-在线实施补丁online patching
Slide:了解Oracle critical patch update
Slide:配置Oracle 10g双向流复制
Slide:深入了解Oracle自动内存管理ASMM by Maclean Liu
Slide:了解真实的Oracle Unbreakable Database Appliance
Slide:配置GoldenGate同步DDL语句
Slide:如何安装Oracle one-off 临时小补丁及注意事项 by Maclean.liu
Slide:Upgrade 11.2.0.1 RAC DB/RDBMS to 11.2.0.2 in Linux By Maclean
Slide:Upgrade 11.2.0.1 GI/CRS to 11.2.0.2 in Linux
了解Oracle RAC Brain Split Resolution
Probe how does your PGA consume
Does Rman Backup benefit from Large Pool?
Oracle Enterprise Manager Cloud Control 12c(12.1) OMS&Agent安装图文指南
还原真实的cache recovery
Oracle优化器:星型转换
深入理解Oracle Universal Installer (OUI)
Basic Oracle For Developer & Beginner
Startup Upgrade为我们做了什么？
11g新特性:Rolling Upgrade With Physical Standby
Duplicate standby database from active database
Examine 11g automatic block Corruption recovery
How to recover from root.sh on 11.2 Grid Infrastructure Failed
为10g RAC Cluster添加节点
11g新特性:Streams同步捕获
Convert your single instance to 10g RAC by manual
为Oracle Clusterware修改公用及私有网络接口
Discover Your Missed ASM Disks
GoldenGate实现Live Standby主备库切换
再议RAC Brain Split脑裂
一次Exadata上的ORA-600[kjbmprlst:shadow]故障分析
Oracle数据恢复:解决ORA-00600:[4000] ORA-00704: bootstrap process failure错误一例
CBO为什么不走索引？
何时会发生db file sequential read等待事件？
SQL调优:Clustering Factor影响数据删除速度一例
Oracle Internal Research深入研究Oracle内部原理
快速升级Oracle 11.2.0.2 RAC到11.2.0.3
Oracle中加速索引创建或重建的方法
手工模拟Oracle数据块逻辑讹误引发ORA-00600:[13013], [5001]一例
使用bbed解决ORA-01189错误
总结ORA-00600问题
文章列表
ORA-600篇：
Oracle内部错误:ORA-600:[4097]一例
Oracle内部错误:ORA-600[15801], [1]一例
Oracle内部错误:ORA-600:[6033]一例
Oracle内部错误:ORA-600[OSDEP_INTERNAL]一例
Oracle内部错误:ORA-600[kgskdecrstat1]一例
Oracle内部错误:ORA-600[kfioTranslateIO03]一例
Oracle内部错误ORA-600:[pfri.c: pfri8: plio mismatch ]一例
Oracle内部错误:ORA-600[2608]一例
Oracle内部错误:ORA-600[13013][5001]故障诊断一例
Oracle内部错误:ORA-600[17175]一例
Oracle内部错误ORA-600:[2667]一例
Oracle RAC内部错误:ORA-600[keltnfy-ldmInit]一例
ORA-600: INTERNAL ERROR CODE, ARGUMENTS: [729], [10992], [SPACE LEAK] Example
手工模拟Oracle数据块逻辑讹误引发,ORA-600:[13013] [5001]一例
ORA-600 [4400][48]错误一例
ORA-600 [KCBZPB_1], [59033077], [4], [1], [] example
ORA-600:[qctcte1]内部错误一例
ORA-600: internal error code, arguments: [15160]
ORA-600: internal error code, arguments: [kdsgrp1] example
Oracle内部错误:ORA-600[25012]一例
ora-600:[17281], [1001]一例
ORA-600:[kclchkinteg_2]及[kjmsm_epc]内部错误一例
Oracle内部错误:ORA-600[kccchb_3]一例
ORA-600: [qksrcBuildRwo]内部错误一例
ORA-600:[32695], [hash aggregation can’t be done]错误一例
ORA-600[6711]错误一例
ora-600[kkocxj:pjpCtx]内部错误一例
ORA-600 [kcbz_check_objd_typ_3]错误一例
ORA-600:[15570]内部错误一例
ORA-600 [3756]内部错误一例
ORA-600 [kddummy_blkchk]错误一例
How to trigger ORA-600,ORA-7445 by manual
ora-600 [17182]错误一例
Database Force open example
ora-600[qesmmCValStat4]一例
ORA-600 [kddummy_blkchk] [18038] 一例
Oracle内部错误:ORA-600[kgskdecrstat1]一例
famous summary stack trace from Oracle Version 8.1.7.4.0 Bug Note
Oracle内部错误ORA-600:[1112]
一次Exadata上的ORA-600[kjbmprlst:shadow]故障分析
ORA-600 quick reference guide
ORA-600[kglhdunp2_2]错误一例
ORA-600:[kclchkinteg_2]及[kjmsm_epc]内部错误一例
ORA-600: [7005], [192]内部错误一例
ORA-600 internal error[kqrfrpo]一例
ORA-600[4194]错误一例
How to trigger ORA-600,ORA-7445 by manual
ORA-600[kjpsod1]&ORA-44203错误一例
ORA-7445篇：
Oracle内部错误:ORA-7445[kcflfi()+466] [INT_DIVIDE_BY_ZERO]一例
ORA-7445: [__lwp_kill()+8] [SIGIOT]错误一例
Oracle内部错误ORA-7445:[_memcmp()+88] [SIGSEGV]一例
Oracle内部错误ORA-7445[kpopfr()+339] [SIGFPE]一例
ORA-7445:[SIGFPE] [Integer divide by zero]内部错误一例
Oracle内部错误ORA-7445: [ACCESS_VIOLATION] [unable_to_trans_pc][UNABLE_TO_READ]
ORA-7445 [SIGBUS] [Object specific hardware error]错误一例
PMON: TERMINATING INSTANCE DUE TO ERROR 600 on 8i
ora-7445 [kghalp+0500] [SIGSEGV]错误
11g新特性篇：
11g新特性:A useful View V$DIAG_INFO
11gR2新特性:LMHB Lock Manager Heart Beat后台进程
给11gR2 RAC添加LISTENER监听器并静态注册
11.2 中Oracle Cluster Registry(OCR)可选的存储设备
11.2.0.3 实例启动现在提供Large Pages Information大内存页信息了
Does Duplicate Target Database need Pre-existing DB backup?
11gR2新特性:STANDBY_MAX_DATA_DELAY
11g 新特性IGNORE_ROW_ON_DUPKEY_INDEX提示
11g新特性SQL执行计划管理(SQL Plan Management)
11g新特性-在线实施补丁online patching
11g新特性:Rolling Upgrade With Physical Standby
11g新特性-SQL PLUS 错误日志
11g新特性:Note raised when explain plan for create index
11g compression 新特性
11g新特性之闪回事务处理取消
11g新动态性能视图V$SQL_MONITOR,V$SQL_PLAN_MONITOR
11g默认审计选项
Examine 11g automatic block Corruption recovery
Duplicate standby database from active database
11g Database Installation flow
Setup Oracle Direct NFS Client
Recreate failovered primary database using Flashback Database
11g中的db_block_checking参数
11.2.0.2补丁集安装体验
Oracle 11g中数据库能有多大？
undo backup optimization does not work on 11.2.0.1?
11g新特性之IO校准(IO Calibration)
11g中AWR新快照视图
11g r2中对闪回数据归档的增强
11g Release 2 enhanced Tablespace Point In Time Recovery
11g新特性:Streams同步捕获
Applying online patch on 11gr2
How to recover from root.sh on 11.2 Grid Infrastructure Failed
Uninstall/Remove 11.2.0.2 Grid Infrastructure & Database in Linux
为11.2.0.2 Grid Infrastructure添加节点
Find password cracker in 11g
11g Multi-Column Correlation Stats and Dynamic Sampling
11g内存管理新特性的internal表现
Oracle database 11g release2发布
How to check and disable Adaptive Cursor Sharing in 11g
How does SGA/PGA allocate on 11g AMM?
crsctl status resource -t -init in 11.2.0.2 grid infrastructure
Learning 11g New Background Processes
Exadata篇
Oracle Exadata v2的价格
Exadata V2 Pricing
一次Exadata上的ORA-600[kjbmprlst:shadow]故障分析
Exadata Server Hardware Details
Exadata用户的困境
My Opinion On Exadata V2
Warning:Even Exadata has a wrong memlock setting
Oracle Exadata Database Recommended Patch (BP3) for Bug 10387939
Exadata Database Machine Host的操作系统OS版本
数据仓库:Oracle Exadata和Netezza的比较
Exadata Smart Flash Logging新特性
Database Appliance并非Mini版的Exadata-还原真实的Oracle Unbreakable Database Appliance
Oracle Sun Exadata V2 ,X2-2,X2-8 主要配置对比
Exadata X2-2 vs EMC Greenplum DCA vs Netezza TwinFin 12主要配置大对比
Booting Exadata!
I/O Resource Management with Exadata
Exadata. Are you ready?
Database Machine & Exadata Storage
Oracle Exadata Overview
Exadata and Database Machine 11.2
Exadata MAA Best Practices Series Using DBFS on Exadata (Use Cases and Performance Expectations)
Teradata to Exadata Migration Methodology
Exadata V2 Sun Oracle Database Machine
Updates on New Exadata Pricing & Packaging
Exadata MAA Best Practices Series Session:Exadata Backup and Recovery
Maximizing Database Application Performance with Flash and Solid State Disks (SSDs)
Extreme Performance with Oracle Data Warehousing
脚本Script篇：
Script:收集Enterprise Manager Grid Control/Agent/Database Control诊断信息
Script:收集Exadata诊断信息
Script:收集RAC诊断信息
Script:收集自动SGA内存管理ASMM诊断信息
Script:Collect vip resource Diagnostic Information
11g新特性:hangdiag.sql实例hang诊断脚本
Script:verify Oracle Object timestamp discrepancy
Script:SQL调优健康检查脚本
Script:列出本会话的细节信息
利用rowid分块实现非分区表的并行update与delete
Script:计算Oracle Streams进程所占用的内存大小
利用RMAN检测数据库坏块的脚本
Script:利用外部表实现SQL查询Oracle告警日志Alert.log
Script: 收集RAC DRM 诊断信息
Script:10g中不用EM显示Active Session Count by Wait Class
Script:数据库最近的性能度量
Script:收集数据库中用户的角色和表空间等信息
Script:收集介质恢复诊断信息
Script:收集Flashback Database Log诊断信息
Script:列出Oracle每小时的redo重做日志产生量
Script:收集11g Oracle实例IO性能信息
Script:检查数据库当前是否有备份操作在执行中
Script:List Schema/Table Constraints
Script:RAC Failover检验脚本loop.sh
Script:Diagnostic Resource Manager
Script:List Grid Control Jobs
Script:GridControl Repository Health Check
Script:诊断Scheduler信息
Script:优化crs_stat命令的输出
Script:Diagnostic Oracle Locks
Script:列出用户表空间的定额
Backup Script:Expdp Schema to ASM Storage
Script:Speed Up Large Index Create or Rebuild
Script:列出失效索引或索引分区
Script:列出数据库中5%以上链式行的表
Script:列出没有主键或唯一索引的表
Script:收集ASM诊断信息
Script:收集Oracle备份恢复信息
监控一个大事务的回滚
Script to Collect DB Upgrade/Migrate Diagnostic Information (dbupgdiag.sql)
Script:partition table into rowid extent chunks
Script:Oracle EBS数据库初始化参数健康检查脚本
Script:Monitoring Memory and Swap Usage to Avoid A Solaris Hang
SQL脚本:监控当前重做日志文件使用情况
Streams Health Check on 10g Release 2
从视图查询表分区的相关信息
Script To Monitor RDBMS Session UGA and PGA Current And Maximum Usage Over Time
Script:收集RAC性能诊断信息
Script:收集UNDO诊断信息
Script:列出数据库中子表上没有对应索引的外键
Script: Listing Memory Used By All Sessions
Collecting Diagnostic Data for OCFS2 Issues
Script to Identify Objects and Amount of Blocks in the Buffer Pools – Default, Keep, Recycle, nK Cache
Script:Generate A DDL Script For A Table
SCRIPT TO CHECK FOR FOREIGN KEY LOCKING ISSUES
如何找出Oracle中需要或值得重建的索引
Script:Diagnostic ORA-01000 maximum open cursors exceeded
ORA-4030 PGA Usage Diagnostic Script
Script:Tune Very Large Hash Join
Script to Collect Log File Sync Diagnostic Information (lfsdiag.sql)
Script:List Buffer Cache Details
Script:List NLS Parameters and Timezone
Script:List SORT ACTIVITY
Script:List OBJECT DEPENDENT
Script:Logfile Switch Frequency Map
Script:Tablespace Report
Script:收集数据库安全风险评估信息
脚本:格式化的V$SQL_SHARED_CURSOR报告
脚本:监控并行进程状态
脚本:监控数据库中的活跃用户及其运行的SQL
脚本:监控临时表空间使用率
Script to show Active Distributed Transactions
Gather DBMS_STATS Default parameter
Script:Datafile Report
Script to Collect Data Guard Diagnostic Information
Script:To Report Information on Indexes
ORA-4031 Common Analysis/Diagnostic Scripts
Script:when transaction will finish rollback
Script: Computing Table Size
Script to Detect Tablespace Fragmentation
“hcheck.sql” script to check for known problems in Oracle8i, Oracle9i, Oracle10g and Oracle 11g
Script to Prevent Excessive Spill of Message From the Streams Buffer Queue To Disk
Oracle Systemstate dump analytic tool: ASS.AWK V1.09
SCRIPT TO GENERATE SQL*LOADER CONTROL FILE
升级与补丁Upgrade篇：
甲骨文发布2012 1月数据库安全补丁Critical Patch Update January 2012
Oracle数据库版本10.2实际进入扩展支持Extended Support周期
Patch Set Update and Critical Patch Update October 2011补丁更新发布了
11.2.0.3 Patch Set – List of Bug Fixes by Problem Type
快速升级Oracle 11.2.0.2 RAC到11.2.0.3
Upgrade GI/CRS 11.1.0.7 to 11.2.0.2. Rootupgrade.sh Hanging
Oracle补丁集的补丁号Patch ID/Number速查
Oracle 11gR2发布11.2.0.3 Patchset补丁集-又一重量级更新
Slide:11g新特性-在线实施补丁online patching
Slide:Oracle数据库升级前必要的准备工作
深入了解Oracle数据字典升级脚本catupgrd.sql调用过程
Slide:如何安装Oracle one-off 临时小补丁及注意事项 by Maclean.liu
Slide:了解Oracle critical patch update
Slide:Upgrade 11.2.0.1 GI/CRS to 11.2.0.2 in Linux
Slide:Upgrade 11.2.0.1 RAC DB/RDBMS to 11.2.0.2 in Linux By Maclean
Upgrade 11.2.0.1 DB/RDBMS to 11.2.0.2 in Linux
Upgrade 11.2.0.1 GI/CRS to 11.2.0.2 in Linux
Applying 11G R2 GI PSU 11.2.0.2.3
Critical Patch Update July 2011 Released
了解Oracle Critical Patch Update
了解Oracle数据库的版本号
Pre-check while you are applying one-off patch
Advise on OS patch upgrade with RAC
Oracle Patch Set Update and Critical Patch Update April 2011 Released
11g新特性:Rolling Upgrade With Physical Standby
Patch your 10g Oracle database to PSU 10.2.0.4.5
7月最新发布10.2.0.4.5 Patch Set Update
Oracle Exadata Database Recommended Patch (BP3) for Bug 10387939
Startup Upgrade为我们做了什么？
深入理解Oracle Universal Installer (OUI)
Script to Collect DB Upgrade/Migrate Diagnostic Information (dbupgdiag.sql)
介绍dbms_registry PL/SQL程序包
Applying online patch on 11gr2
January 2011 Patch set Update发布
Advice on upgrading to 11.2.0.2 and converting to RAC
Oracle 9iR2 RAC to Oracle 10gR2 RAC Upgrade
Upgrading to Oracle Database 11g
如何确定所打Patch是否需要停机
Database Upgrade using Transportable Tablespaces
Upgrading to 11g–Why,How and Best Practices
Upgrade from Oracle Database 10g to 11g:What to Expect From the Optimizer
Upgrade to Oracle Database 11g: Single Instance to RAC & ASM
Applying Database PSU 10.2.0.4.6
Oct 12: Patch Set Update Released
Oracle Critical Patch Updates Unwrapped
11.2.0.2补丁集安装体验
Upgrading to RAC 11g R2 What you should know
Oracle 9i/10g/11g数据库升级路线图总览
OPatch工具相关的环境变量
使用OPATCH_DEBUG环境变量调试Opatch工具
opatch java.lang.OutOfMemoryError:Java heap space错误一例
加入我的Linkedin职业网络:
关注dbDao.com的新浪微博
扫码关注dbDao.com 微信公众号：
