PostgreSQL数据恢复博客

Phone:18180207355 提供专业Oracle/MySQL/PostgreSQL数据恢复、性能优化、迁移升级、紧急救援等服务

Archive for the troubleshooting Category

通过调整_lm_cache_res_cleanup解决shared Pool问题

本站文章除注明转载外，均为本站原创：转载自love wife love life —Roger的Oracle […]

Tags: 10.2.0.4.12, ges resource, ges_cache_ress, ora-04031, shared pool, _lm_cache_res_cleanup
Posted in Oracle rdbms, troubleshooting on 2月 3, 2016 | There are currently 1 Comment

mapid溢出导致Oracle RAC 节点重启

本站文章除注明转载外，均为本站原创：转载自love wife love life —Roger的Oracle […]

Tags: ora-15064, [kffilCreate01], [ORA_NPI_ERROR]
Posted in rac & dg, troubleshooting on 10月 7, 2015 | There are currently No Comments

11.2.0.4 RAC CRS diskgroup auto dismount问题

本站文章除注明转载外，均为本站原创：转载自love wife love life —Roger的Oracle […]

Tags: 11.2.0.4 rac, ORA-15078, PROT-602
Posted in rac & dg, troubleshooting on 9月 4, 2015 | There are currently 1 Comment

LMHB terminating RAC instance due to ora-29770

本站文章除注明转载外，均为本站原创：转载自love wife love life —Roger的Oracle […]

Tags: 11.2.0.4, IBM PowerVM, LMHB terminating instance, ORA-29770 LMS1 hung for more than 70 seconds, oracle rac, processor folding
Posted in Oracle rdbms, rac & dg, troubleshooting on 8月 15, 2015 | There are currently No Comments

11.2.0.4 ASM RAC 恢复一个例子

本站文章除注明转载外，均为本站原创：转载自love wife love life —Roger的Oracle […]

Tags: ORA-00283, ORA-00308, ora-00600 2662, ORA-00600 [4137], ORA-00600 [504], ORA-00604, ORA-00704, ORA-01110, ORA-01194, ORA-01547, ORA-01552, ora-01555, ORA-08102, ORA-12012, ORA-16433, ORA-27037, [4193], [4511], [6002], [ktsplbfmb-dblfree]
Posted in backup & rcovery, troubleshooting on 7月 19, 2015 | There are currently No Comments

library cache lock引发的一个案例

本站文章除注明转载外，均为本站原创：转载自love wife love life —Roger的Oracle […]

Tags: 10.2.0.5, event 10049, hanganalyze, library cache lock, library cache pin
Posted in troubleshooting on 5月 21, 2015 | There are currently 1 Comment

PMON crash the instance of RAC

本站文章除注明转载外，均为本站原创：转载自love wife love life —Roger的Oracle […]

Tags: ora-00600, ORA-1154, pmon crash instance, rac, [kjucvl:!busy], [kjuscv]
Posted in Oracle rdbms, troubleshooting on 2月 11, 2015 | There are currently No Comments

A RAC node crash due to ora-00481

本站文章除注明转载外，均为本站原创：转载自love wife love life —Roger的Oracle […]

Tags: instance crash, LMON process terminated, ora-00481, oracle rac
Posted in Oracle rdbms, rac & dg, troubleshooting on 1月 21, 2015 | There are currently No Comments

Root cause of the Rac Instance crash ？

本站文章除注明转载外，均为本站原创：转载自love wife love life —Roger的Oracle […]

Tags: 10.2.0.5.0, aix, Goldengate, instance crash, OGG-01738, ORA-27300, ORA-27301, ORA-27302, oracle rac, swap
Posted in Oracle rdbms, troubleshooting on 11月 16, 2014 | There are currently No Comments

The cause of system hung is cursor: pin X ?

本站文章除注明转载外，均为本站原创：转载自love wife love life —Roger的Oracle […]

Tags: 10.2.0.4, cursor: pin X, mutex, oracle hung
Posted in troubleshooting on 10月 31, 2014 | There are currently No Comments

I/O slave wait 导致CPU 100%

本站文章除注明转载外，均为本站原创：转载自love wife love life —Roger的Oracle […]

