小型机迁移x86平台之老生常谈
Posted by admin on July 17th, 2014
You can view this presentation click here: x86_architect
注意使用chrome打开文件 不然可能乱码
Tags: architecture
Posted in Oracle Experience, Unix/Linux | No Comments »
Good news for MySQL HA solutions
Posted by admin on June 9th, 2014
Oracle Clusterware is portable cluster software that allows clustering of independent servers so that they cooperate as a single system. Oracle Clus[......]
Tags: HA
Posted in MYSQL, Oracle Experience | No Comments »
[SHOUG] 1号店Exadata应用
Posted by admin on April 3rd, 2014
Download PDF: [SHOUG.LOUISLIU]Exadata在电商的实践
Tags: architecture
Posted in Oracle Experience | No Comments »
Oracle DGHA architecture
Posted by admin on November 1st, 2013
Tags: architecture
Posted in Oracle Experience | No Comments »
[转] Autotrace with bind variables
Posted by admin on September 27th, 2013
JL刚刚写的一篇autotrace与bind variables 的行为：Autotrace trick
之前我们也发现过这个问题具体SR在这里：something seems confused
Tags: oracle数据管理
Posted in Oracle Experience | No Comments »
CTAS导致严重BUG一则
Posted by admin on September 25th, 2013
某国内巨头的一起CASE,在系统繁忙情况下大量的CTAS 导致数据字典表的不一致,由原来10.0.2.4版本升级到10.0.2.5之后问题依旧。
具体表现为：
1. 尝试drop这些不一致的tablespace
15:00:18 SQL> @dropts_2012.0319.150[......]
Tags: bug
Posted in Oracle Experience | No Comments »
Think of bind value
Posted by admin on September 17th, 2013
Tags: training
Posted in Oracle Experience | No Comments »
一次诡异的缓慢”死亡” CASE
Posted by admin on September 13th, 2013
今天下午遇到的一个诡异CASE,现象为系统诡异的死亡,目前判定为sqluldr2工具导致 (同事使用sqluldr2 用具 执行了sqluldr2_linux64_10204.bin -help 命令)
抛出的错误如下 (/var/log/message)
Sep 11 09:00:54[......]
Tags: trouble shooting
Posted in Oracle Experience | No Comments »
DGHA，Dataguard自动切换方案
Posted by admin on August 15th, 2013
发布对autoswitch over dg脚本DGHA测试,此脚本针对oracle dataguard设计使用共享存储存放redo以及controlfile从而达到了切换数据0丢失。
同时切换以后,original primary database可以无缝加入整个dg集群，从而形成了datagua[......]
Tags: dataguard
Posted in Oracle Experience | No Comments »
关于12c Pluggable database注册listener问题
Posted by admin on August 9th, 2013
演示一下12c中关于pdb的listener register,unregister问题
[oracle@db-42 ~]$ lsnrctl status listener1 LSNRCTL for Linux: Version 12.1.0.1.0 - Production on[......]
Tags: 12c new feature
Posted in Oracle Experience | No Comments »