Working case – 第 5 页

Known Issues for Database and Query Performance Reported in 12C

2017-01-28 没有评论

LAST UPDATE:

Dec 13, 2016

1	Dec 13, 2016

APPLIES TO:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

1 2	Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.2 [Release 12.1] Information in this document applies to any platform.

PURPOSE:

In recent quarters, during non-code closure bug review for Performance, it was found that more than 50% of duplicates (36,96) closed by Sustaining Engineering (SE) belonged to version 12.1. As a result this document was created to list most commonly reported and share this with Tier-1 engineers so that they could check this before logging any new bugs. Thus the Goal of this document is to provide a list of known bugs reported in 12C for database & SQL performance for support analysts to check before logging new bugs.

In addition to the bugs listed in this article, there is also a useful list of Documented Database Bugs With High "Solved SR" Count where a high number of Service Requests means that there are more than 50 "Solved SR" entries for the bug - ie: all bugs in this doc have > 50 "Solved SR" entries.” :

Document 2099231.1 Documented Database Bugs With High "Solved SR" Count

1

2

3

4

5

In recent quarters, during non-code closure bug review for Performance, it was found that more than 50% of duplicates (36,96) closed by Sustaining Engineering (SE) belonged to version 12.1. As a result this document was created to list most commonly reported and share this with Tier-1 engineers so that they could check this before logging any new bugs. Thus the Goal of this document is to provide a list of known bugs reported in 12C for database & SQL performance for support analysts to check before logging new bugs.

In addition to the bugs listed in this article, there is also a useful list of Documented Database Bugs With High "Solved SR" Count where a high number of Service Requests means that there are more than 50 "Solved SR" entries for the bug - ie: all bugs in this doc have > 50 "Solved SR" entries.” :

Document 2099231.1 Documented Database Bugs With High "Solved SR" Count

DETAILS: Query Op […]

..experience, Working case

关于物理Dataguard切换导致索引坏块的问题

2017-01-10 一条评论

在11.2.0.2之后，有一个非常重要的dataguard的patch。在使用物理dataguard环境（包括ADG），进行switchover之后，存在导致index block上的invalid SCNs的坏块问题。国内已经好几个行业的大客户，都遇到了这个问题。在index block中的失 […]

..experience, Working case

swap不足导致ora-4030

2016-12-30 没有评论

客户一个测试环境，一个主机上面运行了很多数据库，某库的程序会时不时报错ora-4030。加大了pga，然后还检查了ulimit的 data 和 stack都是ulimit。还是报错。进而检查/var/adm/messages，发现有报错swap不足的情况。所以，解决方法是加大物理内存，或者加大 […]

..oracle service, Working case

Solaris操作系统真的停止开发了吗？

2016-12-23 一条评论

Solaris系统将被停止开发，这个消息，据我所看到的，最初的来源是来自thelayoff网站的消息『Solaris being canned, at least 50% of teams to be RIF’d in short term』 All hands meetings bei […]

..experience, Working case

闰秒（Leap Second）问题

2016-12-23 没有评论

2017年的第一天，因为闰秒的关系，加上时差的原因，我国将在北京时间2017年1月1日的7时59分59秒和全球同步进行闰秒调整，届时会出现7:59:60的特殊现象。(国家授时中心闰秒公告) 那么闰秒对数据库有什么影响？（一）具体的说：可以参考：Information Center: Leap S […]

Working case

解决主库报错HeartBeat failed to connect to standby Error 12154

2016-12-20 4条评论

有一个库自从上线之后，主库的alertlog中一直有如下报错：

Tue Dec 20 14:42:16 2016
Error 12154 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'rmydb'. Error is 12154.

1

2

3

Tue Dec 20 14:42:16 2016

Error 12154 received logging on to the standby

PING[ARC2]: Heartbeat failed to connect to standby 'rmydb'. Error is 12154.

1. 检查远端的standby库已经启动，且已经到了mount以上的状态（即在read only的模式下Real Time Apply）。 2. 检查主库到远端的tnsp […]

..experience, Working case

Huge page使用的一些问题

2016-12-06 没有评论

12c的数据库在安装的时候，有一个检查项目，叫做Maximum locked memory check。这是要求设置/etc/security/limits.conf中的memlock的值，官方文档在11g要求是设置比物理内存稍小的一个值，在12c中要求至少为90%的物理内存。而memlock的 […]

..experience, Working case

一次dataguard坏块的修复

2016-11-18 3条评论

客户有个11g的active dataguard库，mrp进程停了，看alertlog，可以看到有关ora-7445[kdxlin]的报错：

cat alert*.log
....
Exception [type:SIGSEOV,Address not mapped to object] [ADDR:0xC] |PC：0x96504C7,kdxlin()+4153][flags: 0x0,count:1]
Errors in le /aabb/app/oracle/rdbms/diag/rdbms/rmydbsid/mydbsid/trace/partsm_pr18_21343.trc (incident=70353):
ORA-07445: exception encountered: core dump (kdxlin()+4153) [SIGSEGV] [ADDR:0xC] |PC:0x96504C7][Address not mapped to object][]
Incident details in: /aabb/app/oracle/rdbms/diag/rdbms/rmydbsid/mydbsid/incident/incdir_70353/mydbsid_pr18_21343_i70353.trc
Use ADRCI or Support Workbench to package the incident.

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xC][PC:0x96504C7,kdxlin()+4153][flags:0XO,count:1]
Incidenl 70353 created, dump file/aabb/app/oracle/rdbms/diag/rdbms/rmydbsid/mydbsid/incident/incdir_70353/mydbsid_pr18_21343_i70353.trc
ORA-07445: exception encountered: core dump (kdxlin()+4153) [SIGSEGV] [ADDR:0xC] |PC:0x96504C7][Address not mapped to object][]
...

