ORA-07445,opidsa,bug 5648872.8

 技术学习  没有评论 »
152009
 

Bug 年年有,今年特别多,今天又遇到了 oracle 10.2.0.3 的一个 Bug,用户使用 PL/SQL 连接数据库(此库为DG的Primary Server),报 ora - 03113 错误。
[quote]Error: orA 3133
Text: archive request failed
——————————————————————————-
Cause: The request to archive a partition failed.
Action: Check the log file and correct any errors indicated.
For more information about the Spatial Data option, see Spatial Data Option Reference and Administrator's Guide>.[/quote]
通过后台 alert log 发现错误信息为 ora-07445
[quote]Tue Sep 15 15:31:52 2009
Errors in file /oracle/product/admin/C01A181_OFFEDA/udump/offeda_ora_11750.trc:
orA-07445: exception encountered: core dump [opidsa()+386] [SIGSEGV] [Address not mapped to object] [0x000000000] [] [][/quote]
通过 metalink 查找 orA-07445, opidsa()+386 这两个关键字,文档 435632.1 描述了此问题
[quote]PURPOSE:

This article provides information on one or more bugs that are
known to result in the given orA-7445 error.

SUGGESTIONS:

If the Known Issues section below does not help in terms of identifying
a solution, please submit the trace files and alert.log to oracle
Support Services for further analysis.

Known Issues:
Bug# 5648872 * See Note 5648872.8
* This bug is alerted in Note 418531.1
Dump (opidsa) from DESCRIBE of a cursor
Fixed: 10.2.0.4, 11.1.0.6, 10.2.0.3.P05[/quote]
查看文档 5648872.8,确认此为 Bug 5648872  Dump (opidsa) from DESCRIBE of a cursor

临时解决方案:
[code]SQL*Plus: Release 10.2.0.3.0 - Production on Tue Sep 15 16:11:33 2009

Copyright (c) 1982, 2006, oracle. All Rights Reserved.

Connected to:
oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> alter system flush shared_pool;

System altered.[/code]
永久解决方案,安装 Patch 5648872

ORA-00600 kmgs_pre_process_request_6

 技术学习  没有评论 »
102009
 

昨天在一台10.2.0.3的数据库中调整内存参数过后,数据库瞬间崩溃掉了,幸亏还没正式上线,不然。。。

[quote]Wed Sep 9 13:02:49 2009
Alter SYSTEM SET sga_target='4G' SCOPE=BOTH;
Wed Sep 9 13:03:21 2009
Alter SYSTEM SET shared_pool_size='300M' SCOPE=BOTH;
Wed Sep 9 13:12:15 2009
Errors in file /oracle/product/admin/FDC/bdump/fdc_mman_1598.trc:
orA-00600: internal error code, arguments: [kmgs_pre_process_request_6], [6], [192], [15], [3], [0x15F984FA0], [], []
Wed Sep 9 13:12:16 2009
Errors in file /oracle/product/admin/FDC/bdump/fdc_mman_1598.trc:
orA-00600: internal error code, arguments: [kmgs_pre_process_request_6], [6], [192], [15], [3], [0x15F984FA0], [], []
Wed Sep 9 13:12:16 2009
MMAN: terminating instance due to error 822
Instance terminated by MMAN, pid = 1598[/quote]

最怕的就是碰到 ora-00600 的错误了,在 metalink 上搜索了一把,发现自己很不幸的碰到了 bug 4433838

[quote]
Bug 4433838 Resizing cache crashes instance with OERI[kmgs_pre_process_request_6]
This note gives a brief overview of bug 4433838.
The content was last updated on: 09-MAY-2008
Click here for details of each of the sections below.

Affects:

Product (Component) oracle Server (Rdbms)
Range of versions believed to be affected Versions < 11
Versions confirmed as being affected

* 10.2.0.3

Platforms affected Generic (all / most platforms affected)

Fixed:

This issue is fixed in

* 10.2.0.4 (Server Patch Set)
* 11.1.0.6 (Base Release)

Description

Resizing the cache can crash the instance with
orA-600[kmgs_pre_process_request_6]. This can occur if SGA_TARGET
is set > 4Gb with the low order word of the size = 0.

Workaround:

Use a different sga_target such that lower order word is not zero.

Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. Always consult with oracle Support for advice.
[/quote]

Oracle 10g 下测试 exp 及 expdp

 技术学习  没有评论 »
032009
 

在做数据库升级时,经常是在8i,9i下用exp的方式导出数据,优化Schema之后,再imp数据进10g,很少有机会用到10g的新特性expdp和impdp,今天做了个小测试,其结果确实是惊人的,测试环境如下:

[quote]HP GL380G5
Red Hat Linux 4.4 64bit
8G Memory
oracle 10.2.0.3
[/quote]

拿存储有 lob 的表做测试,其中一个 partition 的数据总量为6G,先用 expdp 导出:

[code]Export: Release 10.2.0.3.0 - 64bit Production on Thursday, 03 September, 2009 16:01:09

Copyright (c) 2003, 2005, oracle. All rights reserved.

Connected to: oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Starting "SYSTEM"."SYS_EXPORT_TABLE_01": system/******** dumpfile=tx_04.dmp tables=FDCUSER.TX_RUN_DATA:DATE_200904 LOGFILE=tx_04.log
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 8.632 GB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "FDCUSER"."TX_RUN_DATA":"DATE_200904" 6.818 GB 7130813 rows
Master table "SYSTEM"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_TABLE_01 is:
/oracle/product/10.2.0/rdbms/log/tx_04.dmp
Job "SYSTEM"."SYS_EXPORT_TABLE_01" successfully completed at at 16:10:42
[/code]

整个过程耗时9分33秒

再用exp导出

[code]Export: Release 10.2.0.3.0 - Production on Thu Sep 3 16:13:25 2009

Copyright (c) 1982, 2005, oracle. All rights reserved.

Connected to: oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)

About to export specified tables via Direct Path ...
Current user changed to FDCUSER
Table TX_RUN_DATA will be exported in conventional path.
. . exporting table TX_RUN_DATA
. . exporting partition DATE_200904
...........................................................................
...........................................................................
...........................................................................
...........................................................................
...........................................................................
...........................................................................
...........................................................................
...........................................................................
...........................................................................
......................................
7130813 rows exported
Export terminated successfully without warnings.
[/code]

整个过程耗时40分钟。

Powered by WordPress 3.3.1 CopyRight 2004~2012, Sonic Tang

虚拟主机赞助商:海波,苏ICP备11082989号

Suffusion theme by Sayontan Sinha