ORA-07445 ACCESS_VIOLATION,UNABLE_TO_READ问题处理
今天在处理Windows 平台的Oracle 10.2.0.3版本数据库升级到11.2.0.3版本时,系统出现以下的症状:-- AlertLOG警告日志Wed Dec 04 13:06:24 2013Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x18] [PC:0x2E7368C, hshget1()+198]Errors in file D:\APP\ADMINISTR...
How to Monitor the Progress of a Materialized View Refresh (MVIEW)
近期在处理一个MVIEW刷新量巨大的一个Case,特意从MOS搜索到该问题共享给大家参考:Applies to:Oracle Database - Enterprise Edition - Version 8.1.7.4 to 11.2.0.2 [Release 8.1.7 to 11.2]Information in this document applies to any platform.PurposeThe purpose of this article is to provide t...
ORA-07445[dbgrmqmqpk_query_pick_key()]问题处理
故障描述:- Alert日志报如下错误:Wed Nov 06 00:14:33 2013Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x9155F46, dbgrmqmqpk_query_pick_key()+2014]ERROR: Unable to normalize symbol name for the following short stack (at offset 199):dbgexProcessError()+193<-dbg...
Oracle 11g启动报ORA-28056、OS 1502错误
C:\>sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on 星期四 9月 13 22:49:08 2012  ...
解决Backup Exec备份Windows 2008操作系统出现"带异常的成功"问题
故障描述:在windows 2008中,Backup Eexc无论如何都会调用AFO功能备份相关数据且提示以下错误信息。Backup jobs fails with VSS Snapshot error. The Microsoft Volume Shadow Copy Service (VSS) sna...
BE Remote Agent与Oracle EM端口冲突
故障背景:本人遇到BE Remote Agent与Oracle EM其中一款产品无法正常运用;官方CASE:The Backup Exec Remote Agent for Windows Servers (RAWS) service by default uses port 10000. This is the indus...
Oracle 11g RAC操作DBCA期间报ORA-04031错误
DBCA建库期间,系统报以下错误信息:ORA-04031:unable to allocate 1572864 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","kks stbkt")解决方案:# vi /etc/sysctl.conf...
Windows XP中创建库遇到ORA-28056错误
问题:使用DBCA创建库时,遇到ORA-28056错误。解决方法:1. 首先中止安装,并退出。2. 进入系统管理,清空应用程序日志。3. 重新运行DBCA安装数据库。问题解决。...
[故障]ORA-01031: 权限不足
本次故障是由于朋友现场的一次域控故障无法修复,导致数据库需要从域中退出来所致。朋友原来以为退域后,系统FQDN保持不变即可以正常运用不影响。不过在通过SQLPLUS / AS SYSDBA登录系统时就报以下错误了:C:\>sql...