VMCD.ORG

Focus on DB architect mail:ylouis83#gmail.com

[SHOUG] 1号店Exadata应用

Posted by admin on April 3rd, 2014

Download PDF: [SHOUG.LOUISLIU]Exadata在电商的实践

Tags:
Posted in Oracle Experience | No Comments »

Oracle DGHA architecture

Posted by admin on November 1st, 2013


Download this PDF

Tags:
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:
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[......]

Read more

Tags:
Posted in Oracle Experience | No Comments »

Think of bind value

Posted by admin on September 17th, 2013

Tags:
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[......]

Read more

Tags:
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[......]

Read more

Tags:
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[......]

Read more

Tags:
Posted in Oracle Experience | No Comments »

Some exadata disk tips

Posted by admin on July 29th, 2013

针对exadata最近频繁报出的IO error,做如下总结

data node alert

ORA-27603: 单元存储 I/O 错误, I/O 在磁盘 o/192.168.10.5/DATA_DM01_CD_08_dm01cel03 上失败, 偏移量 17331625984 (数[......]

Read more

Tags:
Posted in Oracle Experience | No Comments »

[12c new feature] 针对 pluggable database的操作

Posted by admin on July 5th, 2013

1. create Pluggable database from NON_CDB database.

[oracle@db-42 ~]$ ora si 

SQL*Plus: Release 12.1.0.1.0 Production on Fri Jul 5 13:07:08 20[......]

Read more

Tags:
Posted in Oracle Experience | No Comments »