故障处理
huangliang0703
这个作者很懒,什么都没留下…
展开
-
ksvcreate: Process creation failed
昨日数据库巡检,用户的测试库在数据库开启、关闭时过程漫长,数据库连接以及简单的查询反应很慢,查看alert日志:Shutting down instance: further logons disabledThu Feb 13 12:24:56 2014ksvcreate: Process(q001) creation failedThu Feb 13 12:26:16 2014原创 2014-02-14 10:26:50 · 1010 阅读 · 0 评论 -
11g等待事library cache: mutex X
从GC 上发现有一个库的 活动会话超多,sqlplus 进去看了一下等待事件,全是:library cache: mutex X 是由一个 update 语句造成的 ,sql_id 为 2tyrw2x2dwxzxupdate ecboss_salesOrder set version=version+1, lastUpdateT原创 2015-11-12 13:49:37 · 2892 阅读 · 0 评论 -
ALTER SYSTEM KILL SESSION
一个用户进程偶尔会挂起或占用过多资源而拒绝其它会话。如果DBA依然能够访问数据库,她通常可以发出以下查询:转载 2014-06-23 11:45:54 · 1347 阅读 · 0 评论 -
kill session
An active session cannot be interrupted whenit is performing network I/O or rolling back a transaction. Such a session cannot beterminated until the operation completes. In this case, the session原创 2014-07-13 11:17:11 · 537 阅读 · 0 评论 -
ORA-00054: 资源正忙, 但指定以 NOWAIT 方式获取资源, 或者超时失效
SQL> drop table T_ACCOUNT0410 purge;drop table T_ACCOUNT0410 purgeORA-00054: 资源正忙, 但指定以 NOWAIT 方式获取资源, 或者超时失效查看当前活动会话,没有活动会话怎么drop 不了,突然意识到,表上有锁,造成锁的这个会话也不一定是活动的。 SID SERIAL# USERN原创 2017-04-11 19:07:01 · 556 阅读 · 0 评论 -
insert append 操作的注意事项
昨晚做一个数据割接,将两张表的数据以 append 方式 插入到 A 表,割到一段时间之后,发现大量的TM 锁HOLDER SID ID1 ID2 LMODE REQUEST TYPE CTIME BLOCK INST_ID------- ---------- ---------- ---------- -原创 2017-03-10 07:30:21 · 1722 阅读 · 0 评论 -
ORA-19573: cannot obtain exclusive enqueue for datafile 5
用vi 编辑了一个数据文件 ,导致下面的错误:RMAN> validate datafile 5;Starting validate at 2015-06-29 22:26:23using channel ORA_DISK_1channel ORA_DISK_1: starting validation of datafilechannel ORA_DISK_1: specifyin原创 2015-06-30 10:40:27 · 2047 阅读 · 0 评论 -
library cache: mutex X
发现数据库存在 ;library cache: mutex X 等待事件 (ID 1357946.1)Top 5 Timed Foreground EventsEventWaitsTime(s)Avg wait (ms)% DB timeWait Classlibrary cache: mute原创 2015-05-05 17:01:46 · 1992 阅读 · 0 评论 -
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
CAUSEIf we defer an Archive Destination to a Standby Database, the Primary Database will still consider the Standby Database as existing but temporary unavailable eg. for Maintenance. This can happe原创 2015-04-17 09:32:31 · 4517 阅读 · 0 评论 -
关闭oracle 资源管理
top 5事件:EventWaitsTime(s)Avg wait (ms)% DB timeWait Classlog file sync4,026,62324,206643.73Commitenq: TX - i原创 2015-01-30 15:45:03 · 1700 阅读 · 0 评论 -
EXP-00068
连接到: Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit ProductionWith the OLAP and Oracle Data Mining optionsJServer Release 9.2.0.6.0 - Production已导出 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集原创 2014-06-30 10:46:23 · 1313 阅读 · 0 评论 -
ORA-12545: Connect failed because target host or object does not exist
[oracle@ybdbtest oradata]$ sqlplus /nologSQL*Plus: Release 9.2.0.4.0 - Production on Thu Jun 26 10:16:29 2014Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.SQL> c原创 2014-06-26 11:57:57 · 10013 阅读 · 0 评论 -
EXP-00008: ORACLE error 904 encountered
C:\Users\Administrator>exp huang1/huang1@redhat tables=t file=c:\exp.dmpExport: Release 11.2.0.1.0 - Production on Thu Jun 26 11:34:33 2014Copyright (c) 1982, 2009, Oracle and/or its affil原创 2014-06-26 12:02:28 · 1580 阅读 · 0 评论 -
Private strand flush not complete
在一次巡检中,发现某数据库告警日志文件中有如下错误:Tue Feb 11 12:47:55 2014Thread 1 cannot allocate new log, sequence 5380Private strand flush not complete Current log# 3 seq# 5379 mem# 0: /dev/rxREDOLOG03转载 2014-02-14 09:28:23 · 627 阅读 · 0 评论 -
WARNING: inbound connection timed out (ORA-3136)
近日数据库巡检,发现某库告警日志报:Wed Feb 12 13:37:59 2014WARNING: inbound connection timed out (ORA-3136)Wed Feb 12 15:04:50 2014Thread 1 advanced to log sequence 16651 (LGWR switch)以下资料来自:http://hi.转载 2014-02-14 10:09:34 · 710 阅读 · 0 评论 -
ORA 600 [qcisSetPlsqlCtx:tzi init]
问题出现背景:数据库迁移,源目端数据库版本为11.2.0.1 ,将控制文件、数据文件等全部拷贝到目的端,将库拉起后,告警日志文件里面有以下报错:Errors in file /home/oracle/app/diag/rdbms/zszjk/ZSZJK/trace/ZSZJK_ora_19763.trc (incident=7265):ORA-00600: 内部错误代码, 参数: [q...原创 2018-10-10 09:55:08 · 587 阅读 · 0 评论