Category Archives: ORACLE

所有Oracle技术文章

包含OLAP组件SCHEMA使用imp导入碰到严重性能问题

Posted on 2012/08/08 by yangtingkun

客户一个十几个G的用户尝试使用IMP导入到数据库中，执行时间超过了2天。 数据库版本为10.2.0.5 FOR LINUX X86-64，而导入的dmp文件是在10.2.0.3 FOR LINUX X86平台上导出的，这个用户包含了OLAP组件。 整个导入过程异常缓慢，一共不到20G的数据量，导入的时间超过了两天。虽然imp导入效率不高，但是也没有理由慢到如此地步，通过10046跟踪imp进程： *** 2012-08-07 17:25:03.099 *** ACTION NAME:() 2012-08-07 17:25:03.051 *** MODULE NAME:(imp@db (TNS V1-V3)) 2012-08-07 17:25:03.051 *** SERVICE NAME:(SYS$USERS) 2012-08-07 17:25:03.051 *** SESSION ID:(880.53796) 2012-08-07 17:25:03.051 ===================== PARSING IN CURSOR #61 len=6 … Continue reading →

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

ORA-7445(kwqbcsoa)和ORA-7445(lstclo)错误

Posted on 2012/08/07 by yangtingkun

客户环境出现多次ORA-7445错误以及Oracle executable binary mismatch detected的告警信息。 数据库版本为10.2.0.3 for Linux，错误信息如下： Mon Aug 6 11:13:11 2012 WARNING: Oracle executable BINARY mismatch detected. BINARY OF NEW process does NOT MATCH BINARY which started instance issue ALTER system SET "_disable_image_check" = TRUE TO disable these … Continue reading →

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

ORA-600(kghstack_underflow_internal_2)错误

Posted on 2012/08/06 by yangtingkun

数据库10.2.0.3 for Linux 32环境出现ORA-600(kghstack_underflow_internal_2)错误。 详细错误信息为： Tue Aug 7 08:36:43 2012 Errors IN file /ora/app/oracle/admin/ORC/udump/orcl_ora_29455.trc: ORA-00600: internal error code, arguments: [kghstack_underflow_internal_2], [0xB72101E8], [], [], [], [], [], [] ORA-01013: USER requested cancel OF CURRENT operation ORA-01013: USER requested cancel OF CURRENT … Continue reading →

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

ORA-600(kssadd_stage: null parent)错误

Posted on 2012/08/05 by yangtingkun

客户数据库出现频繁的ORA-600(kssadd_stage: null parent)错误。 数据库版本为10.2.0.5 RAC for AIX，报错时详细错误信息为： Tue Jul 17 14:57:39 2012 Errors IN file /oracle/10g/admin/orcl/udump/orcl2_ora_307720.trc: ORA-00600: internal error code, arguments: [kssadd_stage: NULL parent], [], [], [], [], [], [], [] Tue Jul 17 14:57:45 2012 Errors IN file /oracle/10g/admin/orcl/udump/orcl2_ora_357344.trc: … Continue reading →

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

ORA-7445(xsSSEXECUT)错误

Posted on 2012/08/04 by yangtingkun

又一个OLAP组件相关的bug。 数据库版本为10.2.0.3 32bit for Linux，在告警日志出现下面的错误： Mon Jul 30 23:29:19 2012 Errors IN file /ora/app/oracle/admin/ORCL/udump/orcl_ora_24707.trc: ORA-07445: exception encountered: core dump [xsSSEXECUT()+13022] [SIGSEGV] [Address NOT mapped TO object] [0x14] [] []Mon Jul 30 23:29:19 2012 Errors in file /ora/app/oracle/admin/ORCL/udump/orcl_ora_24707.trc: ORA-07445: exception encountered: … Continue reading →

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

ORA-600(kghfremptyds)和ORA-600(kghasp1)错误

Posted on 2012/08/03 by yangtingkun

客户在进行OLAP的导入时出现了这个错误。 数据库版本为10.2.0.3，除了这两个错误外，同时还出现了其他的错误： Mon Jul 30 23:49:08 2012 Errors IN file /ora/app/oracle/admin/ORCL/udump/orcl_ora_31232.trc: ORA-00600: internal error code, arguments: [kghfrempty:ds], [0xAF509008], [], [], [], [], [], [] Mon Jul 30 23:49:09 2012 Errors IN file /ora/app/oracle/admin/ORCL/udump/orcl_ora_31232.trc: ORA-00600: internal error code, arguments: [kghasp1], [0xAF50AF34], … Continue reading →

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

小议ROWNUM

Posted on 2012/08/02 by yangtingkun

如何使用ROWNUM是个老生常谈的问题了，本来没有打算专门强调这个问题，但是最近在看Oracle的官方PL/SQL文档时发现了一个严重的错误，借这个机会还是简单说一下。 首先来看Oracle文档的描述，在10.2的PL/SQL文档中，Oracle关于PL/SQL中直接使用SELECT的查询描述为： Selecting At Most One ROW: SELECT INTO Statement IF you expect a query TO ONLY RETURN one ROW, you can WRITE a regular SQL SELECT statement WITH an additional INTO clause specifying the PL/SQL variable TO hold the … Continue reading →

Posted in ORACLE | Tagged , | Leave a comment

ORA-600(qerrmOStart2)(1756)错误

Posted on 2012/07/30 by yangtingkun

客户数据库出现ORA-600(qerrmOStart2)(1756)错误。 ORA-600(qerrmOStart2)错误：http://yangtingkun.itpub.net/post/468/527461 之前遇到过一次类似的qerrmOStart2错误，不过上次错误的第二个参数是1740。在上一篇文章中已经提到了，这个600错误只是一个表现，实际上真正的错误是第二个函数中体现的错误。 看一下具体的错误TRACE信息： *** SERVICE NAME:(SYS$USERS) 2012-05-24 17:23:39.684 *** SESSION ID:(598.169) 2012-05-24 17:23:39.684 *** 2012-05-24 17:23:39.684 ksedmp: internal OR fatal error ORA-00600: internal error code, arguments: [qerrmOStart2], [1756], [ORA-01756: quoted string NOT properly TERMINATED ], [], [], [], [], … Continue reading →

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

ORA-600(qersqCloseRem-2)错误

Posted on 2012/07/27 by yangtingkun

客户的10.2.0.4 RAC for Hp-un环境碰到了这个错误。 错误信息为： Wed Feb 29 19:42:05 2012 Errors IN file /opt/app/oracle/admin/orcl/udump/orcl1_ora_11261.trc: ORA-00600: internal error code, arguments: [qersqCloseRem-2], [Invalid Handle], [], [], [], [], [], [] ORA-02068: following severe error FROM WEBDB.COM ORA-03113: end-of-file ON communication channel Wed … Continue reading →

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

ORA-1595和ORA-1594错误

Posted on 2012/07/26 by yangtingkun

Oracle 9i上使用自动管理回滚的错误，简单记录一下。 错误信息为： Sat May 12 21:54:17 2012 Errors IN file /oracle/app/admin/prmdb/bdump/prmdb2_smon_483522.trc: ORA-01595: error freeing extent (2) OF ROLLBACK segment (19)) ORA-01594: attempt TO wrap INTO ROLLBACK segment (19) extent (2) which IS being freedSat May 12 21:54:17 2012 Errors … Continue reading →

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