Category Archives: ORACLE

所有Oracle技术文章

ORA-7445(opitca)错误

Posted on 2012/09/13 by yangtingkun

10.2.0.4 RAC环境出现ORA-7445[opitca]错误。 错误信息如下： Wed Oct 19 17:50:41 2011 Errors IN file /opt/app/oracle/admin/ora/udump/ora1_ora_26638.trc: ORA-07445: exception encountered: core dump [opitca()+4618] [SIGSEGV] [Address NOT mapped TO object] [0x000000000] [] [] Wed Oct 19 17:50:42 2011 Trace dumping IS performing id=[cdmp_20111019175042] Wed Oct 19 … Continue reading →

Posted in BUG | Tagged , , , | Leave a comment

ORA-7445(_intel_fast_memcpy.A)错误

Posted on 2012/09/12 by yangtingkun

在10.2.0.4 RAC for X86-64环境上出现了ORA-7445[_intel_fast_memcpy.A]的错误。 以前碰到过几次的memcpy有关的错误，但是这个错误函数是第一次碰到： Sat Apr 7 17:27:11 2012 Errors IN file /opt/app/oracle/admin/orcl/bdump/orcl1_j002_16579.trc: ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address NOT mapped TO object] [0x2A9734C000] [] []Sat Apr 7 17:27:11 2012 Errors in file /opt/app/oracle/admin/orcl/bdump/orcl1_j002_16579.trc: ORA-07445: exception encountered: … Continue reading →

Posted in BUG | Tagged , , , | Leave a comment

ORA-7445(kqlSubheapPin)错误

Posted on 2012/09/11 by yangtingkun

Oracle 10.2.0.4 for X86-64数据库出现ORA-7445[kqlSubheapPin]错误。 错误信息为： Tue Jul 26 13:27:05 2011 Errors IN file /opt/app/oracle/admin/ora/udump/ora1_ora_6729.trc: ORA-07445: exception encountered: core dump [kqlSubheapPin()+84] [SIGSEGV] [Address NOT mapped TO object] [0x000000110] [] []Tue Jul 26 13:27:05 2011 Errors in file /opt/app/oracle/admin/ora/udump/ora1_ora_6729.trc: ORA-07445: exception encountered: … Continue reading →

Posted in BUG | Tagged , , , , , , | Leave a comment

STANDBY数据库出ORA-1009错误

Posted on 2012/09/10 by yangtingkun

在10.2.0.4 DATA GUARD的STANDBY数据库中，出现了大量的ORA-1009错误。 错误信息为： Thu May 31 14:11:16 2012 FAL[client, MRP0]: Error 1009 fetching archived redo log FROM orcl Thu May 31 14:11:16 2012 Errors IN file /opt/app/oradir/admin/orcl_st/bdump/orcl_st_mrp0_23866.trc: ORA-01009: missing mandatory parameter Thu May 31 14:11:46 2012 FAL[client, MRP0]: Error … Continue reading →

Posted in BUG | Tagged , , , , , | Leave a comment

ORA-600(qerrmOStart2)(972)错误

Posted on 2012/09/09 by yangtingkun

关于ORA-600[qerrmOStart2]已经碰到第三次不同的错误了，简单记录一下这个问题。 数据库版本为10.2.0.5 RAC for Linux X86-64，错误信息为： Fri Jun 29 14:53:29 CST 2012 Errors IN file /opt/app/oracle/admin/ora/udump/ora2_ora_5832.trc: ORA-00600: internal error code, arguments: [qerrmOStart2], [972], [ORA-00972: identifier IS too long ], [], [], [], [], [] Fri Jun 29 14:53:36 CST 2012 … Continue reading →

Posted in BUG | Tagged , , , , , , | Leave a comment

SQLPLUS小技巧带行号SQL的粘贴

Posted on 2012/09/08 by yangtingkun

介绍一个SQLPLUS中粘贴SQL语句的小技巧。 除了Windows环境下的SQLPLUSW之外，当在sqlplus中运行了一个很长的语句后，得到的是一个带有行号的SQL： SQL> SELECT ksppinm name, 2 ksppstvl VALUE, 3 ksppdesc des 4 FROM x$ksppi x, x$ksppcv y 5 WHERE (x.indx = y.indx) 6 AND bitand(ksppiflg,268435456) = 0 7 AND ksppinm LIKE ‘max%size’; NAME VALUE DES —————— ————- ——————————- max_dump_file_size … Continue reading →

Posted in ORACLE | Tagged , , , , | Leave a comment

数据泵导入分区表长时间HANG住

Posted on 2012/09/07 by yangtingkun

客户10.2.0.3环境数据库在使用数据库导入分区表时，出现长时间HANG住的情况。 通过10046跟踪，发现等待发生在空闲等待wait for unread message on broadcast channel上，部分10046 TRACE摘录如下： ===================== PARSING IN CURSOR #27 len=93 dep=2 uid=0 oct=3 lid=0 tim=1314162845109698 hv=3190910778 ad=’5a938130′ SELECT NVL(SUM(data_io),0) FROM "SYS"."SEASHELL_ENTRY_P_20110126_88" WHERE process_order = :1 END OF STMT PARSE #27:c=0,e=76,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,tim=1314162845109693 BINDS #27: kkscoacd Bind#0 oacdty=02 … Continue reading →

Posted in BUG | Tagged , , , , | Leave a comment

单用户系统特征

Posted on 2012/09/06 by yangtingkun

偶然发现一个标准的单用户系统，和大家分享一下。 其实判断依据很简单，并不是通过会话数，或者检查是否只有一个非系统会话实现的，事实上是通过TOP 5等待得出的结论： Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class CPU time 79,791 78.7 log file sync 61,567,574 58,918 1 58.1 Commit log file parallel write 61,726,240 58,053 1 57.3 System I/O db file sequential read … Continue reading →

Posted in ORACLE | Tagged , , | Leave a comment

sqlplus注释行号错误的问题

Posted on 2012/09/04 by yangtingkun

又一个和注释有关的问题。 sqlplus注释导致语句重复执行：https://yangtingkun.net/?p=1155 和上一个错误类似，不过这个问题可能会使得用户认为SQLPLUS出现异常。 SQL> SELECT 2 1 3 FROM 4 dual; 1 ———- 1 SQL> SELECT /* 2 abc 3 SQL> select /* 2 abc 3 def 4 */ 5 1 6 FROM dual; 1 ———- 1SQL> select 2 1 … Continue reading →

Posted in ORACLE | Tagged , | Leave a comment

sqlplus注释导致语句重复执行

Posted on 2012/09/03 by yangtingkun

意外发现一个sqlplus上一个注释相关的bug。 看一个简单的例子： solaris*orcl-/home/oracle$ sqlplus test/test SQL*Plus: Release 11.2.0.3.0 Production ON Mon Jun 11 17:09:57 2012 Copyright (c) 1982, 2011, Oracle. ALL rights reserved.   Connected TO: Oracle DATABASE 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production WITH the Partitioning, Oracle … Continue reading →

Posted in ORACLE | Tagged , | Leave a comment