IMPDP ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified
IMPDP ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specifiedIssue: ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified Detail: On importing schema i got following messag...
kkjcre1p: unable to spawn jobq slave process, error 1089
kkjcre1p: unable to spawn jobq slave process, error 1089FroM:http://www.xifenfei.com/2125.html闲着无聊,看历史的alert文件,发现kkjcre1p: unable to spawn jobq slave process, error 1089警告Thu Jul 8 21...
AUD: Audit Commit Delay exceeded, written a copy to OS Audit Trail
FroM: http://blog.itpub.net/27471208/viewspace-742124今天一上班,ORACLE以错误的形式来迎接我,alert错误如下:Wed Aug 29 01:31:03 2012Global Enqueue Services Deadlock detected. More info in file /u01/app/11.1.0/diag/rdbms/zzbrac2/zzbrac21/trace/zzbrac21_lmd0_5278.trc.Global Enque...
日志信息:kewastUnPackStats(): bad magic 1
日志信息:kewastUnPackStats(): bad magic 1 - Bug链接:http://www.eygle.com/archives/2012/06/kewastunpackstats.html在告警日志中,可能遇到大量如下提示信息:kewastUnPackStats(): bad magic 1 (0x000000002BC07DD9, 0)kewastUnPackStats(): bad magic 1 (0x000000002BC07DD9, 0)kewastUnPackStats():...
ORA-00845: MEMORY_TARGET not supported on this system
From: http://www.linuxidc.com/Linux/2012-12/76976.htm操作系统版本:CentOS 5.4数据库版本:11.2.0.2现象Oracle 11g数据库修改pfile参数后启动数据库报错ora-00845SQL> startupORA-00845: MEMORY_TARGET not supported on this system查找资料后发现问题如下,见metalinikID 46...
Fatal NI connect error 12170.
From:问题:Fatal NI connect error 12170. VERSION INFORMATION: TNS for Linux: Version 11.2.0.1.0 - Production Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production &nbs...
Oracle中关于bitmap index的使用问题
From:http://www.linuxidc.com/Linux/2011-10/45487.htm您如果熟悉 Oracle 数据库,我想您对 Thomas Kyte 的大名一定不会陌生。 Tomas 主持的 asktom.oracle.com 网站享誉 Oracle 界数十年,绝非幸致。最近在...
ORA-01461
FROM:http://junsansi.itpub.net/post/29894/476074ORA-01461的解决过程~~近日生产库中的一个过程报出了ora-1461的错误,虽然错误实际处理起来非常简单,但解决过程中与yangtingkun老大就该问题思想火花...
ORA-01555: "_SYSSMU9$" too small
问题:Thu Apr 18 22:00:05 2013ORA-01555 caused by SQL statement below (SQL ID: 718f2y09dnvbr, Query Duration=0 sec, SCN: 0x000e.57bdf6c7):Thu Apr 18 22:00:05 2013 select /*+ no_parallel(t) no_par...
ORA-00060: Deadlock detected(场景模拟)
from:http://www.cnblogs.com/killkill/archive/2010/09/12/1824650.htmlORA-00060: Deadlock detected(场景1:单表并发更新) 先说说什么是死锁(Deadlock),关于死锁...
oracle 设置事件ora-14400
alter session set events '10046 trace name context forever,level 12';alter session set events '10046 trace name context off';最好做一下tkprofalter system set events '14400 trace name errorst...
ORA-01144: File size (string blocks) exceeds maxi
From:http://ljx198308.blog.163.com/blog/static/176274246201112223035742/ORA-01144: File size (string blocks) exceeds maxi ...
2012-03-20 17:58 WARNING: inbound connection timed out (ORA-3136)
WARNING: inbound connection timed out (ORA-3136)连接超时问题Oracle Dba 2009-03-24 13:28:12 阅读189 评论0 字号:大中小 /**时间:2009-03-23 *环境:windows2003 Oracle10g*WARNING: inbound...
ORACLE10G ORA-20000问题处理详解
问题现象:数据库库出现ORA-20000错误:Errors in file /home/oracle/admin/zjindex/bdump/zjindex2_j002_615322.trc:ORA-12012: error on auto execute of job 8887ORA-20000: ORA-20000: Content of the tablespa...
ORACLE10G 监听僵死问题的解决
引用:http://miracle.blog.51cto.com/255044/118830/创作品,允许转载,转载时请务必以超链接形式标明文章 原始出处 、作者信息和本声明。否则将追究法律责任。http://miracle.blog.51cto.com/255044/118830 &nbs...
Oracle ORA-07445 [0000000000000000] 错误分析
http://blog.csdn.net/tianlesoftware/article/details/80869601. OS 和DB 版本DB Version: 9.2.0.6OS Version:HP-UXiasd5_pb B.11.23 U ia64 0515426764 unlimited-user license 2.alert lo...
.监听日志错误: WARNING: Subscription for node down event still pending
[oracle@financedbp ~]$ vi /oracle/product/10.2.0/network/admin/listener.oraSID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = wxxrdb)  ...
Thread 1 cannot allocate new log
转Thread 1 cannot allocate new log 2012-03-19 15:12:00| 分类: ORA等错误处理 | 标签: |字号大中小 订阅 今天发现alter.log有以下信息:Thread 1 cannot ...
Thread 1 cannot allocate new log 的处理办法
Thread 1 cannot allocate new log 的处理办法 Thread 1 cannot allocate new log 的处理办法 分类: Oracle 2012-05-29 17:28 1027人阅读 评论(0) 收藏 举报 ALTER SYSTEM ARCHIVE LOGThread 1 cannot ...
ora_00257
今天数据库出现这个问题[sznmc-ora@nmc]$oerr ORA 0025700257, 00000, "archiver error. Connect internal only, until freed."现在用户都连不上数据库,连就报这个错,高手帮忙啊近几天数据库一直在清理老旧数据。...