http://yangtingkun.itpub.net Thu,09 02 2012 11:53:01 http://www.plogworld.net 客户数据库在调整SGA后，导出出现ORA-31623错误。Oracle对于这个错误的描述为：ORA-31623: a job is not attached to this session via the specified handleCause: An attempt to reference a job using a handle which is invalid or no longer valid for the current session.Action: Select a handle corresponding to a valid active job or start a new job.从这个错误看不出导致问题的真正原因，不过从告警日志中可以发现进一步的信息：Tue Jan 17 19:30:08 2012Errors in file /opt/oracle/diag/rdbms/mobiledb_n/mobiledb/trace/... http://yangtingkun.itpub.net/post/468/526241 http://yangtingkun.itpub.net/post/468/526241 http://yangtingkun.itpub.net/post/468/526241 yangtingkun ORACLE Tue,07 02 2012 23:23:58 yangtingkun 执行DDL时取消当前的操作出现这个错误。 详细错误信息如下：SQL> alter trigger DBFW_CONSOLE_ACCESS.TRIGGER_DDL disable;^Calter trigger DBFW_CONSOLE_ACCESS.TRIGGER_DDL disable*ERROR at line 1:ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []告警日志中信息为：Tue Feb 7 14:56:28 2012Errors in file /u01/app/oracle/admin/ORCL/udump/eygle_ora_21708.trc:ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []Tue Feb 7 14:56:38 2012Errors in ... http://yangtingkun.itpub.net/post/468/526213 http://yangtingkun.itpub.net/post/468/526213 http://yangtingkun.itpub.net/post/468/526213 yangtingkun Bug Mon,06 02 2012 23:54:44 yangtingkun 执行DDL时取消当前的操作出现这个错误。 详细错误信息如下：SQL> alter trigger DBFW_CONSOLE_ACCESS.TRIGGER_DDL disable;^Calter trigger DBFW_CONSOLE_ACCESS.TRIGGER_DDL disable*ERROR at line 1:ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []告警日志中信息为：Tue Feb 7 14:56:28 2012Errors in file /u01/app/oracle/admin/ORCL/udump/eygle_ora_21708.trc:ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []Tue Feb 7 14:56:38 2012Errors in ... http://yangtingkun.itpub.net/post/468/526213 http://yangtingkun.itpub.net/post/468/526213 http://yangtingkun.itpub.net/post/468/526213 yangtingkun ORACLE Mon,06 02 2012 23:54:44 yangtingkun 告警日志出现ORA-600[ktspNextL1:4]错误。 错误信息如下：Tue Jan 15 22:00:45 2012Errors in file /oracle/admin/orcl/bdump/orcl_j000_13722891.trc:ORA-00600: internal error code, arguments: [ktspNextL1:4], [], [], [], [], [], [], []Tue Jan 15 22:01:10 2012Trace dumping is performing id=[cdmp_20120131220118]Tue Jan 15 22:01:10 2012Errors in file /oracle/admin/orcl/bdump/ orcl_j000_13722891.trc:ORA-00600: internal error code, arguments: [ORA-00600: internal error code, arguments: [ktspN... http://yangtingkun.itpub.net/post/468/526198 http://yangtingkun.itpub.net/post/468/526198 http://yangtingkun.itpub.net/post/468/526198 yangtingkun Bug Sun,05 02 2012 23:57:28 yangtingkun 告警日志出现ORA-600[ktspNextL1:4]错误。 错误信息如下：Tue Jan 15 22:00:45 2012Errors in file /oracle/admin/orcl/bdump/orcl_j000_13722891.trc:ORA-00600: internal error code, arguments: [ktspNextL1:4], [], [], [], [], [], [], []Tue Jan 15 22:01:10 2012Trace dumping is performing id=[cdmp_20120131220118]Tue Jan 15 22:01:10 2012Errors in file /oracle/admin/orcl/bdump/ orcl_j000_13722891.trc:ORA-00600: internal error code, arguments: [ORA-00600: internal error code, arguments: [ktspN... http://yangtingkun.itpub.net/post/468/526198 http://yangtingkun.itpub.net/post/468/526198 http://yangtingkun.itpub.net/post/468/526198 yangtingkun ORACLE Sun,05 02 2012 23:57:28 yangtingkun 告警日志中出现JOB运行错误，而发生错误的任务是在收集统计信息。 错误信息如下：Fri Feb 2 22:00:05 2012GATHER_STATS_JOB encountered errors. Check the trace file.Fri Feb 2 22:00:05 2012Errors in file /oracle/admin/orcl/bdump/orcl_j000_23148.trc:ORA-01476: divisor is equal to zero显然这是数据库在晚上10点启动JOB来自动收集统计信息时出现了这个错误，那么问题多半是bug导致的，因为错误和用户的操作无关。查询MOS发现在文档Bug 6319761 - ORA-1476 from DBMS_STATS.GATHER_SCHEMA_STATS [ID 6319761.8]... http://yangtingkun.itpub.net/post/468/526195 http://yangtingkun.itpub.net/post/468/526195 http://yangtingkun.itpub.net/post/468/526195 yangtingkun Bug Sat,04 02 2012 23:40:36 yangtingkun 告警日志中出现JOB运行错误，而发生错误的任务是在收集统计信息。 错误信息如下：Fri Feb 2 22:00:05 2012GATHER_STATS_JOB encountered errors. Check the trace file.Fri Feb 2 22:00:05 2012Errors in file /oracle/admin/orcl/bdump/orcl_j000_23148.trc:ORA-01476: divisor is equal to zero显然这是数据库在晚上10点启动JOB来自动收集统计信息时出现了这个错误，那么问题多半是bug导致的，因为错误和用户的操作无关。查询MOS发现在文档Bug 6319761 - ORA-1476 from DBMS_STATS.GATHER_SCHEMA_STATS [ID 6319761.8]... http://yangtingkun.itpub.net/post/468/526195 http://yangtingkun.itpub.net/post/468/526195 http://yangtingkun.itpub.net/post/468/526195 yangtingkun ORACLE Sat,04 02 2012 23:40:36 yangtingkun 客户的10.2 RAC for Linux x86-64环境，计划停机后，尝试启动CLUSTER和DB，在一个节点上启动成功，但是另一个节点启动报错。 检查没有成功启动的节点，发现CLUSTER启动在/tmp目录下留下了记录：[root@smsdbrac1 root]# cd /tmp[root@smsdbrac1 tmp]# ls -ltotal 20-rw-r--r-- 1 oracle dba 78 Nov 30 00:30 crsctl.14429-rw-r--r-- 1 oracle dba 78 Nov 30 00:30 crsctl.14509-rw-r--r-- 1 oracle dba 78 Nov 30 00:30 crsctl.14578srwxr-xr-x 1 ncli ncli 0 Oct 8 15:22 mapping-nclisrwxr-xr-x 1 oracle dba 0 May 5 ... http://yangtingkun.itpub.net/post/468/526189 http://yangtingkun.itpub.net/post/468/526189 http://yangtingkun.itpub.net/post/468/526189 yangtingkun ORACLE Fri,03 02 2012 23:53:05 yangtingkun 和第一次碰到这个错误不同，这次是在10.2环境中出现的。 ORA-600(17281)(1001)错误：http://yangtingkun.itpub.net/post/468/514806 告警日志中错误信息为：Tue Jan 31 15:55:55 2012Errors in file /oracle/admin/ORCL/udump/orcl_ora_6225970.trc:ORA-00600: internal error code, arguments: [17281], [1001], [0x70000059AB9BE38], [], [], [], [], []ORA-01001: invalid cursor详细TRACE信息如下：Dump file /oracle/admin/ORCL/udump/orcl_ora_6225970.trcOracle Database 10g Enterprise Edition Release 10.2... http://yangtingkun.itpub.net/post/468/526179 http://yangtingkun.itpub.net/post/468/526179 http://yangtingkun.itpub.net/post/468/526179 yangtingkun Bug Thu,02 02 2012 23:50:14 yangtingkun 和第一次碰到这个错误不同，这次是在10.2环境中出现的。 ORA-600(17281)(1001)错误：http://yangtingkun.itpub.net/post/468/514806 告警日志中错误信息为：Tue Jan 31 15:55:55 2012Errors in file /oracle/admin/ORCL/udump/orcl_ora_6225970.trc:ORA-00600: internal error code, arguments: [17281], [1001], [0x70000059AB9BE38], [], [], [], [], []ORA-01001: invalid cursor详细TRACE信息如下：Dump file /oracle/admin/ORCL/udump/orcl_ora_6225970.trcOracle Database 10g Enterprise Edition Release 10.2... http://yangtingkun.itpub.net/post/468/526179 http://yangtingkun.itpub.net/post/468/526179 http://yangtingkun.itpub.net/post/468/526179 yangtingkun ORACLE Thu,02 02 2012 23:50:14 yangtingkun