VMCD.ORG

Focus on Oracle mail:ylouis83#gmail.com

11.2.0.2 EXPDP 遭遇 ORA-4031

Posted by admin on 16th July 2012

一套oracle 11.2.0.2 数据仓库系统使用expdp导出数据时 进程hang 死 使用kill -9命令杀掉之后 database一直没有释放latch 通过下面的日志可以发现 pmon已经发现 ospid=15038的process dead 但是无法clean 进程在为 “fixed[......]

Read more

Tags:
Posted in Oracle Experience | No Comments »

ORA-16009 in alert log with standby and LGWR ASYNC

Posted by admin on 2nd December 2011

今天用10.2.0.1的一套物理DG 转 逻辑 standby 出现大量错误:

primary 端:

– Connected User is Valid
RFS[2]: Assigned to RFS process 30286
RFS[2]: Database moun[......]

Read more

Tags:
Posted in Oracle Experience | No Comments »