VMCD.ORG

Focus on DB architect mail:ylouis83#gmail.com

How to use Flash Cache on Redhat (not OEL)

Posted by admin on 26th August 2013

QQ图片20130826223025

By ask Surachart for help

Test: Flash Cache on 11gR2 + RHEL

A Flash Cache (11gR2) is supported by OEL or Solaris. If Want To use RHEL(Ex[......]

Read more

Tags:
Posted in Unix/Linux | No Comments »

Advanced use of dbms_stats for extended stats of CG

Posted by admin on 4th June 2013

Tags:
Posted in Oracle Experience | No Comments »

Optimizer in Oracle 11g by wwf.

Posted by admin on 11th April 2013

By wwf from ebay COC about Optimizer in Oracle 11g.

Tags:
Posted in Oracle Experience | No Comments »

Oracle Direct NFS Performance

Posted by admin on 23rd November 2012

在Oracle 11g中引入了Direct Network File System(Oracle Direct NFS)的新特性,通过一个打包在Oracle内核中的NFS client来提高使用NFS时的性能,DNFS同样适用于RAC等高可用场景。

DIRECT NFS CLIENT OV[......]

Read more

Tags:
Posted in Oracle Experience | 1 Comment »

Incremental Statistics for Partitioned Tables in 11g

Posted by admin on 8th November 2012

这篇文档是我们前leader wwf 写的分析文档,指出了incremental statistic针对partition table 的一些用法,并且指出了一些bug,看不了slideshare的TX可以直接下载Inc_Stat_For_PT.doc

Read more

Tags:
Posted in Oracle Experience | No Comments »

11g Smart Flash Cache

Posted by admin on 30th August 2012

整理一篇关于11g smart flash cache 的文章,vmcd

我们来做一下演示 采用FusionIO SLC 160G

[oracle@db-41 ~]$ ls -l /dev/fi[......]

Read more

Tags:
Posted in Oracle Experience | No Comments »

11G New feature: Failed Logon Delays

Posted by admin on 27th April 2012

在pub上看到一个不错的帖子 oracle 11g password delay

对这个特性 做如下说明

Failed Logon Delays

A hacker may attempt a brute force hack to break into your Oracle D[......]

Read more

Tags:
Posted in Oracle Experience | 2 Comments »

11gR2 rac ora.asm error (ASM)

Posted by admin on 26th April 2012

ASM – ora.asm error

11.2.0.3 RAC CRS 无法启动

[ohasd(25286)]CRS-2112:The OLR service started on node db-41.
2012-04-25 14:46:13.120
[ohasd(25286)]CRS-1301:Oracle High Availability Service started on node db-41.
2012-04-25 14:46:13.120
[ohasd(25286)]CRS-8017:location: /etc/oracle/lastgasp has 2 reboot advisory log files, 0 were announced and 0 errors occurred
2012-04-25 14:46:14.181
[/data/11.2.0/grid/bin/orarootagent.bin(25332)]CRS-5016:Process "/data/11.2.0/grid/bin/acfsload" spawned by agent "/data/11.2.0/grid/bin/orarootagent.bin" for action "check" failed: details at "(:CLSN00010:)" in "/data/11.2.0/grid/log/db-41/agent/ohasd/orarootagent_root/orarootagent_root.log"
2012-04-25 14:46:17.031
[gpnpd(25510)]CRS-2328:GPNPD started on node db-41.
2012-04-25 14:46:20.794
[cssd(25593)]CRS-1713:CSSD daemon is started in clustered mode
2012-04-25 14:46:22.520
[ohasd(25286)]CRS-2767:Resource state recovery not attempted for 'ora.diskmon' as its target state is OFFLINE
2012-04-25 14:46:40.715
[cssd(25593)]CRS-1707:Lease acquisition for node db-41 number 1 completed
2012-04-25 14:46:42.003
[cssd(25593)]CRS-1605:CSSD voting file is online: /dev/mapper/Vote03; details in /data/11.2.0/grid/log/db-41/cssd/ocssd.log.
2012-04-25 14:46:42.008
[cssd(25593)]CRS-1605:CSSD voting file is online: /dev/mapper/Vote02; details in /data/11.2.0/grid/log/db-41/cssd/ocssd.log.
2012-04-25 14:46:42.015
[cssd(25593)]CRS-1605:CSSD voting file is online: /dev/mapper/Vote01; details in /data/11.2.0/grid/log/db-41/cssd/ocssd.log.
2012-04-25 14:46:52.173
[cssd(25593)]CRS-1601:CSSD Reconfiguration complete. Active nodes are db-41 .
2012-04-25 14:46:54.177
[ctssd(25738)]CRS-2407:The new Cluster Time Synchronization Service reference node is host db-41.
2012-04-25 14:46:54.177
[ctssd(25738)]CRS-2401:The Cluster Time Synchronization Service started on host db-41.
[client(25843)]CRS-10001:25-Apr-12 14:46 ACFS-9391: Checking for existing ADVM/ACFS installation.
[client(25848)]CRS-10001:25-Apr-12 14:46 ACFS-9392: Validating ADVM/ACFS installation files for operating system.
[client(25850)]CRS-10001:25-Apr-12 14:46 ACFS-9393: Verifying ASM Administrator setup.
[client(25853)]CRS-10001:25-Apr-12 14:46 ACFS-9308: Loading installed ADVM/ACFS drivers.
[client(25856)]CRS-10001:25-Apr-12 14:46 ACFS-9154: Loading 'oracleoks.ko' driver.
[client(25913)]CRS-10001:25-Apr-12 14:46 ACFS-9154: Loading 'oracleadvm.ko' driver.
[client(25974)]CRS-10001:25-Apr-12 14:46 ACFS-9154: Loading 'oracleacfs.ko' driver.
[client(26099)]CRS-10001:25-Apr-12 14:46 ACFS-9327: Verifying ADVM/ACFS devices.
[client(26103)]CRS-10001:25-Apr-12 14:46 ACFS-9156: Detecting control device '/dev/asm/.asm_ctl_spec'.
[client(26107)]CRS-10001:25-Apr-12 14:46 ACFS-9156: Detecting control device '/dev/ofsctl'.
[client(26113)]CRS-10001:25-Apr-12 14:46 ACFS-9322: completed
2012-04-25 14:47:06.975
[ohasd(25286)]CRS-2807:Resource 'ora.asm' failed to start automatically.

[ctssd(25738)]CRS-2405:The Cluster Time Synchronization Service on host db-41 is shutdown by user
2012-04-25 14:51:25.852
[/data/11.2.0/grid/bin/orarootagent.bin(25523)]CRS-5016:Process "/data/11.2.0/grid/bin/acfsload" spawned by agent "/data/11.2.0/grid/bin/orarootagent.bin" for action "check" failed: details at "(:CLSN00010:)" in "/data/11.2.0/grid/log/db-41/agent/ohasd/orarootagent_root/orarootagent_root.log"
2012-04-25 14:51:35.716
[cssd(25593)]CRS-1603:CSSD on node db-41 shutdown by user.
2012-04-25 14:51:35.725
[ohasd(25286)]CRS-2767:Resource state recovery not attempted for 'ora.cssdmonitor' as its target state is OFFLINE
2012-04-25 14:51:36.224
[cssd(25593)]CRS-1660:The CSS daemon shutdown has completed
2012-04-25 14:51:38.144
[gpnpd(25510)]CRS-2329:GPNPD on node db-41 shutdown.

重建spfile :

+ASM.asm_diskgroups='DATA','ARCH'
*.
asm_diskstring='/dev/mapper/*'
*.
asm_power_limit=1
*.
diagnostic_dest='/data/app/oracle'
*.
instance_type='asm'
*.
large_pool_size=12M
#*.local_listener='LISTENER_+ASM'
*.
remote_login_passwordfile='EXCLUSIVE'
 
 
egpfile 拉起  ASM instance mount data group
 
SQL>create spfile='+DATA' from pfile='xxx';

[grid@db-41 ~]$ sqlplus ‘/as sysa[......]

Read more

Tags: ,
Posted in Oracle Experience | No Comments »

Create a database link with the new host:port/service syntax

Posted by admin on 8th March 2012

Create a database link with the new host:port/service syntax

Submitted by tanelpoder on Mon, 2012-03-05 15:57

Share
I just noticed that (finall[......]

Read more

Tags:
Posted in Oracle Experience | 1 Comment »

11g new feature Index Invisible

Posted by admin on 15th February 2012

11g为我们提供了Index Invisible特性,使用这个特性可以轻松的将index置为不可用状态,对比之前的将索引置为unusable
最大的改进是,当index设置为unusable时,索引将不再随着表数据的更新而更新,导致如果重新使用index 需要rebuild等操作
这对大型的OL[......]

Read more

Tags:
Posted in Oracle Experience | No Comments »