Tags: aio, AIO-MAX-NR, asynch I/O kernel limits, io_submit, linux
Posted in troubleshooting on 10月 10, 2014 | There are currently No Comments

Wow,Index block have 169 ITLS ？

本站文章除注明转载外，均为本站原创：转载自love wife love life —Roger的Oracle […]

Tags: 10g rac delete node linux, 11.2.0.3.0, ora-00600, [kdsgrp1]
Posted in troubleshooting on 9月 28, 2014 | There are currently No Comments

Jdbc连接Oracle 12c 时快时慢的问题

本站文章除注明转载外，均为本站原创：转载自love wife love life —Roger的Oracle […]

Tags: 12.1.0.1, 12.1.0.2, connection slow, jdbc, oracle 12c
Posted in oracle database 12c, troubleshooting on 9月 26, 2014 | There are currently No Comments

Parallel Query 导致的ORA-04031

本站文章除注明转载外，均为本站原创：转载自love wife love life —Roger的Oracle […]

Tags: ora-00445, ora-04031, ORA-3136, parallel query, Px msg pool
Posted in troubleshooting on 9月 17, 2014 | There are currently No Comments

Linux NUMA引发的性能问题？

本站文章除注明转载外，均为本站原创：转载自love wife love life —Roger的Oracle […]

Tags: linux, NUMA, oracle 11.2.0.3, performance, SMP
Posted in troubleshooting on 8月 15, 2014 | There are currently No Comments

Oracle 11.2.0.3.9 RAC is hang (for Linux)

本站文章除注明转载外，均为本站原创：转载自love wife love life —Roger的Oracle […]

Tags: hang, latch: shared pool, library cache: mutex X, ora-00445, ora-29711, Oracle 11R2 rac on linux
Posted in troubleshooting on 7月 16, 2014 | There are currently No Comments

Instance immediate crash after open

本站文章除注明转载外，均为本站原创：转载自love wife love life —Roger的Oracle […]

Tags: 11.2.0.4, ora-00600 [17182], ora-00600 [kghfrempty:ds], ora-07445 [kghrst()
Posted in troubleshooting on 7月 9, 2014 | There are currently No Comments

PMON failed to acquire latch导致crash的案例联想

本站文章除注明转载外，均为本站原创：转载自love wife love life —Roger的Oracle […]

Tags: ORA-00474, pmon, Process(m000) creation failed, Smon
Posted in troubleshooting on 7月 4, 2014 | There are currently 1 Comment

数据库open报错ORA-01555: snapshot too old

本站文章除注明转载外，均为本站原创：转载自love wife love life —Roger的Oracle […]

Tags: ora-00600 4194, ORA-00604, ORA-00704, ora-01555
Posted in backup & rcovery, troubleshooting on 6月 19, 2014 | There are currently No Comments

11.2.0.3 RAC（VCS）节点crash以及hang的问题分析

本站文章除注明转载外，均为本站原创：转载自love wife love life —Roger的Oracle […]

Tags: 11.2.0.3 solaris, ora-29770, vertias
Posted in rac & dg, troubleshooting on 4月 23, 2014 | There are currently 2 Comments

love wife love life —Roger的Oracle/MySQL/PostgreSQL数据恢复博客

Categories

Archives

最新评论

国内圈子

oracle security

Archive for the troubleshooting Category

通过调整_lm_cache_res_cleanup解决shared Pool问题

mapid溢出导致Oracle RAC 节点重启

11.2.0.4 RAC CRS diskgroup auto dismount问题

LMHB terminating RAC instance due to ora-29770

11.2.0.4 ASM RAC 恢复一个例子

library cache lock引发的一个案例

PMON crash the instance of RAC

A RAC node crash due to ora-00481

Root cause of the Rac Instance crash ？

The cause of system hung is cursor: pin X ?

I/O slave wait 导致CPU 100%

Wow,Index block have 169 ITLS ？

Jdbc连接Oracle 12c 时快时慢的问题

Parallel Query 导致的ORA-04031

Linux NUMA引发的性能问题？

Oracle 11.2.0.3.9 RAC is hang (for Linux)

Instance immediate crash after open

PMON failed to acquire latch导致crash的案例联想

数据库open报错ORA-01555: snapshot too old

11.2.0.3 RAC（VCS）节点crash以及hang的问题分析