OracleBlog – 第 28 页 – 笑看数据库江湖的那些事儿……

exp报错ora600[6193]

2011-05-02 没有评论

今天接到个case，有个exp的脚本导出报错了：

. . exporting table                       SRIRAM_1        169 rows exported
. . exporting table                      SRIRAM_10        126 rows exported
. . exporting table                       SRIRAM_2        169 rows exported
. . exporting table                          STATS      84915 rows exported
. . exporting table                        T76B001          0 rows exported
. . exporting table                        T76B002          0 rows exported
. . exporting table                            TMP        284 rows exported
. . exporting table           TMP_F56024A_20110410
EXP-00008: ORACLE error 600 encountered
ORA-00600: internal error code, arguments: [6191], [3], [11047], [16743], [], [], [], []
. . exporting table           TMP_F56024A_20110417
EXP-00008: ORACLE error 600 encountered
ORA-00600: internal error code, arguments: [6191], [3], [11419], [17180], [], [], [], []
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully with warnings.

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

. . exporting table SRIRAM_1 169 rows exported

. . exporting table SRIRAM_10 126 rows exported

. . exporting table SRIRAM_2 169 rows exported

. . exporting table STATS 84915 rows exported

. . exporting table T76B001 0 rows exported

. . exporting table T76B002 0 rows exported

. . exporting table TMP 284 rows exported

. . exporting table TMP_F56024A_20110410

EXP-00008: ORACLE error 600 encountered

ORA-00600: internal error code, arguments: [6191], [3], [11047], [16743], [], [], [], []

. . exporting table TMP_F56024A_20110417

EXP-00008: ORACLE error 600 encountered

ORA-00600: internal error code, arguments: [6191], [3], [11419], [17180], [], [], [], []

. exporting synonyms

. exporting views

. exporting stored procedures

. exporting operators

. exporting referential integrity constraints

. exporting triggers

. exporting indextypes

. exporting bitmap, functional and extensible indexes

. exporting posttables actions

. exporting materialized views

. exporting snapshot logs

. exporting job queues

. exporting refresh groups and children

. exporting dimensions

. exporting post-schema procedural objects and actions

. exporting statistics

Export terminated successfully with warnings.

从这个报错看，exp的时候有ora600，一般是遇到了bug。我们先手工的试试导出那个报错的表：

JPJDE@NMTAS303 [/home/oracle]
> exp PRODDTA/xxxxx tables=TMP_F56024A_20110410 direct=y file=TMP_F56024A_20110410.dmp log=TMP_F56024A_20110410.log

Export: Release 9.2.0.4.0 - Production on Mon May 2 11:29:46 2011

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
Export done in US7ASCII character set and UTF8 NCHAR character set
server uses JA16SJIS character set (possible charset conversion)

About to export specified tables via Direct Path ...
. . exporting table           TMP_F56024A_20110410
EXP-00008: ORACLE error 600 encountered
ORA-00600: internal error code, arguments: [6193], [4], [1165], [12168], [16743], [], [], []
Export terminated successfully with warnings.

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

JPJDE@NMTAS303 [/home/oracle]

> exp PRODDTA/xxxxx tables=TMP_F56024A_20110410 direct=y file=TMP_F56024A_20110410.dmp log=TMP_F56024A_20110410.log

Export: Release 9.2.0.4.0 - Production on Mon May 2 11:29:46 2011

Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production

With the Partitioning option

JServer Release 9.2.0.4.0 - Production

Export done in US7ASCII character set and UTF8 NCHAR character set

server uses JA16SJIS character set (possible charset conversion)

About to export specified tables via Direct Path ...

. . exporting table TMP_F56024A_20110410

EXP-00008: ORACLE error 600 encountered

ORA-00600: internal error code, arguments: [6193], [4], [1165], [12168], [16743], [], [], []

Export terminated successfully with warnings.

确实，我们也看到了对 […]

..experience, Working case

图解TSM客户端和服务器端的注册关系

2011-04-19 没有评论

下午向同事@SmartLikeMe 了解了TSM客户端如何注册到服务器端，画了个图，以作记录：上图的word文档，《TSM SERVER and CLIENT》，点击下载

It's my life

TSM恢复时报错ANS1314E

2011-04-17 没有评论

前段时间，在进行泰国的某数据库的容灾测试，大致的步骤是先在容灾机器上恢复操作系统，包括TSM的必要文件和TSM自身的数据库，再用TSM还原相应的文件，如oracle的软件，最后再用rman直接读取带库恢复数据库。在这里把遇到的报错做一记录，以备查验。我们的环境是数据库服务器和客户端在同一个机器上。 […]

..experience, Working case

利用iPhone手机的push技术提高运维效率

2011-04-11 6条评论

这篇文章你可以看作是软件介绍，你可以看作是数据库运维的经验谈，你可以把它看成是广告，但是我更希望它能抛砖引玉，提供一个新思维，让我们把维护工作做的更有效率。智能手机越来越普及了，几年前还高高在上的iPhone手机，现在已经变成街机。我周围很多优秀的运维工程师都已经用iPhone了，如新浪围脖上的@ […]

..experience, Working case

切换temp表空间引起大量enqueue

2011-03-26 6条评论

下面这个案例告诉我们，在一般的情况下，不要轻易的尝试在生产系统上切换temp表空间。如果真的要切换，还是找一个停机时间，关掉侦听，安安静静的做切换。事情的起因是这样的，某地的数据库由于业务异常，temp表空间从67G一下子增长到142G，造成在文件系统的空间使用紧张，因此我们决定用切换temp表空 […]

..experience, Working case

一次ORA-3136的处理

2011-03-04 10条评论

最近收到一个告警，用户说数据库无法连接，但是从监控上看，oracle的后台进程已经侦听进程还是在的，没有任何的alert。登录数据库，已经恢复正常，但是在数据库的alertlog中发现大量的ora-3136的报错：

Thu Feb 17 09:07:31 2011
WARNING: inbound connection timed out (ORA-3136)
Thu Feb 17 09:07:31 2011
WARNING: inbound connection timed out (ORA-3136)
Thu Feb 17 09:07:31 2011
WARNING: inbound connection timed out (ORA-3136)
Thu Feb 17 09:07:32 2011
WARNING: inbound connection timed out (ORA-3136)
Thu Feb 17 09:07:32 2011
WARNING: inbound connection timed out (ORA-3136)
Thu Feb 17 09:07:32 2011
WARNING: inbound connection timed out (ORA-3136)
Thu Feb 17 09:07:32 2011
WARNING: inbound connection timed out (ORA-3136)
Thu Feb 17 09:07:32 2011
WARNING: inbound connection timed out (ORA-3136)
Thu Feb 17 09:07:32 2011
WARNING: inbound connection timed out (ORA-3136)

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

Thu Feb 17 09:07:31 2011