Category Archives: ORACLE

所有Oracle技术文章

ORA-600(kghpih:ds)错误

Posted on 2012/11/03 by yangtingkun

9206数据库在收集统计信息时出现这个错误。 错误信息如下： Fri Oct 14 05:00:52 2011 Errors IN file /opt/app/admin/orcl/bdump/orcl2_p010_16736.trc: ORA-00600: internal error code, arguments: [kghpih:ds], [0x494217CE8], [], [], [], [], [], [] Fri Oct 14 05:00:53 2011 Trace dumping IS performing id=[cdmp_20111014050053] Fri Oct 14 05:00:53 2011 Errors … Continue reading →

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

重启RAC实例无法启动报错CRS-1019

Posted on 2012/11/02 by yangtingkun

客户反馈在重启RAC环境后，发现CLUSTER启动正常，但是数据库实例没用启动。 根据客户的电话描述，Oracle尝试在节点1上启动实例2，在节点2上启动实例1，并导致错误CRS-1019。 从客户的描述上很难得到真正有意义的信息，于是请客户将详细的错误信息发给我： oracle@orcl1:/home/oracle>crs_start -ALL Attempting TO START `ora.orcl.orcl1.inst` ON member `orcl1` Attempting TO START `ora.orcl.orcl2.inst` ON member `orcl2` START OF `ora.orcl.orcl1.inst` ON member `orcl1` failed. orcl2 : CRS-1019: Resource ora.orcl.orcl1.inst (application) cannot run ON orcl2 START OF `ora.orcl.orcl2.inst` ON … Continue reading →

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

本机数据库数据库链无法访问远端数据库

Posted on 2012/10/30 by yangtingkun

在笔记本的本地数据库中创建数据库链，访问远端数据库，出现ORA-12170访问超时错误。 由于访问超时，首先检查网络，确认远端服务器是可以访问的： C:\Users\lenovo>ping 192.168.0.56 正在 Ping 192.168.0.56 具有 32 字节的数据: 来自 192.168.0.56 的回复: 字节=32 时间 conn test/test 已连接。 SQL> create database link enmo10 connect to test identified by test using ‘192.168.0.56/enmo10’; 数据库链接已创建。 SQL> select * from tab@enmo10; select * from … Continue reading →

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

ORA-600(kssadd: null parent)错误

Posted on 2012/10/29 by yangtingkun

Oracle 11.1.0.6数据库在归档到远端实例时出现这个错误。 详细错误信息为： Wed DEC 26 12:39:20 2012 Error 1017 received logging ON TO the standby ———————————————————— CHECK that the PRIMARY AND standby are USING a password file AND remote_login_passwordfile IS SET TO SHARED OR EXCLUSIVE, AND that the SYS … Continue reading →

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

ORA-600(kkoljt1)错误

Posted on 2012/10/28 by yangtingkun

又是一个ANSI标准SQL导致的BUG。 数据库版本10.2.0.1，错误信息为： Wed Nov 09 19:15:27 2011 Errors IN file c:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_784.trc: ORA-00600: 内部错误代码, 参数: [kkoljt1], [], [], [], [], [], [], []Wed Nov 09 19:15:27 2011 Errors in file c:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_784.trc: ORA-00600: 内部错误代码, 参数: [kkoljt1], [], [], [], [], [], [], … Continue reading →

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

ORA-7445(_kkdlavc)错误

Posted on 2012/10/27 by yangtingkun

客户10.2.0.1 for Windows出现ORA-7445错误。 没有打过补丁的数据库出现问题的几率果然很大： Thu Mar 29 15:11:50 2012 Errors IN file c:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_880.trc: ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [_kkdlavc+233] [PC:0x7F6661] [ADDR:0x0] [UNABLE_TO_READ] []Thu Mar 29 15:11:50 2012 Errors in file c:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_880.trc: ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [_kkdlavc+233] [PC:0x7F6661] [ADDR:0x0] [UNABLE_TO_READ] [] 这个问题是由于访问了一个不正常的视图所致，解决方法就是重建视图。关于这个bug的描述可以参考文档ORA-07445 … Continue reading →

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

ORA-7445(_kkqtnloCbk)错误

Posted on 2012/10/25 by yangtingkun

客户10.2.0.1 for Windows 32数据库出现ORA-7445[_kkqtnloCbk]错误。 告警日志中错误信息为： Tue Nov 08 14:56:39 2011 Errors IN file c:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_4720.trc: ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [_kkqtnloCbk+124] [PC:0x1DB818C] [ADDR:0xF5] [UNABLE_TO_READ] []Tue Nov 08 14:56:39 2011 Errors in file c:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_4720.trc: ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [_kkqtnloCbk+124] [PC:0x1DB818C] [ADDR:0xF5] [UNABLE_TO_READ] [] … Continue reading →

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

TNSNAMES配置中空格导致的bug（二）

Posted on 2012/10/25 by yangtingkun

之前一直认为这是Oracle的一个bug，直到前一段时间通读网络服务参考手册时，才发现问题的真相。 TNSNAMES配置中空格导致的bug：http://yangtingkun.itpub.net/post/468/487506 当时测试发现，只要在SERVICE_NAME下面的一行缺少空格，就会导致错误的产生： TEST08 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.25.13.229)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = test08) ) )TEST08 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.25.13.229)(PORT = 1521)) (CONNECT_DATA = … Continue reading →

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

收集STATSPACK的级别

Posted on 2012/10/24 by yangtingkun

虽然AWR功能已经完全可以替代STATSPACK的功能，但是目前存在的9i的数据库还有不少，而且却是发现有不少人不了解如何更改STATSPACK的级别。 STATSPACK默认是LEVEL 5收集，而LEVEL 5收集的数据是不包括执行计划的，因此对于关注SQL性能的情况，至少需要调整到LEVEL 6，下面是检查和调整STATSPACK收集等级的方法，比较简单，就不多解释了： SQL> EXEC statspack.snap PL/SQL PROCEDURE successfully completed. SQL> SELECT snap_id, dbid, snap_level FROM stats$snapshot; SNAP_ID DBID SNAP_LEVEL ———- ———- ———- 1 1258229964 5 1 ROW selected. SQL> EXEC statspack.snap(i_snap_level => 6) PL/SQL PROCEDURE successfully completed. … Continue reading →

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

ORA-7445(lnxadd)错误

Posted on 2012/10/23 by yangtingkun

一个由于低版本JDBC驱动导致的错误。 告警日志中错误信息为： Fri Aug 12 19:00:03 2011 Errors IN file /opt/app/oracle/admin/orcl/udump/orcl2_ora_28464.trc: ORA-07445: exception encountered: core dump [lnxadd()+471] [SIGSEGV] [Address NOT mapped TO object] [0x000000000] [] [] Fri Aug 12 19:00:04 2011 Trace dumping IS performing id=[cdmp_20110812190004]Fri Aug 12 19:00:03 2011 … Continue reading →

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