Category Archives: ORACLE

所有Oracle技术文章

ORA-600(kkzisf3g.5)错误

Posted on 2012/05/25 by yangtingkun

这个错误是在物化视图刷新过程中产生的。 数据库版本为10.1.0.4，在刷新物化视图时出现这个错误： Fri Nov 5 01:00:03 2010 Errors IN file /oracle/admin/orcl/bdump/orcl_j002_254624.trc: ORA-00600: internal error code, arguments: [kkzisf3g.5], [], [], [], [], [], [], [] Fri Nov 5 01:00:04 2010 Errors IN file /oracle/admin/orcl/bdump/orcl_j002_254624.trc: ORA-00600: internal error code, arguments: [kkzisf3g.5], [], … Continue reading →

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

ORA-600(1234)和ORA-600(729)错误

Posted on 2012/05/24 by yangtingkun

客户的ORACLE 10.1.0.4出现了这两个错误。 10.1的数据库并不多见，大部分使用10.1版本的也都升级到了10.2。而对于这两个错误而言，ORA-600[729]错误是很常见的内存泄漏问题，而相对来说ORA-600[1234]错误就少见得多了： Sun Sep 14 14:42:51 2008 Errors IN file /oracle/admin/orcl/udump/orcl_ora_266736.trc: ORA-00600: internal error code, arguments: [729], [160], [SPACE leak], [], [], [], [], [] Sun Sep 14 14:42:52 2008 Errors IN file /oracle/admin/orcl/udump/orcl_ora_266736.trc: ORA-00600: internal error code, arguments: … Continue reading →

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

RAC节点频繁重启出现ORA-29702

Posted on 2012/05/23 by yangtingkun

数据库的Oracle 10204 RAC for Windows出现频繁节点重启的问题。 从告警日志看，当前节点的重启一般发生在节点刚启动或关闭时： Thu May 03 17:22:45 2012 cluster interconnect IPC version:Oracle 9i Winsock2 TCP/IP IPC IPC Vendor 0 proto 0 Version 0.0 PMON started WITH pid=2, OS id=1616 DIAG started WITH pid=3, OS id=120 PSP0 started … Continue reading →

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

sqlplus直连数据库出现ORA-27504错误

Posted on 2012/05/22 by yangtingkun

客户数据库使用sqlplus直连方式连接数据库报错，而如果使用tnsnames方式则可以正常连接。 详细错误信息为： Thu Apr 26 10:17:56 2012 Errors IN file /oracle/admin/trs/udump/trs2_ora_2619.trc: ORA-00603: ORACLE server SESSION TERMINATED BY fatal error ORA-27504: IPC error creating OSD context ORA-27300: OS system dependent operation:IPC init failed WITH STATUS: 65 ORA-27301: OS failure message: Package … Continue reading →

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

ORA-600(krboReadBitmap_badbitmap)错误

Posted on 2012/05/21 by yangtingkun

一个备份导致的错误。 数据库版本为10.2.0.3 RAC for HP-UX，在备份数据库的时候出现了这个ORA-600错误： Sat Oct 29 04:39:31 2011 Errors IN file /u01/app/oracle/admin/ORCL/udump/orcl2_ora_29252.trc: ORA-00600: internal error code, arguments: [krboReadBitmap_badbitmap], [57599987], [+DATA/orcl/datafile/ts1.ora], [6], [30], [17629205], [1024], [52822033] Sat Oct 29 04:39:53 2011 Backup optimization FOR file +DATA/orcl/datafile/ts1.ora stopped due TO … Continue reading →

Posted in BUG | Tagged , , , , , , , | 1 Comment

ORA-7445(_kgscReleaseCursor)和ORA-4030错误

Posted on 2012/05/20 by yangtingkun

又一个ORA-4030引起的错误。 数据库版本10.2.0.3 for Windows 64环境。错误信息为： Tue Mar 13 20:51:28 中国标准时间 2012 Errors IN file d:\oracle\admin\orcl\udump\orcl_ora_6136.trc: ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [_kgscReleaseCursor+174] [PC:0x423AA92] [ADDR:0xC] [UNABLE_TO_READ] [] ORA-04030: 在尝试分配 244 字节 (kxs-heap-w,kntx.1) 时进程内存不足 Tue Mar 13 20:51:32 中国标准时间 2012 Errors IN file d:\oracle\admin\orcl\udump\orcl_ora_6136.trc: … Continue reading →

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

编译过程导致ORA-4068错误

Posted on 2012/05/19 by yangtingkun

一个10203上的bug，这种问题还是第一次碰到。 在10.2.0.3上，存在bug可能导致编译过程或视图失败，而失败的结果并不只是当前视图或过程不可用，而是可能影响整个数据字典，导致存储过程在执行时出现ORA-4068错误。 错误信息如下： ORA-04068: existing state OF packages has been discarded. ORA-04065: NOT executed, altered OR dropped stored PROCEDURE P_PACKAGE.P_PRO ORA-06508: PL/SQL: could NOT find program unit being called: P_PACKAGE.P_PRO ORA-06512: at line 1ORA-04068: existing state of packages has been … Continue reading →

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

ORA-600(kglobpn-bad-pga)错误

Posted on 2012/05/18 by yangtingkun

这个错误比较罕见，无论是GOOGLE还是METALINK都找不到任何的相关信息。 数据库版本是11.2.0.2 RAC环境，这个错误之所以这么罕见，也和11.2的版本太新，以致于很多问题都还没有暴露出来有关。 错误信息为： 2012-03-29 04:06:02.353000 +08:00 Errors IN file /oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_18355.trc (incident=144401): ORA-00600: internal error code, arguments: [kglobpn-bad-pga], [], [], [], [], [], [], [], [], [], [], [] Incident details IN: /oracle/diag/rdbms/orcl/orcl1/incident/incdir_144401/orcl1_ora_18355_i144401.trc 2012-03-29 04:10:12.017000 +08:00 Dumping diagnostic DATA IN … Continue reading →

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

ORA-7445(ksuklms)错误

Posted on 2012/05/17 by yangtingkun

客户的11.2.0.2 RAC环境出现了这个ORA-7445[ksuklms]错误。 错误信息为： 2012-05-10 16:25:38.561000 +08:00 Exception [TYPE: SIGSEGV, Address NOT mapped TO object] [ADDR:0x163A] [PC:0x100A554A8, ksuklms()+392] [flags: 0x0, COUNT: 1] Errors IN file /app/diag/rdbms/orcl/orcl1/trace/orcl1_ora_28387.trc (incident=449642): ORA-07445: exception encountered: core dump [ksuklms()+392] [SIGSEGV] [ADDR:0x163A] [PC:0x100A554A8] [Address NOT mapped TO object] … Continue reading →

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

ORA-600(kjbrrefp:key)和ORA-600(kjbmprlst:shadow)错误

Posted on 2012/05/16 by yangtingkun

这两个错误是由同一个BUG导致的。 数据库环境11.2.0.2 RAC for Solaris sparc，错误信息如下： 2012-01-29 06:15:10.168000 +08:00 Errors IN file /app/diag/rdbms/orcl/orcl1/trace/orcl1_lms3_81.trc (incident=384590): ORA-00600: internal error code, arguments: [kjbrref:pkey], [332269], [202], [137064], [0], [], [], [], [], [], [], [] Incident details IN: /app/diag/rdbms/orcl/orcl1/incident/incdir_384590/orcl1_lms3_81_i384590.trc USE ADRCI OR Support Workbench … Continue reading →

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