1

2

3

4

5

6

7

8

9

10

11

12

cat alert*.log

....

Exception [type:SIGSEOV,Address not mapped to object] [ADDR:0xC] |PC：0x96504C7,kdxlin()+4153][flags: 0x0,count:1]

Errors in le /aabb/app/oracle/rdbms/diag/rdbms/rmydbsid/mydbsid/trace/partsm_pr18_21343.trc (incident=70353):

ORA-07445: exception encountered: core dump (kdxlin()+4153) [SIGSEGV] [ADDR:0xC] |PC:0x96504C7][Address not mapped to object][]

Incident details in: /aabb/app/oracle/rdbms/diag/rdbms/rmydbsid/mydbsid/incident/incdir_70353/mydbsid_pr18_21343_i70353.trc

Use ADRCI or Support Workbench to package the incident.

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xC][PC:0x96504C7,kdxlin()+4153][flags:0XO,count:1]

Incidenl 70353 created, dump file/aabb/app/oracle/rdbms/diag/rdbms/rmydbsid/mydbsid/incident/incdir_70353/mydbsid_pr18_21343_i70353.trc

ORA-07445: exception encountered: core dump (kdxlin()+4153) [SIGSEGV] [ADDR:0xC] |PC:0x96504C7][Address not mapped to object][]

...

cat /aabb/app/oracle/rdbms/diag/rdbms/rmydbsid/mydbsid/incident/incdir_70353/mydbsid_pr18_21343_i70353.trc
...
Error 607 in redo applicalion callback
Dump of change vector
Typ:2 CLS:1 APN:5 DBA0x2598d645 OBJ:3S3792 SCN:0x0960.99d2655e SEQ:1 OP:10.2 ENC:0 RBL:0
index redo(kdxlin):insert leaf row
KTB Redo
op:0x01 ver:0x01
compat bit:4(post-11) padding:1
op:F xid:0x0001.01a.010d8f34 uba:0x00dc8e3.6bf5.20
REDO: SINGLE/NONKEY/--
itl:3, sno:255, row size 23
insert key:(14):05 c4 02 4e 31 4f 07 78 74 0b 09 11 27 29
nonkey (length: 5):
fb: --H-FL-- lb:0x0 cc:1
(2).01 80
Block after image is corrupt:
buffer tsn: 5 rdba:0x2598d645(1024/630773317)
scn:0x960.99d10d33 seq:0x01 flg:0x04 tail:0x0d330601
frmt:0x02 chkval:0xa1ae type:0x06=trans data
Hex dump of currupt header 3=CHKVAL
...

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

cat /aabb/app/oracle/rdbms/diag/rdbms/rmydbsid/mydbsid/incident/incdir_70353/mydbsid_pr18_21343_i70353.trc

...

Error 607 in redo applicalion callback

Dump of change vector

Typ:2 CLS:1 APN:5 DBA0x2598d645 OBJ:3S3792 SCN:0x0960.99d2655e SEQ:1 OP:10.2 ENC:0 RBL:0

index redo(kdxlin):insert leaf row

KTB Redo

op:0x01 ver:0x01

compat bit:4(post-11) padding:1

op:F xid:0x0001.01a.010d8f34 uba:0x00dc8e3.6bf5.20

REDO: SINGLE/NONKEY/--

itl:3, sno:255, row size 23

insert key:(14):05 c4 02 4e 31 4f 07 78 74 0b 09 11 27 29

nonkey (length: 5):

fb: --H-FL-- lb:0x0 cc:1

(2).01 80

Block after image is corrupt:

buffer tsn: 5 rdba:0x2598d645(1024/630773317)

scn:0x960.99d10d33 seq:0x01 flg:0x04 tail:0x0d330601

frmt:0x02 chkval:0xa1ae type:0x06=trans data

Hex dump of currupt header 3=CHKVAL

...

从trace中，我们可以看 […]

..experience, Working case

LGWR不工作在实时优先级

2016-11-15 没有评论

在solaris环境，在11.2.0.4之后（或者Patch 16387058 on top of 11.2.0.3.5），Oracle自动把LGWR进程放到_high_priority_processes中，（不管是单实例还是RAC）。在这之前，需要手工运行priocntl -s FX -m 60 […]

Working case

re-shard和chunk migration

2016-11-10 没有评论

添加或者删除shard，是shard的数量发生变化，叫做re-shard。re-shard会导致chunk的挪动（chunk migration），re-shard的chunk migration是将原来的chunk的序号大的部分，移动到新node上。示意图如下：我们来发起一次添加shard节点， […]

..oracle service

12.2 Now Available on Oracle Cloud

2016-11-09 没有评论

根据twitter上 ‏@OracleDatabase 的消息12.2在oracle云上已经可用了。具体的说，是在DBCS(Oracle Database Cloud Service) ，ECS(Exadata Cloud Service)，以及EECS(Exadata Express Cloud […]

..experience, Study note, Working case

SQL Plan Directives与过量的动态采样

2016-10-28 没有评论

在12c中，优化器进行了较大的改变，推出了Adaptive query optimization，从整体上说，Adaptive query optimization可以看作如下两部分：一部分是自适应执行计划，一部分是自适应统计信息。这里注意一下， • Adaptive Plans – 是在第一次 […]