-
编辑 删除
一个抽取outlook邮件信息的VBA script
Sub CopyToExcel()Dim xlApp As Excel.ApplicationDim xlWB As Excel.WorkbookDim xlSheet As Excel.WorksheetDim olItem As Outlook.MailItemDim vText As VariantDim sText As StringDim xSubject As StringDim sT...
-
编辑 删除
ORA-00600: [kkocxj : pjpCtx]
ORA-00600: internal error code, arguments: [kkocxj : pjpCtx], [], [], [], [], [], [], [] SymptomsORA-00600 [kkocxj : pjpCtx] error is reported when running a complex query.CauseBug 7014646: ...
-
编辑 删除
ORA-00600: : [rworupo.1], [30], [24]
https://support.oracle.com/epmos/faces/ui/km/SearchDocDisplay.jspx?_afrLoop=193023897622639&type=DOCUMENT&id=850963.1&displayIndex=7&_afrWindowMode=0&_adf.ctrl-state=ooltnvwxr_74 Applies to: O...
-
编辑 删除
ORA-00600: internal error code, arguments: [kxfpg1sg:INV],
kill session后回滚时间太长，客户要求在OS 级杀spid，kill -9 spid 后，oracle突然重启。重启过程很快，10几秒就完成了，以至于我杀完OS 进程重新登陆数据库都没有发现。Fri Jul 20 06:14:28 2012Stopping backg...
-
编辑 删除
一次因临时表空间问题而导致的RAC节点failover
1, 收到警告邮件： 实例 xxx is down on server yyy-01 2, 上yyy-01 服务器查看警告日志，发现：Tue Mar 6 22:26:46 2012ORA-1652: unable to extend temp segment by 40964 in tablespace  ...
-
编辑 删除
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
“ORA-1652: unable to extend temp segment” 临时表空间被资源中的多个会话共享，并且quotas不能限制每个用户使用的临时表空间数量，当临时表空间被填充满时，任何尝试获得...
-
编辑 删除
ASM
http://docs.oracle.com/cd/E11882_01/server.112/e16102/asmfiles.htm ASM:Automatic Storage Management, 是Oracle 主推的一种面向Oracle的存储解决方案， ASM 和 RDBMS...
-
编辑 删除
ORA-02396: exceeded maximum idle time, please connect again .
ORA-02396: exceeded maximum idle time, please connect again
-
编辑 删除
oracle 内存分配之最细粒度granule
最近调整初始化参数，设置 db_8k_cache_size=2250m。 改完后，show 的时候发现值是 2256M。 原因是 _ksm_granule_size 参数， 它为最低粒度大小； 如果SGA_MAX_SIZE小于128M，则_ksm_granule_size为4M；如果SGA_M...
-
编辑 删除
ORA-04031: unable to allocate 3896 bytes of shared memory
诊断并解决ORA-04031 错误当我们在共享池中试图分配大片的连续内存失败的时候，Oracle首先清除池中当前没使用的所有对象，使空闲内存块合并。如果仍然没有足够大单个的大块内存满足请求,就会产生ORA-04031 错误...
-
编辑 删除
ORA-00308: cannot open archived log - BUG
< 518:ORA-00308: cannot open archived log '/arch_log1/CDWQ/CDWQ_1_907600_574942170.dbf'< 519:ORA-27041: unable to open fileOracle Alert Log Is Reporting Archive Log Status Is Not Available For Logs Th...
-
编辑 删除
ORACLE 中的 dual 表 对应 DB2 中的 SYSIBM.SYSDUMMY1 表
-
编辑 删除
library cache lock
一般来说,这类错误是因为在包或过程被频繁调用的过程中，DDL语句引起的，那我们该怎么处理呢?其实我们可以这样来操作来查原因，老板要的一般都是为什么产生这个故障和谁操作导致的这个故障，特别是...
-
编辑 删除
ORA-00001: unique constraint (PERFSTAT.STATS$UNDOSTAT_PK) violated
Errors in file /u01/app/oracle/admin/XXXXX/bdump/xxxxxx_j000_8892588.trc:ORA-12012: error on auto execute of job 1ORA-00001: unique constraint (PERFSTAT.STATS$UNDOSTAT_PK) violatedORA-06512: at "PERFS...
-
编辑 删除
ORA-01114: IO error writing block to file 201
oerr ora 111401114, 00000, "IO error writing block to file %s (block # %s)"// *Cause: The device on which the file resides is probably offline. If the // &nb...
-
编辑 删除
ORA-12547: TNS:lost contact
oerr ora 1254712547, 00000, "TNS:lost contact"// *Cause: Partner has unexpectedly gone away, usually during process// startup.// *Action: Investigate partner application for abnormal ter...
-
编辑 删除
查询重复记录
select count(*) from SMARTSTG.PROMOTIONU;select count(*) from (select distinct * from SMARTSTG.PROMOTIONU);select * from SMARTSTG.PROMOTIONU a where (a.MUNMBR,a.MULINE) in (select MUNMBR,MULINE ...
-
编辑 删除
ORA-16166 LGWR network server failed to send remote message
ORA-16166 LGWR network server failed ...
-
编辑 删除
ORA-12500: TNS:listener failed to start a dedicated server process
/oracle > oerr ora 1250012500, 00000, "TNS:listener failed to start a dedicated server process"// *Cause: The process of starting up a dedicated server process failed.// The executable could...
-
编辑 删除
Database can not startup under account not oracle
ERROR:ORA-09925: Unable to create audit trail fileIBM AIX RISC System/6000 Error: 13: Permission deniedAdditional information: 9925ORA-09925: Unable to create audit trail fileIBM AIX RISC ...
