数据库

--ORACLE 11.2.0.3 3节点RAC平台，hp-unix 11.31的系统--报错信息,ALERT日志Wed Dec 11 18:02:56 2013Thread 3 advanced to log sequence 2734 (LGWR switch) Current log# 13 seq# 2734 mem# 0: +DATA_DG/trsendb/redo13

一、现象：SQL/DEVELOPER，连接数据库时报了ORA-12505：TNS:listener does not currently kown of SID given in connect descriptor二、查看信息：1、lsnrctl status查看监听正常2、crs_stat -t  发现：ora.....d1.inst 目标状态和当前状态是OFFLINE，通过p

ALERT日志：Wed Sep 10 09:00:53 2014Errors in file /u01/app/oracle/diag/rdbms/trsendb/trsendb2/trace/trsendb2_ora_40371414.trc  (incident=821340):ORA-00600: internal error code, arguments: [504], [0

导数据遇到ORA-31626/ORA-31638/ORA-39077/ORA-6502报错信息如下：[oracle@vm010148 ~]$ expdp system/oracle directory=dir dumpfile=full.dmp logfile=full.logExport: Release 11.2.0.3.0 - Production on Sun Sep 28

-----环境信息[oracle@trsen02 bdump]$ uname -aLinux trsen02.yto.com 2.6.18-194.el5 #1 SMP Tue Mar 16 21:52:39 EDT 2010 x86_64 x86_64 x86_64 GNU/LinuxSQL> select * from v$version;BANNER---------

环境：11.2.0.3.6 双节点RAC系统：aix power system 6.1问题：一个节点在凌晨出现ORA-600错误alert日志：Global Enqueue Services Deadlock detected. More info in file /u01/app/oracle/diag/rdbms/trsen/trsen2/trace/trsen2_lmd0

--ORA-04031是个经典错误，一般情况是由于shared pool被耗尽导致，例如：未绑定变量导致的hard parse或大并发的shared pool本身太小，一般情况ORA-04031发生时会同时又相关等待事件出现cursor: pin S wait on X；library cache lock；latch: library cache；latch: shared pool等。