谢太数据库: bug

Showing posts with label bug. Show all posts

Thursday, September 3, 2009

no login prompt in vm console

no login prompt in vm console
虚拟机终端没有登录提示

用xm console命令登录Xen创建的虚拟机, 屏幕上只显示启动时的信息, 没有登录提示, 按多次回车也有没反应, 如下:

Mounting other filesystems:  [  OK  ]
Starting sshd: [  OK  ]
Starting crond: [  OK  ]
Starting anacron: [  OK  ]
Starting atd: [  OK  ]
Starting Avahi daemon... [  OK  ]
Starting HAL daemon: [  OK  ]
Starting puppet: [  OK  ]
Starting smartd: [  OK  ]
INIT: version 2.86 reloading

按文档Console handling指示
需要在/etc/inittab增加一行xvc0, 并注释其它tty配置

co:2345:respawn:/sbin/agetty xvc0 9600 vt100-nav
#1:2345:respawn:/sbin/mingetty tty1
#2:2345:respawn:/sbin/mingetty tty2
#3:2345:respawn:/sbin/mingetty tty3
#4:2345:respawn:/sbin/mingetty tty4
#5:2345:respawn:/sbin/mingetty tty5
#6:2345:respawn:/sbin/mingetty tty6

在/etc/securetty增加一行

xvc0

修改完/etc/inittab后运行

init q

使之生效

再次连接虚拟机终端, 出现登录界面

# xm console 14
INIT: Sending processes the TERM signal

CentOS release 5.3 (Final)
Kernel 2.6.18-128.7.1.el5xen on an x86_64

vm02.zone101.bj4.company.com login:
CentOS release 5.3 (Final)
Kernel 2.6.18-128.7.1.el5xen on an x86_64

vm02.zone101.bj4.company.com login:

至于为何没有自动添加参数, 原因不明, 有可能是BUG
Bug 463855 - No login prompt after headless serial console installation with virtualization
Bug 448429 - xm console requires DomU getty modification to point to xvc0

-fin-

Friday, July 24, 2009

agent status shows negative available disk space

EM agent status shows negative available disk space
企业管理器代理状态显示可用磁盘空间为负数

问题:

Available disk space on upload filesystem    :    -7.17%
Collection Status                            : Disabled by Upload Manager
emctl status agent

出现上面的问题
但是df -h
才不到60%
10T，才用了6T

我都清了
也不成

Thread-35183520 ERROR upload: Exceeded max. amount of upload data: 2 files, 0.006033 MB Data. 104.26% of disk used. Disabling collections.
2009-07-21 20:13:42 Thread-35183520 WARN  collector: Disable collector
2009-07-21 20:13:42 Thread-35183520 ERROR collector: Collector state files cleaned, severity will be resent
2009-07-21 20:13:42 Thread-35183520 ERROR upload: Disabling Logging and Tracing: 1

这个就是错误

系统是32位的
而patch只有64位的

回答:

你现在的文件大小超过设定的阈值了
所以显示为负的?
或者是你的硬盘太大了, 计算溢出了, 也是有可能的

先排除了如下问题
Problem: 'emctl status agent' Command Shows Collection Status Disabled By Upload Manager
upload目录文件大小超过了设定的阈值

后怀疑是硬盘太大导致, 果然发现是个BUG, AVAILABLE DISK SPACE ON UPLOAD FILESYSTEM IS NEGATIVE. 文档AGENT STATUS SHOWS AVAILABLE DISK SPACE AS A NEGATIVE VALUE说当agent所在的文件系统达到了TB级, 就会出现问题. 10.2.0.4确认了此BUG, 可以打补丁或升级到10.2.0.5版本.

因为服务器是32位的, 没有补丁可打, 后来把agent挪到了一个比较小的分区上, 解决了问题

-fin-

Tuesday, May 12, 2009

unable to specify GMT timezone in kickstart in centos 5.3

unable to specify GMT timezone in kickstart in centos 5.3

安装centos/rhel 5.3时发现, 在kickstart文件中指定了系统时区

timezone --utc Etc/GMT

但是安装过程不能认出这个配置项, 仍然要人手工选择时区

这是一个已知的BUG
解决方法是, kickstart中指定一个可使用的时区, 然后再在%post修改为想要的时区, 比如:

...
timezone --utc America/New_York
...
%post
...
sed -i.orig '
/^ZONE=/c ZONE="Etc/GMT"
/^UTC=/c UTC=true
' /etc/sysconfig/clock
/usr/sbin/tzdata-update
...

该BUG还影响了其它一些时区, 描述见Why does Red Hat Enterprise Linux 5.3 prompt for a timezone when one is specified in the kickstart?

此BUG将在5.4版本被修复

另参见
Bug 461526 - Cannot set timezone
Bug 473647 - RFE: allow more timezones in kickstart
Bug 480226 - Anaconda not setting UTC or timezone from kickstart file.
Bug 481617 - RHEL 5.3 can't specify GMT timezone in kickstart
Bug 483094 - asking for GMT timezone in kickstart fails

-fin-

Friday, February 27, 2009

sqlplus hangs on infinite calling times(null)

sqlplus hangs on infinite calling times(null)

输入sqlplus回车没有反映,strace sqlplus跟踪发现在不停地调用times(NULL)

这是sqlplus 10.2.0.1的BUG, 在linux x86系统上如果运行时间大于249天就会发生
Bug 4612267 - OCI client spins when machine uptime >= 249 days

OCI clients may spin once the machine has been up for longer than
249 days (24.9 days on some machines).
The spin will show repeated calls to times() from sltrgatime64().

SQL*Plus 10.2.0.1 Hangs, When System Uptime Is Long Period of Time

补丁:OCI CLIENT IS IN AN INFINITE LOOP WHEN MACHINE UPTIME HITS 248 DAYS
或升级到10.2.0.2及以后版本

-fin-

Friday, February 13, 2009

ora-7445 drexumcx

又一个BUG

告警日志:

Thu Feb 12 22:24:04 2009
Errors in file /home/oracle/app/oracle/admin/s3db/udump/s3db1_ora_13380.trc:
ORA-07445: exception encountered: core dump [drexumcx()+89] [SIGSEGV] [Address not mapped to object] [0x000000008] [] []

跟踪文件:

*** 2009-02-12 22:10:23.482
*** ACTION NAME:() 2009-02-12 22:10:23.482
*** MODULE NAME:(JDBC Thin Client) 2009-02-12 22:10:23.482
*** SERVICE NAME:(s3db) 2009-02-12 22:10:23.482
*** SESSION ID:(283.18668) 2009-02-12 22:10:23.482
KGL recovered in-flux handle for lock 0x6aa21360
----------------------------------------
SO: 0x6aa21360, type: 53, owner: 0x6a8bf0b0, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=6aa21360 handle=d1dea280 request=S
call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
htl=0x6aa213e0[0x6a816948,0x6a6fc2f0] htb=0x6a6fc2f0 ssga=0x6a6fbcb8
user=df7323b0 session=df7323b0 count=0 flags=[0000] savepoint=0x6fcf
LIBRARY OBJECT HANDLE: handle=d1dea280 mtx=0xd1dea3b0(0) cdp=0
name=S3TEST.CONTENT_FULL_DESC DR$STATS$OBJ
hash=d7ca3ccc9536b6e7493158d66d857752 timestamp=NULL
namespace=CPOB flags=KGHP/TIM/FUP/XLR/[08000020]
kkkk-dddd-llll=0000-0001-0001 lock=X pin=X latch#=3 hpc=be26 hlc=be0a
lwt=0xd1dea328[0x6a788278,0x6a7c0550] ltm=0xd1dea338[0xd1dea338,0xd1dea338]
pwt=0xd1dea2f0[0xd1dea2f0,0xd1dea2f0] ptm=0xd1dea300[0xd1dea300,0xd1dea300]
ref=0xd1dea358[0xd1dea358,0xd1dea358] lnd=0xd1dea370[0xd1dea370,0xd1dea370]
  LOCK INSTANCE LOCK: id=LRd7ca3ccc9536b6e7
  PIN INSTANCE LOCK: id=NRd7ca3ccc9536b6e7 mode=X release=F flags=[00]
  LIBRARY OBJECT: object=7fc2a810
  type=CPOB flags=EXS/LOC/PRG[0085] pflags=[0000] status=VALD load=0
  DATA BLOCKS:
  data#     heap  pointer    status pins change whr
  ----- -------- -------- --------- ---- ------ ---
      0 d1cf4248 7fc2a928 I/P/A/-/-    0 NONE   00
*** 2009-02-12 22:24:04.851
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x8, PC: [0x510baef, drexumcx()+89]
*** 2009-02-12 22:24:04.865
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [drexumcx()+89] [SIGSEGV] [Address not mapped to object] [0x000000008] [] []
Current SQL statement for this session:
  declare
     cost sys.ODCICost := sys.ODCICost(NULL, NULL, NULL, NULL);
     arg0 VARCHAR2(1) := null;

    begin
      :1 := "CTXSYS"."TEXTOPTSTATS".ODCIStatsFunctionCost(
                     sys.ODCIFuncInfo('CTXSYS',
                            'CTX_CONTAINS',
                            'TEXTCONTAINS',
                            2),
                     cost,
                     sys.ODCIARGDESCLIST(sys.ODCIARGDESC(2, 'PHYSICAL_CONTENT_REVISION', 'S3TEST', '"FULL_DESCRIPTION"', NULL, NULL, NULL), sys.ODCIARGDESC(1, NULL, NUL
L, NULL, NULL, NULL, NULL))
                     , arg0, :5,
                     sys.ODCIENV(:6,:7,:8,:9));
      if cost.CPUCost IS NULL then
        :2 := -1.0;
      else
        :2 := cost.CPUCost;
      end if;
      if cost.IOCost IS NULL then
        :3 := -1.0;
      else
        :3 := cost.IOCost;
      end if;
      if cost.NetworkCost IS NULL then
        :4 := -1.0;
      else
        :4 := cost.NetworkCost;
      end if;
      exception
        when others then
          raise;
    end;
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0xde9c8d08        79  CTXSYS.TEXTOPTSTATS
0xde7ebbc0         6  anonymous block
0xde9832a0        10  function S3TEST.SEARCHCONTENTFORKEYWORDS
0xde2f5fe8         1  anonymous block
----- Call Stack Trace -----
calling              call     entry                argument values in hex
location             type     point                (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+31          call     ksedst1()            000000000 ? 000000001 ?
                                                   2B42B1E7CD50 ? 2B42B1E7CDB0 ?
                                                   2B42B1E7CCF0 ? 000000000 ?
ksedmp()+610         call     ksedst()             000000000 ? 000000001 ?
                                                   2B42B1E7CD50 ? 2B42B1E7CDB0 ?
                                                   2B42B1E7CCF0 ? 000000000 ?
ssexhd()+629         call     ksedmp()             000000003 ? 000000001 ?
                                                   2B42B1E7CD50 ? 2B42B1E7CDB0 ?
                                                   2B42B1E7CCF0 ? 000000000 ?
_L_mutex_unlock_15(  call     ssexhd()             00000000B ? 2B42B1E7DD70 ?
)+29                                               2B42B1E7DC40 ? 2B42B1E7CDB0 ?
                                                   2B42B1E7CCF0 ? 000000000 ?
drexumcx()+89        signal   _L_mutex_unlock_15(  2B42B1F19F18 ? 000000002 ?
                              )                    2B42B23B9840 ? 000000003 ?
                                                   2B42B23B9640 ? 2B42B23BAA60 ?
drexofcost()+143     call     drexumcx()           7FFFFA9386D0 ? 000000002 ?
                                                   2B42B23B9840 ? 000000003 ?
                                                   2B42B23B9640 ? 2B42B23BAA60 ?
spefcpfa()+867       call     drexofcost()         7FFFFA939C30 ? 2B42B23B9918 ?
                                                   2B42B23B9840 ? 2B42B23B9718 ?
                                                   2B42B23B9640 ? 2B42B23BAA60 ?
spefmccallstd()+993  call     spefcpfa()           FFFFFFFFFFFFFFFF ?
                                                   2B42B1F24990 ? 2B42B1F249D8 ?
                                                   7FFFFA938B70 ? 2B42B23B9640 ?
                                                   2B42B23BAA60 ?
pextproc()+41        call     spefmccallstd()      7FFFFA939C90 ? 7FFFFA939910 ?
                                                   7FFFFA9396B8 ? 7FFFFA939620 ?
                                                   000000000 ? 2B42B23BAA60 ?
peftrusted()+158     call     pextproc()           7FFFFA939C90 ? 7FFFFA939910 ?
                                                   7FFFFA9396B8 ? 7FFFFA939620 ?
                                                   000000000 ? 2B42B23BAA60 ?
psdexsp()+248        call     peftrusted()         7FFFFA939C90 ? 7FFFFA939910 ?
                                                   7FFFFA9396B8 ? 7FFFFA939620 ?
                                                   000000000 ? 2B42B23BAA60 ?
rpiswu2()+420        call     psdexsp()            7FFFFA9394A8 ? 7FFFFA939C90 ?
                                                   7FFFFA9396B8 ? 000020003 ?
                                                   0047B0976 ? 7FFFFA93A7C0 ?
psdextp()+739        call     rpiswu2()            0DF7323B0 ? 000000025 ?
                                                   7FFFFA939488 ? 000000002 ?
                                                   7FFFFA9394E0 ? 000000025 ?
pefccal()+571        call     psdextp()            7FFFFA93A7C0 ? 7FFFFA939910 ?
                                                   7FFFFA9396B8 ? 000000000 ?
                                                   7FFF00020003 ? 7FFFFA939C90 ?
pefcal()+208         call     pefccal()            004C6086E ? 7FFFFA939910 ?
                                                   7FFFFA9396B8 ? 0066876E0 ?
                                                   000798AE0 ? 7FFFFA939C90 ?
pevm_FCAL()+173      call     pefcal()             7FFFFA939C90 ? 006687860 ?
                                                   2B42B1F56BC8 ? 0066876E0 ?
                                                   000798AE0 ? 7FFFFA939C90 ?
pfrinstr_FCAL()+79   call     pevm_FCAL()          2B42B1F56BC8 ? 0A7832890 ?
                                                   2B42B1F56BC8 ? 0A7F07C88 ?
                                                   000798AE0 ? 7FFFFA939C90 ?
pfrrun_no_tool()+65  call     pfrinstr_FCAL()      2B42B1F56BC8 ? 0A764BD7E ?
                                                   2B42B1F56C30 ? 0A7F07C88 ?
                                                   000798AE0 ? 7FFFFA939C90 ?
pfrrun()+906         call     pfrrun_no_tool()     2B42B1F56BC8 ? 0A764BD7E ?
                                                   2B42B1F56C30 ? 0A7F07C88 ?
                                                   000798AE0 ? 7FFFFA939C90 ?
plsql_run()+841      call     pfrrun()             2B42B1F56BC8 ? 000000000 ?
                                                   2B42B1F56C30 ? 7FFFFA93A7C0 ?
                                                   000798AE0 ? 0C7A2D2C2 ?
peicnt()+298         call     plsql_run()          2B42B1F56BC8 ? 000000001 ?
                                                   000000000 ? 7FFFFA93A7C0 ?
                                                   000798AE0 ? 900000000 ?
kkxexe()+503         call     peicnt()             7FFFFA93A7C0 ? 2B42B1F56BC8 ?
                                                   2B42B1F282A8 ? 7FFFFA93A7C0 ?
                                                   2B42B1F24518 ? 900000000 ?
opiexe()+4691        call     kkxexe()             2B42B23D2830 ? 2B42B1F56BC8 ?
                                                   2B42B1F282A8 ? 0DFF46798 ?
                                                   0040C47BF ? 900000000 ?
opiodr()+984         call     opiexe()             000000004 ? 000000004 ?
                                                   7FFFFA93CB80 ? 00000001F ?
                                                   0040C47BF ? 900000000 ?
rpidrus()+198        call     opiodr()             000000004 ? 000000004 ?
                                                   7FFFFA93CB80 ? 00000001F ?
                                                   0059B04C0 ? 900000000 ?
skgmstack()+158      call     rpidrus()            7FFFFA93C3D8 ? 000000004 ?
                                                   7FFFFA93CB80 ? 00000001F ?
                                                   0059B04C0 ? 900000000 ?
rpidru()+116         call     skgmstack()          7FFFFA93C3B0 ? 0066872C0 ?
                                                   00000F618 ? 0022E9B48 ?
                                                   7FFFFA93C3D8 ? 900000000 ?
rpiswu2()+420        call     rpidru()             7FFFFA93CA70 ? 0066872C0 ?
                                                   00000F618 ? 0022E9B48 ?
                                                   7FFFFA93C3D8 ? 900000000 ?
rpidrv()+1519        call     rpiswu2()            0DF7323B0 ? 000000034 ?
                                                   0DF7323EC ? 000000002 ?
                                                   2B42B1F2FB10 ? 7FFF00000034 ?
rpiexe()+65          call     rpidrv()             00000001F ? 000000004 ?
                                                   7FFFFA93CB80 ? 00000000B ?
                                                   2B42B1F2FB10 ? 7FFF00000034 ?
kkexfuncfEval()+195  call     rpiexe()             00000001F ? 000000004 ?
2                                                  7FFFFA93CB80 ? 00000000B ?
                                                   2B42B1F2FB10 ? 7FFF00000034 ?
kkexfuncf()+4635     call     kkexfuncfEval()      2B42B23BF0C0 ? 000000034 ?
                                                   00000A146 ? 000000005 ?
                                                   2B42B23BF7A0 ? 7FFFFA93F378 ?
kkexFunc()+265       call     kkexfuncf()          0C7A78660 ? 7FFFFA93F4B0 ?
                                                   7FFFFA93F4A8 ? 2B42B23BF0C0 ?
                                                   2B4200000000 ? 2B42B23BF090 ?
kkeOperCost1()+164   call     kkexFunc()           2B42B1F03F48 ? 2B42B1F65C50 ?
                                                   7FFFFA93F530 ? 7FFFFA93F538 ?
                                                   7FEFFFFFFFFFFFFF ?
                                                   0D2E799A0 ?
kkeOperCost1()+1788  call     kkeOperCost1()       2B42B1F03F48 ? 2B42B1F65C50 ?
                                                   7FFFFA93F740 ? 7FFFFA93F738 ?
                                                   7FFFFA93F8F0 ? 7FFFFA93F8F4 ?
kkeOperCost()+326    call     kkeOperCost1()       2B42B1F03D70 ? 2B42B1F65C50 ?
                                                   7FFFFA9403B0 ? 7FFFFA9403B8 ?
                                                   7FFFFA93F8F0 ? 7FFFFA93F8F4 ?
kkepsl()+1942        call     kkeOperCost()        2B42B1F03D70 ? 2B42B1F65C50 ?
                                                   7FFFFA9403B0 ? 7FFFFA9403B8 ?
                                                   7FFFFA93F8F0 ? 7FFFFA93F8F4 ?
kkeosl()+1003        call     kkepsl()             2B42B1F03D70 ? 7FFFFA940358 ?
                                                   000000000 ? 2B42B1F65C50 ?
                                                   7FFFFA93F8F0 ? 7FFFFA93F8F4 ?
kkecdn()+8503        call     kkeosl()             2B42B1F041C8 ? 7FFFFA941CE0 ?
                                                   000000000 ? 000000001 ?
                                                   7FFF00000000 ? 2B42B1F65C50 ?
kkotap()+16656       call     kkecdn()             2B42B1F6F490 ? 000000002 ?
                                                   2B42B1F0CC80 ? 2B42B1F0E1A8 ?
                                                   2B42B1F0DC68 ? 2B42B1F65C50 ?
kkoiqb()+11059       call     kkotap()             2B42B1F0DC68 ? 2B42B1F0E4A0 ?
                                                   000000011 ? 000000000 ?
                                                   000000000 ? 2B42B1F65C50 ?
kkooqb()+986         call     kkoiqb()             2B42B1F0E1A8 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 2B42B1F65C50 ?
kkoqbc()+2083        call     kkooqb()             2B42B1F06DD8 ? 000000000 ?
                                                   000000000 ? 000000004 ?
                                                   000000000 ? 000000008 ?
apakkoqb()+170       call     kkoqbc()             7FFFFA945150 ? 2B42B1F06DD8 ?
                                                   000000000 ? 000000001 ?
                                                   000000000 ? 000000000 ?
apaqbdDescendents()  call     apakkoqb()           7FFFFA945150 ? 2B42B1F06DD8 ?
+399                                               0C7A788D8 ? 000000001 ?
                                                   000000000 ? 000000000 ?
apaqbdListReverse()  call     apaqbdDescendents()  7FFFFA945150 ? 2B42B1F06DD8 ?
+68                                                0C7A788D8 ? 000000001 ?
                                                   000000000 ? 000000000 ?
apadrv()+586         call     apaqbdListReverse()  7FFFFA945150 ? 2B42B1F06DD8 ?
                                                   0C7A788D8 ? 000000001 ?
                                                   000000000 ? 000000000 ?
opitca()+1512        call     apadrv()             0C7A788D8 ? 2B42B1F06DD8 ?
                                                   0C7A788D8 ? 000000001 ?
                                                   000000000 ? 000000000 ?
kksFullTypeCheck()+  call     opitca()             2B42B1F41D90 ? 0C7A788D8 ?
30                                                 0C7A788D8 ? 000000001 ?
                                                   000000000 ? 000000000 ?
rpiswu2()+420        call     kksFullTypeCheck()   7FFFFA9466F8 ? 0C7A788D8 ?
                                                   0C7A788D8 ? 000000001 ?
                                                   000000000 ? 000000000 ?
kksLoadChild()+9500  call     rpiswu2()            0DF7323B0 ? 000000034 ?
                                                   0B9347F9C ? 000000002 ?
                                                   0B9347C00 ? 100000034 ?
kxsGetRuntimeLock()  call     kksLoadChild()       0066876E0 ? 0D1A9AB30 ?
+1353                                              7FFFFA947B90 ? 000000000 ?
                                                   0B9347E38 ? 2B42B1F41D90 ?
kksfbc()+15084       call     kxsGetRuntimeLock()  0066876E0 ? 2B42B1F41D90 ?
                                                   7FFFFA947B90 ? 000000000 ?
                                                   0B9347E38 ? 2B42B1F41D90 ?
opiexe()+1884        call     kksfbc()             2B42B1F41D90 ? 000000003 ?
                                                   000000102 ? 000000000 ?
                                                   000000000 ? 7FFFFA948890 ?
opipls()+2025        call     opiexe()             000000004 ? 000000005 ?
                                                   7FFFFA94910C ? 000000016 ?
                                                   000000000 ? 7FFFFA948890 ?
opiodr()+984         call     opipls()             000000066 ? 000000006 ?
                                                   7FFFFA94A800 ? 000000000 ?
                                                   2B42B1F41D90 ? 000000000 ?
rpidrus()+198        call     opiodr()             000000066 ? 000000006 ?
                                                   7FFFFA94A800 ? 000000016 ?
                                                   0059B1410 ? 000000000 ?
skgmstack()+158      call     rpidrus()            7FFFFA949E48 ? 000000006 ?
                                                   7FFFFA94A800 ? 000000016 ?
                                                   0059B1410 ? 000000000 ?
rpidru()+116         call     skgmstack()          7FFFFA949E20 ? 0066872C0 ?
                                                   00000F618 ? 0022E9B48 ?
                                                   7FFFFA949E48 ? 000000000 ?
rpiswu2()+420        call     rpidru()             7FFFFA94A4E0 ? 0066872C0 ?
                                                   00000F618 ? 0022E9B48 ?
                                                   7FFFFA949E48 ? 000000000 ?
rpidrv()+1519        call     rpiswu2()            0DF7323B0 ? 000000034 ?
                                                   7FFFFA94A4C0 ? 000000002 ?
                                                   7FFFFA94A528 ? 000000034 ?
psddr0()+438         call     rpidrv()             000000016 ? 000000066 ?
                                                   7FFFFA94A800 ? 000000078 ?
                                                   7FFFFA94A528 ? 000000034 ?
psdnal()+386         call     psddr0()             000000016 ? 000000066 ?
                                                   7FFFFA94A800 ? 000000070 ?
                                                   7FFFFA94A528 ? 000000034 ?
pevm_EXECC()+376     call     psdnal()             7FFFFA94B340 ? 7FFFFA94B530 ?
                                                   7FFFFA94A800 ? 2B42B1F0FE88 ?
                                                   00000000B ? 000000034 ?
pfrinstr_EXECC()+80  call     pevm_EXECC()         2B42B2406228 ? 7FFFFA94B530 ?
                                                   000000020 ? 2B42B1F0FE88 ?
                                                   00000000B ? 000000034 ?
pfrrun_no_tool()+65  call     pfrinstr_EXECC()     2B42B2406228 ? 0C73CFDC2 ?
                                                   2B42B2406290 ? 2B42B1F0FE88 ?
                                                   00000000B ? 7FFF00000020 ?
pfrrun()+906         call     pfrrun_no_tool()     2B42B2406228 ? 0C73CFDC2 ?
                                                   2B42B2406290 ? 2B42B1F0FE88 ?
                                                   00000000B ? 7FFF00000020 ?
plsql_run()+841      call     pfrrun()             2B42B2406228 ? 000000000 ?
                                                   2B42B2406290 ? 7FFFFA94B340 ?
                                                   00000000B ? 0C7648946 ?
peicnt()+298         call     plsql_run()          2B42B2406228 ? 000000001 ?
                                                   000000000 ? 7FFFFA94B340 ?
                                                   00000000B ? 900000000 ?
kkxexe()+503         call     peicnt()             7FFFFA94B340 ? 2B42B2406228 ?
                                                   2B42B1F26DC8 ? 7FFFFA94B340 ?
                                                   2B42B1F24518 ? 900000000 ?
opiexe()+4691        call     kkxexe()             2B42B1F5F8E0 ? 2B42B2406228 ?
                                                   2B42B1F26DC8 ? 0DFF46798 ?
                                                   0040C47BF ? 900000000 ?
kpoal8()+2273        call     opiexe()             000000049 ? 000000003 ?
                                                   7FFFFA94C590 ? 000000011 ?
                                                   0040C47BF ? 900000000 ?
opiodr()+984         call     kpoal8()             00000005E ? 000000017 ?
                                                   7FFFFA94F470 ? 000000011 ?
                                                   000000001 ? 900000000 ?
ttcpip()+1012        call     opiodr()             00000005E ? 000000017 ?
                                                   7FFFFA94F470 ? 000000000 ?
                                                   0059B12D0 ? 900000000 ?
opitsk()+1322        call     ttcpip()             00668F3B0 ? 7FFFFA94D400 ?
                                                   7FFFFA94F470 ? 000000000 ?
                                                   7FFFFA94EF68 ? 7FFFFA94F5D8 ?
opiino()+1026        call     opitsk()             000000003 ? 000000000 ?
                                                   7FFFFA94F470 ? 000000001 ?
                                                   000000000 ? 4E526F400000001 ?
opiodr()+984         call     opiino()             00000003C ? 000000004 ?
                                                   7FFFFA950638 ? 000000000 ?
                                                   000000000 ? 4E526F400000001 ?
opidrv()+547         call     opiodr()             00000003C ? 000000004 ?
                                                   7FFFFA950638 ? 000000000 ?
                                                   0059B0D80 ? 4E526F400000001 ?
sou2o()+114          call     opidrv()             00000003C ? 000000004 ?
                                                   7FFFFA950638 ? 000000000 ?
                                                   0059B0D80 ? 4E526F400000001 ?
opimai_real()+163    call     sou2o()              7FFFFA950610 ? 00000003C ?
                                                   000000004 ? 7FFFFA950638 ?
                                                   0059B0D80 ? 4E526F400000001 ?
main()+116           call     opimai_real()        000000002 ? 7FFFFA9506A0 ?
                                                   000000004 ? 7FFFFA950638 ?
                                                   0059B0D80 ? 4E526F400000001 ?
__libc_start_main()  call     main()               000000002 ? 7FFFFA9506A0 ?
+244                                               000000004 ? 7FFFFA950638 ?
                                                   0059B0D80 ? 4E526F400000001 ?
_start()+41          call     __libc_start_main()  000713938 ? 000000002 ?
                                                   7FFFFA9507F8 ? 000000000 ?
                                                   0059B0D80 ? 000000002 ?
--------------------- Binary Stack Dump ---------------------

...

文档:
ORA-7445 (drexumcx)
Bug 5905736 - Dump (drexumcx) from Text query
补丁:
XF11.1OREDEF - TRC - DREXUMCX

-fin-

Tuesday, February 10, 2009

ORA-12899 with update trigger

又发现BUG

Java程序报错:

<Feb 9, 2009 5:08:16 PM GMT> <Warning> <MAS Logger> <BEA-000000> <com.motorola.screen3.server.app.newsreader.DCD08NewsReaderApplication: An exception thrown while executing
java.lang.RuntimeException: Error processing complete request with NewsReaderProcessor
        at com.motorola.screen3.server.app.newsreader.NewsReaderProcessor.processCompleteRequest(Unknown Source)
        at com.motorola.screen3.server.app.newsreader.DCD08NewsReaderApplication.getNewsReaderContentUpdateResponse(Unknown Source)
        at com.motorola.screen3.server.app.newsreader.DCD08NewsReaderApplication.execute(Unknown Source)
        at com.motorola.screen3.server.dcd.dcd08.DCD08ContentUpdateHandler.processApplication(Unknown Source)
        at com.motorola.screen3.server.dcd.framework.AbstractDCDContentUpdateHandler.doContentUpdate(Unknown Source)
        Truncated. see log file for complete stacktrace
java.rmi.RemoteException: EJB Exception: ; nested exception is:
        [1h16fe-fqzee7ur] Unable to execute statement: update SUBSCRIBERS set CHANNEL_HASH=?, CHANNEL_HASH_TIMESTAMP =? WHERE ID=? and CHANNEL_HASH=?
        at weblogic.ejb.container.internal.EJBRuntimeUtils.throwRemoteException(EJBRuntimeUtils.java:103)
        at weblogic.ejb.container.internal.BaseRemoteObject.handleSystemException(BaseRemoteObject.java:849)
        at weblogic.ejb.container.internal.BaseRemoteObject.handleSystemException(BaseRemoteObject.java:809)
        at weblogic.ejb.container.internal.BaseRemoteObject.postInvoke1(BaseRemoteObject.java:514)
        at weblogic.ejb.container.internal.StatelessRemoteObject.postInvoke1(StatelessRemoteObject.java:60)
        Truncated. see log file for complete stacktrace
[1h16fe-fqzee7ur] Unable to execute statement: update SUBSCRIBERS set CHANNEL_HASH=?, CHANNEL_HASH_TIMESTAMP =? WHERE ID=? and CHANNEL_HASH=?
        at com.fourthpass.util.dao.DAOUpdateStatement.execute(Unknown Source)
        at com.fourthpass.util.dao.DataAccessObject.execute(Unknown Source)
        at com.fourthpass.wpserver.dynamicportalmanager.dpo.DPSubscriberLookupDPO.updateChannelHash(Unknown Source)
        at com.fourthpass.wpserver.handlers.dynamicportalmanager.DefaultDynamicPortalManager.createActiveChannelsFromDownloadRights(Unknown Source)
        at com.fourthpass.wpserver.handlers.dynamicportalmanager.DefaultDynamicPortalManager.lookupActiveChannels(Unknown Source)
        Truncated. see log file for complete stacktrace
java.sql.SQLException: ORA-12899: value too large for column "S3TEST"."SUBSCRIBERS"."LAST_MODIFIED_DATE" (actual: 4552, maximum: 7)

        at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
        at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
        Truncated. see log file for complete stacktrace
>

表上建有触发器

CREATE OR REPLACE TRIGGER SUBSCRIBERS_MOD_DATE_TRIGGER
BEFORE INSERT OR UPDATE ON SUBSCRIBERS
FOR EACH ROW
BEGIN
:NEW.LAST_MODIFIED_DATE := SYSDATE;
END;

可能是BUG 7583083: ORA-12899 BEING HIT IN UPDATE (BEFORE UPDATE TRIGGER PRESENT)
上面说

customer confirmed that problem was resolved by install patch for 5868257.
note covering this issue: Note 752716.1 ==> will be published

跟ora-7445 _intel_fast_memcpy是同样的BUG啊?

看来以后装完Oracle后不仅要打PSR(Patch Set Release),CPU(Critical Patch Update),还必须打上最新的建议补丁集(Recommended Bundle),才能用啊, 尤其是RAC

外部链接:
GETTING ORA-12899 INTERMITTENTLY, WHILE INSERT/UPDATE ON DATE TYPE COLUMN
ORA-12899 BEING HIT IN UPDATE (BEFORE UPDATE TRIGGER PRESENT)
ORA-12899: value too large for column with Oracle Patch 10.2.0.4
Bug 5868257 - Dump / memory corruption from UPDATE DML

-fin-

Single resource deadlock with a zero DID

RAC有两个节点, 版本10.2.0.4

节点1告警日志:

Mon Feb  9 22:46:13 2009
Global Enqueue Services Deadlock detected. More info in file
 /home/oracle/app/oracle/admin/s3db/udump/s3db1_ora_9628.trc.
Mon Feb  9 22:46:13 2009
Trace dumping is performing id=[cdmp_20090209224613]
Mon Feb  9 22:52:13 2009
Trace dumping is performing id=[cdmp_20090209225213]

节点2告警日志:

Mon Feb  9 22:46:13 2009
Trace dumping is performing id=[cdmp_20090209224613]
Mon Feb  9 22:52:13 2009
Global Enqueue Services Deadlock detected. More info in file
 /home/oracle/app/oracle/admin/s3db/bdump/s3db2_j000_20610.trc.
Mon Feb  9 22:52:13 2009
Trace dumping is performing id=[cdmp_20090209225213]

bdump下产生许多cdmp(crash dump)目录

...
drwxr-x--- 2 oracle oinstall  4096 Feb  9 22:46 cdmp_20090209224613
drwxr-x--- 2 oracle oinstall  4096 Feb  9 22:52 cdmp_20090209225213

-rw-r----- 1 oracle oinstall 36864 Feb  9 22:46 s3db1_cjq0_13725.trw
-rw-r----- 1 oracle oinstall 38912 Feb  9 22:46 s3db1_ckpt_13719.trw
-rw-r----- 1 oracle oinstall 36864 Feb  9 22:46 s3db1_dbw0_13710.trw
-rw-r----- 1 oracle oinstall  6144 Feb  9 22:46 s3db1_diag_13692.trw
-rw-r----- 1 oracle oinstall 34816 Feb  9 22:46 s3db1_j000_13854.trw
-rw-r----- 1 oracle oinstall 32768 Feb  9 22:46 s3db1_j001_23488.trw
...

.trc跟踪文件显示:

*** 2009-02-09 22:46:13.208
*** ACTION NAME:() 2009-02-09 22:46:13.207
*** MODULE NAME:(JDBC Thin Client) 2009-02-09 22:46:13.207
*** SERVICE NAME:(s3db) 2009-02-09 22:46:13.207
*** SESSION ID:(255.38536) 2009-02-09 22:46:13.207
Single resource deadlock: blocking enqueue which blocks itself, f 1
Granted global enqueue 0xdd3e6960
----------enqueue 0x0xdd3e6960------------------------
lock version     : 546701
Owner node       : 0
grant_level      : KJUSERNL
req_level        : KJUSEREX
bast_level       : KJUSERNL
notify_func      : (nil)
resp             : 0x6a3ccf68
procp            : 0xdfe29248
pid              : 13854
proc version     : 0
oprocp           : (nil)
opid             : 0
group lock owner : (nil)
xid              : 0000-0000-00000000
dd_time          : 0.0 secs
dd_count         : 0
timeout          : 1.0 secs
On_timer_q?      : Y
On_dd_q?         : N
lock_state       : OPENING CONVERTING
Open Options     :  KJUSERPROCESS_OWNED
Convert options  : KJUSERNODEADLOCKWAIT KJUSERNODEADLOCKBLOCK
History          : 0x1495149a
Msg_Seq          : 0x0
res_seq          : 1343
valblk           : 0x00000000000000000000000000000000 .
user session for deadlock lock 0xdd3e6960
  pid=27 serial=15989 audsid=6558759 user: 52/S3TEST
  O/S info: user: oracle, term: UNKNOWN, ospid: 13854, machine: Perf-DB-1.s3lab.mot.com
            program: oracle@Perf-DB-1.s3lab.mot.com (J000)
  Current SQL Statement:
  DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;  broken BOOLEAN := FALSE; BEGIN process_events(); :mydate := next_date; IF broken T
HEN :b := 1; ELSE :b := 0; END IF; END;
Requesting global enqueue 0xdd2e3830
----------enqueue 0x0xdd2e3830------------------------
lock version     : 515577
Owner node       : 0
grant_level      : KJUSERPR
req_level        : KJUSEREX
bast_level       : KJUSERNL
notify_func      : (nil)
resp             : 0x6a3ccf68
procp            : 0xdfe367f0
pid              : 9628
proc version     : 82
oprocp           : (nil)
opid             : 0
group lock owner : (nil)
xid              : 0000-0000-00000000
dd_time          : 0.0 secs
dd_count         : 0
timeout          : 0.0 secs
On_timer_q?      : N
On_dd_q?         : N
lock_state       : CONVERTING
Open Options     :  KJUSERPROCESS_OWNED
Convert options  : KJUSERNODEADLOCKWAIT KJUSERNODEADLOCKBLOCK
History          : 0x49514955
Msg_Seq          : 0x0
res_seq          : 1343
valblk           : 0x00000000000000000000000000000000 .
user session for deadlock lock 0xdd2e3830
  pid=92 serial=38536 audsid=6558621 user: 52/S3TEST
  O/S info: user: s3op1, term: unknown, ospid: 1234, machine: Perf-app-3.s3lab.mot.com
            program: JDBC Thin Client
  application name: JDBC Thin Client, hash value=2546894660
  Current SQL information unavailable
----------resource 0x0x6a3ccf68----------------------
resname       : [0x49014fd][0xd8ee66f6],[IV]
Local node    : 0
dir_node      : 1
master_node   : 1
hv idx        : 60
hv last r.inc : 16
current inc   : 16
hv status     : 0
hv master     : 1
open options  :
Held mode     : KJUSEREX
Cvt mode      : KJUSERNL
Next Cvt mode : KJUSERNL
msg_seq       : 0x40005
res_seq       : 1343
grant_bits    : KJUSERNL KJUSERPR
grant mode    : KJUSERNL  KJUSERCR  KJUSERCW  KJUSERPR  KJUSERPW  KJUSEREX
count         : 1         0         0         2         0         0
val_state     : KJUSERVS_NOVALUE
valblk        : 0x00000000000000000000000000000000 .
access_node   : 0
vbreq_state   : 0
state         : x8
resp          : 0x6a3ccf68
On Scan_q?    : N
cache level   : 1
Total accesses: 140471
Imm.  accesses: 135217
Granted_locks : 2
Cvting_locks  : 1
value_block:  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
GRANTED_Q :
lp 0xdd0ceb40 gl KJUSERPR rp 0x6a3ccf68 [0x49014fd][0xd8ee66f6],[IV]
  master 1 pid 13740 bast 0 rseq 1343 mseq 0 history 0x49514951
  open opt  KJUSERPROCESS_OWNED
lp 0xdd2e3830 gl KJUSERPR rp 0x6a3ccf68 [0x49014fd][0xd8ee66f6],[IV]
  master 1 pid 9628 bast 0 rseq 1343 mseq 0 history 0x49514955
  open opt  KJUSERPROCESS_OWNED
CONVERT_Q:
lp 0xdd3e6960 gl KJUSERNL rl KJUSEREX rp 0x6a3ccf68 [0x49014fd][0xd8ee66f6],[IV]
  master 1 pid 13854 bast 0 rseq 1343 mseq 0 history 0x1495149a
  convert opt KJUSERNODEADLOCKWAIT KJUSERNODEADLOCKBLOCK
*** 2009-02-09 22:46:13.210
KSTDUMP: In-memory trace dump
TIME(usecs):SEQ# ORAPID   SID EVENT  OP DATA
========================================================================
096E4B4F:2676CB3E    92   255 10401   1 KSXPVSND: client 2 tid(2,257,0x2ac3730f) buf 0xdd542828 sz 400
096E4B71:2676CB3F    92   255 10005   1 KSL WAIT BEG [gc cr request] 7/0x7 658977/0xa0e21 1/0x1
...

xid是0000-0000-00000000

这是个BUG, Bug 6145177 - Single resource deadlock with a zero DID
下载补丁SINGLE RESOURCE DEADLOCK ON INSERT

Where to Find Files for Analyzing Errors

-fin-

Thursday, February 5, 2009

ora-7445 _intel_fast_memcpy

一种是,告警日志中报错 ora-7445 _inter_fast_memcpy.A()+10, 并有ora-7445 kgidmp 错误

Mon Feb  2 11:53:37 2009
Errors in file /home/oracle/app/oracle/admin/s3db/udump/s3db1_ora_16710.trc:
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Invalid permissions for mapped object] [0x2ACC11C92000] [] []
Mon Feb  2 11:53:37 2009
Errors in file /home/oracle/app/oracle/admin/s3db/udump/s3db1_ora_16710.trc:
ORA-07445: exception encountered: core dump [kgidmp()+743] [SIGSEGV] [Address not mapped to object] [0x00008002C] [] []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Invalid permissions for mapped object] [0x2ACC11C92000] [] []
Mon Feb  2 11:53:38 2009
Errors in file /home/oracle/app/oracle/admin/s3db/udump/s3db1_ora_16710.trc:
ORA-07445: exception encountered: core dump [kgidmp()+743] [SIGSEGV] [Address not mapped to object] [0x00008002C] [] []
ORA-07445: exception encountered: core dump [kgidmp()+743] [SIGSEGV] [Address not mapped to object] [0x00008002C] [] []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Invalid permissions for mapped object] [0x2ACC11C92000] [] []

跟踪文件显示:

Exception signal: 11 (SIGSEGV), code: 2 (Invalid permissions for mapped object), addr: 0x2acc11c92000, PC: [0x2acc0f936608, _intel_fast_memcpy.A()+10]
*** 2009-02-02 11:53:37.421
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Invalid permissions for mapped object] [0x2ACC11C92000] [] []
Current SQL statement for this session:
update SUBSCRIBERS set CHANNEL_HASH=:1, CHANNEL_HASH_TIMESTAMP =:2 WHERE ID=:3 and CHANNEL_HASH=:4
----- Call Stack Trace -----
calling              call     entry                argument values in hex
location             type     point                (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+31          call     ksedst1()            000000000 ? 000000001 ?
                                                   2ACC11614D50 ? 2ACC11614DB0 ?
                                                   2ACC11614CF0 ? 000000000 ?
ksedmp()+610         call     ksedst()             000000000 ? 000000001 ?
                                                   2ACC11614D50 ? 2ACC11614DB0 ?
                                                   2ACC11614CF0 ? 000000000 ?
ssexhd()+629         call     ksedmp()             000000003 ? 000000001 ?
                                                   2ACC11614D50 ? 2ACC11614DB0 ?
                                                   2ACC11614CF0 ? 000000000 ?
_L_mutex_unlock_15(  call     ssexhd()             00000000B ? 2ACC11615D70 ?
)+29                                               2ACC11615C40 ? 2ACC11614DB0 ?
                                                   2ACC11614CF0 ? 000000000 ?
_intel_fast_memcpy.  signal   _L_mutex_unlock_15(  2ACC11C91EF8 ? 2ACC11C92000 ?
A()+10                        )                    FFFFFFFFFFFFC108 ?
                                                   1FFFFFFFFFFB6C3D ?
                                                   000000040 ? 2ACC11A60C98 ?
upderh()+423         call     _intel_fast_memcpy.  2ACC11A4BFD8 ? 2ACC11C92000 ?
                              A()                  1FFFFFFFFFFB6C3D ?
                                                   1FFFFFFFFFFB6C3D ?
                                                   000000040 ? 2ACC11A60C98 ?
upduaw()+162         call     upderh()             2ACC11A4BFD8 ? 2ACC11C92000 ?
                                                   1FFFFFFFFFFB6C3D ?
                                                   1FFFFFFFFFFB6C3D ?
                                                   000000040 ? 2ACC11A60C98 ?
kdusru()+528         call     upduaw()             2ACC1194E388 ? 2ACC1194E4A0 ?
                                                   2ACC11A4D1E8 ? 090AA4EF0 ?
                                                   000000040 ? 2ACC11A60C98 ?
kauupd()+450         call     kdusru()             2ACC11A4BEE4 ? 090AA4E38 ?
                                                   2ACC11A4CF10 ? 000000000 ?
                                                   000000000 ? 2ACC11A60C98 ?
updrow()+1658        call     kauupd()             2ACC11A4BEE0 ? 090AA4E38 ?
                                                   2ACC11A4CF10 ? 000000000 ?
                                                   090AA73B0 ? 000000008 ?
qerupRowProcedure()  call     updrow()             090AA9D20 ? 000007FFF ?
+80                                                2ACC11A4CF10 ? 000000000 ?
                                                   090AA73B0 ? 000000008 ?
qerupFetch()+667     call     qerupRowProcedure()  090AA9D20 ? 000007FFF ?
                                                   2ACC11A4CF10 ? 000000000 ?
                                                   090AA73B0 ? 000000008 ?
updaul()+1065        call     qerupFetch()         000000008 ? 000000000 ?
                                                   090AA5C78 ? 000007FFF ?
                                                   090AA73B0 ? 090AA5EC0 ?
updThreePhaseExe()+  call     updaul()             090AA9D20 ? 7FFF9B18D160 ?
379                                                000000000 ? 2ACC1194E040 ?
                                                   090AA73B0 ? 090AA5EC0 ?
updexe()+600         call     updThreePhaseExe()   090AA9D20 ? 000000000 ?
                                                   2ACC11A4CF10 ? 7FFF9B18D280 ?
                                                   090AA73B0 ? 090AA5EC0 ?
opiexe()+4577        call     updexe()             090AA9D20 ? 000000000 ?
                                                   2ACC11A4CF10 ? 7FFF9B18D280 ?
                                                   000000000 ? 090AA5EC0 ?
kpoal8()+2273        call     opiexe()             000000049 ? 000000003 ?
                                                   7FFF9B18E510 ? 000000003 ?
                                                   000000000 ? 090AA5EC0 ?
opiodr()+984         call     kpoal8()             00000005E ? 000000017 ?
                                                   7FFF9B1913F0 ? 000000003 ?
                                                   000000001 ? 090AA5EC0 ?
ttcpip()+1012        call     opiodr()             00000005E ? 000000017 ?
                                                   7FFF9B1913F0 ? 000000000 ?
                                                   0059C0A30 ? 090AA5EC0 ?
opitsk()+1322        call     ttcpip()             00689E3B0 ? 7FFF9B18F2F8 ?
                                                   7FFF9B1913F0 ? 000000000 ?
                                                   7FFF9B190EE8 ? 7FFF9B191558 ?
opiino()+1026        call     opitsk()             000000003 ? 000000000 ?
                                                   7FFF9B1913F0 ? 000000001 ?
                                                   000000000 ? 4E5885500000001 ?
opiodr()+984         call     opiino()             00000003C ? 000000004 ?
                                                   7FFF9B1925B8 ? 000000000 ?
                                                   000000000 ? 4E5885500000001 ?
opidrv()+547         call     opiodr()             00000003C ? 000000004 ?
                                                   7FFF9B1925B8 ? 000000000 ?
                                                   0059C04E0 ? 4E5885500000001 ?
sou2o()+114          call     opidrv()             00000003C ? 000000004 ?
                                                   7FFF9B1925B8 ? 000000000 ?
                                                   0059C04E0 ? 4E5885500000001 ?
opimai_real()+163    call     sou2o()              7FFF9B192590 ? 00000003C ?
                                                   000000004 ? 7FFF9B1925B8 ?
                                                   0059C04E0 ? 4E5885500000001 ?
main()+116           call     opimai_real()        000000002 ? 7FFF9B192620 ?
                                                   000000004 ? 7FFF9B1925B8 ?
                                                   0059C04E0 ? 4E5885500000001 ?
__libc_start_main()  call     main()               000000002 ? 7FFF9B192620 ?
+244                                               000000004 ? 7FFF9B1925B8 ?
                                                   0059C04E0 ? 4E5885500000001 ?
_start()+41          call     __libc_start_main()  000723098 ? 000000002 ?
                                                   7FFF9B192778 ? 000000000 ?
                                                   0059C04E0 ? 000000002 ?

--------------------- Binary Stack Dump ---------------------
...

Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x8002c, PC: [0x408a2ff, kgidmp()+743]
*** 2009-02-02 11:53:37.846
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kgidmp()+743] [SIGSEGV] [Address not mapped to object] [0x00008002C] [] []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Invalid permissions for mapped object] [0x2ACC11C92000] [] []
Current SQL statement for this session:
update SUBSCRIBERS set CHANNEL_HASH=:1, CHANNEL_HASH_TIMESTAMP =:2 WHERE ID=:3 and CHANNEL_HASH=:4
----- Call Stack Trace -----
calling              call     entry                argument values in hex
location             type     point                (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+31          call     ksedst1()            000000000 ? 000000001 ?
                                                   2ACC11614250 ? 2ACC116142B0 ?
                                                   2ACC116141F0 ? 000000000 ?
ksedmp()+610         call     ksedst()             000000000 ? 000000001 ?
                                                   2ACC11614250 ? 2ACC116142B0 ?
                                                   2ACC116141F0 ? 000000000 ?
ssexhd()+559         call     ksedmp()             000000002 ? 000000001 ?
                                                   2ACC11614250 ? 2ACC116142B0 ?
                                                   2ACC116141F0 ? 000000000 ?
_L_mutex_unlock_15(  call     ssexhd()             00000000B ? 2ACC11615270 ?
)+29                                               2ACC11615140 ? 2ACC116142B0 ?
                                                   2ACC116141F0 ? 000000000 ?
kgidmp()+743         signal   _L_mutex_unlock_15(  000000005 ? 0055FC0D4 ?
                              )                    000000000 ? 000000000 ?
                                                   000000000 ? 000080004 ?
kgisdp()+122         call     kgidmp()             0068966E0 ? 2ACC11AEA708 ?
                                                   000000002 ? 0B4AFC358 ?
                                                   000000000 ? 000000001 ?
kgisdm()+11          call     kgisdp()             0068966E0 ? 0BF3D19B0 ?
                                                   000000000 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
ksudis()+109         call     kgisdm()             0068966E0 ? 0BF3D19B0 ?
                                                   000000000 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
ksudps()+787         call     ksudis()             0068966E0 ? 0BF3D19B0 ?
                                                   000000000 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
ksedmp()+1404        call     ksudps()             000000002 ? 0BF3D19B0 ?
                                                   000000000 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
ssexhd()+629         call     ksedmp()             000000003 ? 0BF3D19B0 ?
                                                   000000000 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
_L_mutex_unlock_15(  call     ssexhd()             00000000B ? 2ACC11615D70 ?
)+29                                               2ACC11615C40 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
_intel_fast_memcpy.  signal   _L_mutex_unlock_15(  2ACC11C91EF8 ? 2ACC11C92000 ?
A()+10                        )                    FFFFFFFFFFFFC108 ?
                                                   1FFFFFFFFFFB6C3D ?
                                                   000000040 ? 2ACC11A60C98 ?
upderh()+423         call     _intel_fast_memcpy.  2ACC11A4BFD8 ? 2ACC11C92000 ?
                              A()                  1FFFFFFFFFFB6C3D ?
                                                   1FFFFFFFFFFB6C3D ?
                                                   000000040 ? 2ACC11A60C98 ?
upduaw()+162         call     upderh()             2ACC11A4BFD8 ? 2ACC11C92000 ?
                                                   1FFFFFFFFFFB6C3D ?
                                                   1FFFFFFFFFFB6C3D ?
                                                   000000040 ? 2ACC11A60C98 ?
kdusru()+528         call     upduaw()             2ACC1194E388 ? 2ACC1194E4A0 ?
                                                   2ACC11A4D1E8 ? 090AA4EF0 ?
                                                   000000040 ? 2ACC11A60C98 ?
kauupd()+450         call     kdusru()             2ACC11A4BEE4 ? 090AA4E38 ?
                                                   2ACC11A4CF10 ? 000000000 ?
                                                   000000000 ? 2ACC11A60C98 ?
updrow()+1658        call     kauupd()             2ACC11A4BEE0 ? 090AA4E38 ?
                                                   2ACC11A4CF10 ? 000000000 ?
                                                   090AA73B0 ? 000000008 ?
qerupRowProcedure()  call     updrow()             090AA9D20 ? 000007FFF ?
+80                                                2ACC11A4CF10 ? 000000000 ?
                                                   090AA73B0 ? 000000008 ?
qerupFetch()+667     call     qerupRowProcedure()  090AA9D20 ? 000007FFF ?
                                                   2ACC11A4CF10 ? 000000000 ?
                                                   090AA73B0 ? 000000008 ?
updaul()+1065        call     qerupFetch()         000000008 ? 000000000 ?
                                                   090AA5C78 ? 000007FFF ?
                                                   090AA73B0 ? 090AA5EC0 ?
updThreePhaseExe()+  call     updaul()             090AA9D20 ? 7FFF9B18D160 ?
379                                                000000000 ? 2ACC1194E040 ?
                                                   090AA73B0 ? 090AA5EC0 ?
updexe()+600         call     updThreePhaseExe()   090AA9D20 ? 000000000 ?
                                                   2ACC11A4CF10 ? 7FFF9B18D280 ?
                                                   090AA73B0 ? 090AA5EC0 ?
opiexe()+4577        call     updexe()             090AA9D20 ? 000000000 ?
                                                   2ACC11A4CF10 ? 7FFF9B18D280 ?
                                                   000000000 ? 090AA5EC0 ?
kpoal8()+2273        call     opiexe()             000000049 ? 000000003 ?
                                                   7FFF9B18E510 ? 000000003 ?
                                                   000000000 ? 090AA5EC0 ?
opiodr()+984         call     kpoal8()             00000005E ? 000000017 ?
                                                   7FFF9B1913F0 ? 000000003 ?
                                                   000000001 ? 090AA5EC0 ?
ttcpip()+1012        call     opiodr()             00000005E ? 000000017 ?
                                                   7FFF9B1913F0 ? 000000000 ?
                                                   0059C0A30 ? 090AA5EC0 ?
opitsk()+1322        call     ttcpip()             00689E3B0 ? 7FFF9B18F2F8 ?
                                                   7FFF9B1913F0 ? 000000000 ?
                                                   7FFF9B190EE8 ? 7FFF9B191558 ?
opiino()+1026        call     opitsk()             000000003 ? 000000000 ?
                                                   7FFF9B1913F0 ? 000000001 ?
                                                   000000000 ? 4E5885500000001 ?
opiodr()+984         call     opiino()             00000003C ? 000000004 ?
                                                   7FFF9B1925B8 ? 000000000 ?
                                                   000000000 ? 4E5885500000001 ?
opidrv()+547         call     opiodr()             00000003C ? 000000004 ?
                                                   7FFF9B1925B8 ? 000000000 ?
                                                   0059C04E0 ? 4E5885500000001 ?
sou2o()+114          call     opidrv()             00000003C ? 000000004 ?
                                                   7FFF9B1925B8 ? 000000000 ?
                                                   0059C04E0 ? 4E5885500000001 ?
opimai_real()+163    call     sou2o()              7FFF9B192590 ? 00000003C ?
                                                   000000004 ? 7FFF9B1925B8 ?
                                                   0059C04E0 ? 4E5885500000001 ?
main()+116           call     opimai_real()        000000002 ? 7FFF9B192620 ?
                                                   000000004 ? 7FFF9B1925B8 ?
                                                   0059C04E0 ? 4E5885500000001 ?
__libc_start_main()  call     main()               000000002 ? 7FFF9B192620 ?
+244                                               000000004 ? 7FFF9B1925B8 ?
                                                   0059C04E0 ? 4E5885500000001 ?
_start()+41          call     __libc_start_main()  000723098 ? 000000002 ?
                                                   7FFF9B192778 ? 000000000 ?
                                                   0059C04E0 ? 000000002 ?

--------------------- Binary Stack Dump ---------------------
...

Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x8002c, PC: [0x408a2ff, kgidmp()+743]
*** 2009-02-02 11:53:38.373
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kgidmp()+743] [SIGSEGV] [Address not mapped to object] [0x00008002C] [] []
ORA-07445: exception encountered: core dump [kgidmp()+743] [SIGSEGV] [Address not mapped to object] [0x00008002C] [] []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Invalid permissions for mapped object] [0x2ACC11C92000] [] []
Current SQL statement for this session:
update SUBSCRIBERS set CHANNEL_HASH=:1, CHANNEL_HASH_TIMESTAMP =:2 WHERE ID=:3 and CHANNEL_HASH=:4
----- Call Stack Trace -----
calling              call     entry                argument values in hex
location             type     point                (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+31          call     ksedst1()            000000000 ? 000000001 ?
                                                   2ACC11613750 ? 2ACC116137B0 ?
                                                   2ACC116136F0 ? 000000000 ?
ksedmp()+610         call     ksedst()             000000000 ? 000000001 ?
                                                   2ACC11613750 ? 2ACC116137B0 ?
                                                   2ACC116136F0 ? 000000000 ?
ssexhd()+578         call     ksedmp()             000000001 ? 000000001 ?
                                                   2ACC11613750 ? 2ACC116137B0 ?
                                                   2ACC116136F0 ? 000000000 ?
_L_mutex_unlock_15(  call     ssexhd()             00000000B ? 2ACC11614770 ?
)+29                                               2ACC11614640 ? 2ACC116137B0 ?
                                                   2ACC116136F0 ? 000000000 ?
kgidmp()+743         signal   _L_mutex_unlock_15(  000000005 ? 0055FC0D4 ?
                              )                    000000000 ? 000000000 ?
                                                   000000000 ? 000080004 ?
kgisdp()+122         call     kgidmp()             0068966E0 ? 2ACC11AEA708 ?
                                                   000000002 ? 0B4AFC358 ?
                                                   000000000 ? 000000001 ?
kgisdm()+11          call     kgisdp()             0068966E0 ? 0BF3D19B0 ?
                                                   000000000 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
ksudis()+109         call     kgisdm()             0068966E0 ? 0BF3D19B0 ?
                                                   000000000 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
ksudps()+787         call     ksudis()             0068966E0 ? 0BF3D19B0 ?
                                                   000000000 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
ksedmp()+1404        call     ksudps()             000000002 ? 0BF3D19B0 ?
                                                   000000000 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
ssexhd()+559         call     ksedmp()             000000002 ? 0BF3D19B0 ?
                                                   000000000 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
_L_mutex_unlock_15(  call     ssexhd()             00000000B ? 2ACC11615270 ?
)+29                                               2ACC11615140 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
kgidmp()+743         signal   _L_mutex_unlock_15(  000000005 ? 0055FC0D4 ?
                              )                    000000000 ? 000000000 ?
                                                   000000000 ? 000080004 ?
kgisdp()+122         call     kgidmp()             0068966E0 ? 2ACC11AEA708 ?
                                                   000000002 ? 0B4AFC358 ?
                                                   000000000 ? 000000001 ?
kgisdm()+11          call     kgisdp()             0068966E0 ? 0BF3D19B0 ?
                                                   000000000 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
ksudis()+109         call     kgisdm()             0068966E0 ? 0BF3D19B0 ?
                                                   000000000 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
ksudps()+787         call     ksudis()             0068966E0 ? 0BF3D19B0 ?
                                                   000000000 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
ksedmp()+1404        call     ksudps()             000000002 ? 0BF3D19B0 ?
                                                   000000000 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
ssexhd()+629         call     ksedmp()             000000003 ? 0BF3D19B0 ?
                                                   000000000 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
_L_mutex_unlock_15(  call     ssexhd()             00000000B ? 2ACC11615D70 ?
)+29                                               2ACC11615C40 ? 2ACC11AEA708 ?
                                                   000000000 ? 000000001 ?
_intel_fast_memcpy.  signal   _L_mutex_unlock_15(  2ACC11C91EF8 ? 2ACC11C92000 ?
A()+10                        )                    FFFFFFFFFFFFC108 ?
                                                   1FFFFFFFFFFB6C3D ?
                                                   000000040 ? 2ACC11A60C98 ?
upderh()+423         call     _intel_fast_memcpy.  2ACC11A4BFD8 ? 2ACC11C92000 ?
                              A()                  1FFFFFFFFFFB6C3D ?
                                                   1FFFFFFFFFFB6C3D ?
                                                   000000040 ? 2ACC11A60C98 ?
upduaw()+162         call     upderh()             2ACC11A4BFD8 ? 2ACC11C92000 ?
                                                   1FFFFFFFFFFB6C3D ?
                                                   1FFFFFFFFFFB6C3D ?
                                                   000000040 ? 2ACC11A60C98 ?
kdusru()+528         call     upduaw()             2ACC1194E388 ? 2ACC1194E4A0 ?
                                                   2ACC11A4D1E8 ? 090AA4EF0 ?
                                                   000000040 ? 2ACC11A60C98 ?
kauupd()+450         call     kdusru()             2ACC11A4BEE4 ? 090AA4E38 ?
                                                   2ACC11A4CF10 ? 000000000 ?
                                                   000000000 ? 2ACC11A60C98 ?
updrow()+1658        call     kauupd()             2ACC11A4BEE0 ? 090AA4E38 ?
                                                   2ACC11A4CF10 ? 000000000 ?
                                                   090AA73B0 ? 000000008 ?
qerupRowProcedure()  call     updrow()             090AA9D20 ? 000007FFF ?
+80                                                2ACC11A4CF10 ? 000000000 ?
                                                   090AA73B0 ? 000000008 ?
qerupFetch()+667     call     qerupRowProcedure()  090AA9D20 ? 000007FFF ?
                                                   2ACC11A4CF10 ? 000000000 ?
                                                   090AA73B0 ? 000000008 ?
updaul()+1065        call     qerupFetch()         000000008 ? 000000000 ?
                                                   090AA5C78 ? 000007FFF ?
                                                   090AA73B0 ? 090AA5EC0 ?
updThreePhaseExe()+  call     updaul()             090AA9D20 ? 7FFF9B18D160 ?
379                                                000000000 ? 2ACC1194E040 ?
                                                   090AA73B0 ? 090AA5EC0 ?
updexe()+600         call     updThreePhaseExe()   090AA9D20 ? 000000000 ?
                                                   2ACC11A4CF10 ? 7FFF9B18D280 ?
                                                   090AA73B0 ? 090AA5EC0 ?
opiexe()+4577        call     updexe()             090AA9D20 ? 000000000 ?
                                                   2ACC11A4CF10 ? 7FFF9B18D280 ?
                                                   000000000 ? 090AA5EC0 ?
kpoal8()+2273        call     opiexe()             000000049 ? 000000003 ?
                                                   7FFF9B18E510 ? 000000003 ?
                                                   000000000 ? 090AA5EC0 ?
opiodr()+984         call     kpoal8()             00000005E ? 000000017 ?
                                                   7FFF9B1913F0 ? 000000003 ?
                                                   000000001 ? 090AA5EC0 ?
ttcpip()+1012        call     opiodr()             00000005E ? 000000017 ?
                                                   7FFF9B1913F0 ? 000000000 ?
                                                   0059C0A30 ? 090AA5EC0 ?
opitsk()+1322        call     ttcpip()             00689E3B0 ? 7FFF9B18F2F8 ?
                                                   7FFF9B1913F0 ? 000000000 ?
                                                   7FFF9B190EE8 ? 7FFF9B191558 ?
opiino()+1026        call     opitsk()             000000003 ? 000000000 ?
                                                   7FFF9B1913F0 ? 000000001 ?
                                                   000000000 ? 4E5885500000001 ?
opiodr()+984         call     opiino()             00000003C ? 000000004 ?
                                                   7FFF9B1925B8 ? 000000000 ?
                                                   000000000 ? 4E5885500000001 ?
opidrv()+547         call     opiodr()             00000003C ? 000000004 ?
                                                   7FFF9B1925B8 ? 000000000 ?
                                                   0059C04E0 ? 4E5885500000001 ?
sou2o()+114          call     opidrv()             00000003C ? 000000004 ?
                                                   7FFF9B1925B8 ? 000000000 ?
                                                   0059C04E0 ? 4E5885500000001 ?
opimai_real()+163    call     sou2o()              7FFF9B192590 ? 00000003C ?
                                                   000000004 ? 7FFF9B1925B8 ?
                                                   0059C04E0 ? 4E5885500000001 ?
main()+116           call     opimai_real()        000000002 ? 7FFF9B192620 ?
                                                   000000004 ? 7FFF9B1925B8 ?
                                                   0059C04E0 ? 4E5885500000001 ?
__libc_start_main()  call     main()               000000002 ? 7FFF9B192620 ?
+244                                               000000004 ? 7FFF9B1925B8 ?
                                                   0059C04E0 ? 4E5885500000001 ?
_start()+41          call     __libc_start_main()  000723098 ? 000000002 ?
                                                   7FFF9B192778 ? 000000000 ?
                                                   0059C04E0 ? 000000002 ?

--------------------- Binary Stack Dump ---------------------
...

还有一种, 报有ora-600 kgh_heap_sizes:ds 的错

Mon Dec 22 14:21:41 2008
Errors in file /home/oracle/app/oracle/admin/s3db/udump/s3db2_ora_13467.trc:
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not mapped to object] [0x2B83A26E1000] [] []
Mon Dec 22 14:21:41 2008
Errors in file /home/oracle/app/oracle/admin/s3db/udump/s3db2_ora_13467.trc:
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DDBE8], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not mapped to object] [0x2B83A26E1000] [] []
Mon Dec 22 14:21:42 2008
Errors in file /home/oracle/app/oracle/admin/s3db/udump/s3db2_ora_13467.trc:
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DDBE8], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not mapped to object] [0x2B83A26E1000] [] []
Mon Dec 22 14:21:43 2008
Errors in file /home/oracle/app/oracle/admin/s3db/udump/s3db2_ora_13467.trc:
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DDBE8], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not mapped to object] [0x2B83A26E1000] [] []
Mon Dec 22 14:21:44 2008
Errors in file /home/oracle/app/oracle/admin/s3db/udump/s3db2_ora_13467.trc:
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DDBE8], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not mapped to object] [0x2B83A26E1000] [] []
Mon Dec 22 14:21:45 2008
Errors in file /home/oracle/app/oracle/admin/s3db/udump/s3db2_ora_13467.trc:
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DDBE8], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not mapped to object] [0x2B83A26E1000] [] []
Mon Dec 22 14:21:46 2008
Errors in file /home/oracle/app/oracle/admin/s3db/udump/s3db2_ora_13467.trc:
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DDBE8], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not mapped to object] [0x2B83A26E1000] [] []
Mon Dec 22 14:21:48 2008
Errors in file /home/oracle/app/oracle/admin/s3db/udump/s3db2_ora_13467.trc:
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DDBE8], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not mapped to object] [0x2B83A26E1000] [] []
Mon Dec 22 14:21:49 2008
Errors in file /home/oracle/app/oracle/admin/s3db/udump/s3db2_ora_13467.trc:
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DDBE8], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not mapped to object] [0x2B83A26E1000] [] []

跟踪文件显示:

*** 2008-12-22 14:21:42.309
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DD0E8], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kgh_heap_sizes:ds], [0x2B83A26DDBE8], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not mapped to object] [0x2B83A26E1000] [] []
Current SQL statement for this session:
update SUBSCRIBERS set CHANNEL_HASH=:1, CHANNEL_HASH_TIMESTAMP =:2 WHERE ID=:3 and CHANNEL_HASH=:4
----- Call Stack Trace -----
calling              call     entry                argument values in hex
location             type     point                (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+31          call     ksedst1()            000000000 ? 000000001 ?
                                                   2B83A25EB150 ? 2B83A25EB1B0 ?
                                                   2B83A25EB0F0 ? 000000000 ?
ksedmp()+610         call     ksedst()             000000000 ? 000000001 ?
                                                   2B83A25EB150 ? 2B83A25EB1B0 ?
                                                   2B83A25EB0F0 ? 000000000 ?
ksfdmp()+21          call     ksedmp()             000000003 ? 000000001 ?
                                                   2B83A25EB150 ? 2B83A25EB1B0 ?
                                                   2B83A25EB0F0 ? 000000000 ?
kgerinv()+161        call     ksfdmp()             000000003 ? 000000001 ?
                                                   2B83A25EB150 ? 2B83A25EB1B0 ?
                                                   2B83A25EB0F0 ? 000000000 ?
kgesinv()+33         call     kgerinv()            0068966E0 ? 00AAB9CC0 ?
                                                   2B83A25EB1B0 ? 2B83A25EB0F0 ?
                                                   000000000 ? 000000000 ?
kgesin()+143         call     kgesinv()            0068966E0 ? 00AAB9CC0 ?
                                                   2B83A25EB1B0 ? 2B83A25EB0F0 ?
                                                   000000000 ? 000000000 ?
kghnerror()+342      call     kgesin()             0068966E0 ? 00AAB9CC0 ?
                                                   2B83A25EB1B0 ? 2B83A25EB0F0 ?
                                                   000000002 ? 2B83A26DD0E8 ?
kgh_heap_sizes()+11  call     kghnerror()          0068966E0 ? 2B83A26AA128 ?
58                                                 005AE1EE8 ? 2B83A26DD0E8 ?
                                                   000000002 ? 2B83A26DD0E8 ?
kxsDump1()+1209      call     kgh_heap_sizes()     000000002 ? 2B83A26AA128 ?
                                                   2B83A25EC050 ? 000000001 ?
                                                   2B8300000001 ? 000000002 ?
kxsDump()+538        call     kxsDump1()           2B83A26C1420 ? 000000071 ?
                                                   2B83A25EC050 ? 000000001 ?
                                                   2B8300000001 ? 000000002 ?
kxsDumpCursor()+165  call     kxsDump()            2B83A26C1420 ? 000000071 ?
                                                   006896860 ? 000000001 ?
                                                   2B8300000001 ? 000000002 ?
kxsDumpCursors()+12  call     kxsDumpCursor()      2B83A26A1BF0 ? 000000071 ?
05                                                 006896860 ? 000000001 ?
                                                   2B8300000001 ? 000000002 ?
curdmp()+19          call     kxsDumpCursors()     000000071 ? 000000001 ?
                                                   006896860 ? 000000001 ?
                                                   2B83A269E5C8 ? 0A0000000 ?
ksudps()+794         call     curdmp()             000000071 ? 000000001 ?
                                                   006896860 ? 000000001 ?
                                                   2B83A269E5C8 ? 0A0000000 ?
ksedmp()+1404        call     ksudps()             000000002 ? 000000001 ?
                                                   006896860 ? 000000001 ?
                                                   2B83A269E5C8 ? 0A0000000 ?
ksfdmp()+21          call     ksedmp()             000000003 ? 000000001 ?
                                                   006896860 ? 000000001 ?
                                                   2B83A269E5C8 ? 0A0000000 ?
kgerinv()+161        call     ksfdmp()             000000003 ? 000000001 ?
                                                   006896860 ? 000000001 ?
                                                   2B83A269E5C8 ? 0A0000000 ?
kgesinv()+33         call     kgerinv()            0068966E0 ? 00AAB9CC0 ?
                                                   000000001 ? 2B83A269E5C8 ?
                                                   0A0000000 ? 0A0000000 ?
kgesin()+143         call     kgesinv()            0068966E0 ? 00AAB9CC0 ?
                                                   000000001 ? 2B83A269E5C8 ?
                                                   0A0000000 ? 0A0000000 ?
kghnerror()+342      call     kgesin()             0068966E0 ? 00AAB9CC0 ?
                                                   000000001 ? 2B83A269E5C8 ?
                                                   000000002 ? 2B83A26DDBE8 ?
kgh_heap_sizes()+11  call     kghnerror()          0068966E0 ? 2B83A26B0978 ?
58                                                 005AE1EE8 ? 2B83A26DDBE8 ?
                                                   000000002 ? 2B83A26DDBE8 ?
kxsDump1()+1381      call     kgh_heap_sizes()     000000002 ? 2B83A26B0978 ?
                                                   2B83A25ECE50 ? 000000001 ?
                                                   2B8300000001 ? 000000002 ?
kxsDump()+538        call     kxsDump1()           2B83A26D7060 ? 000000071 ?
                                                   2B83A25ECE50 ? 000000001 ?
                                                   2B8300000001 ? 000000002 ?
kxsDumpCursor()+165  call     kxsDump()            2B83A26D7060 ? 000000071 ?
                                                   006896860 ? 000000001 ?
                                                   2B8300000001 ? 000000002 ?
kxsDumpCursors()+12  call     kxsDumpCursor()      2B83A26A1F30 ? 000000071 ?
05                                                 006896860 ? 000000001 ?
                                                   2B8300000001 ? 000000002 ?
curdmp()+19          call     kxsDumpCursors()     000000071 ? 000000001 ?
                                                   006896860 ? 000000001 ?
                                                   2B83A269E5C8 ? 000000000 ?
ksudps()+794         call     curdmp()             000000071 ? 000000001 ?
                                                   006896860 ? 000000001 ?
                                                   2B83A269E5C8 ? 000000000 ?
ksedmp()+1404        call     ksudps()             000000002 ? 000000001 ?
                                                   006896860 ? 000000001 ?
                                                   2B83A269E5C8 ? 000000000 ?
ssexhd()+629         call     ksedmp()             000000003 ? 000000001 ?
                                                   006896860 ? 000000001 ?
                                                   2B83A269E5C8 ? 000000000 ?
_L_mutex_unlock_15(  call     ssexhd()             00000000B ? 2B83A25EDD70 ?
)+29                                               2B83A25EDC40 ? 000000001 ?
                                                   2B83A269E5C8 ? 000000000 ?
_intel_fast_memcpy.  signal   _L_mutex_unlock_15(  2B83A26E0EF8 ? 2B83A26E1000 ?
A()+10                        )                    FFFFFFFFFFFFCAC9 ?
                                                   1FFFFFFFFFFFEB7B ?
                                                   000000040 ? 2B83A29224C8 ?
upderh()+423         call     _intel_fast_memcpy.  2B83A26DA008 ? 2B83A26E1000 ?
                              A()                  1FFFFFFFFFFFEB7B ?
                                                   1FFFFFFFFFFFEB7B ?
                                                   000000040 ? 2B83A29224C8 ?
upduaw()+162         call     upderh()             2B83A26DA008 ? 2B83A26E1000 ?
                                                   1FFFFFFFFFFFEB7B ?
                                                   1FFFFFFFFFFFEB7B ?
                                                   000000040 ? 2B83A29224C8 ?
kdusru()+528         call     upduaw()             2B83A26B6FE0 ? 2B83A26B70F8 ?
                                                   2B83A26BAF50 ? 0AEB67530 ?
                                                   000000040 ? 2B83A29224C8 ?
kauupd()+450         call     kdusru()             2B83A26D9F14 ? 0AEB67478 ?
                                                   2B83A26BAC78 ? 000000000 ?
                                                   000000000 ? 2B83A29224C8 ?
updrow()+1658        call     kauupd()             2B83A26D9F10 ? 0AEB67478 ?
                                                   2B83A26BAC78 ? 000000000 ?
                                                   0AD84BA18 ? 000000008 ?
qerupRowProcedure()  call     updrow()             0B2108F80 ? 000007FFF ?
+80                                                2B83A26BAC78 ? 000000000 ?
                                                   0AD84BA18 ? 000000008 ?
qerupFetch()+667     call     qerupRowProcedure()  0B2108F80 ? 000007FFF ?
                                                   2B83A26BAC78 ? 000000000 ?
                                                   0AD84BA18 ? 000000008 ?
updaul()+1065        call     qerupFetch()         000000008 ? 000000000 ?
                                                   0AEB682C0 ? 000007FFF ?
                                                   0AD84BA18 ? 0AEB68500 ?
updThreePhaseExe()+  call     updaul()             0B2108F80 ? 7FFF0A1B3180 ?
379                                                000000000 ? 2B83A26B6C98 ?
                                                   0AD84BA18 ? 0AEB68500 ?
updexe()+600         call     updThreePhaseExe()   0B2108F80 ? 000000000 ?
                                                   2B83A26BAC78 ? 7FFF0A1B32A0 ?
                                                   0AD84BA18 ? 0AEB68500 ?
opiexe()+4577        call     updexe()             0B2108F80 ? 000000000 ?
                                                   2B83A26BAC78 ? 7FFF0A1B32A0 ?
                                                   000000000 ? 0AEB68500 ?
kpoal8()+2273        call     opiexe()             000000049 ? 000000003 ?
                                                   7FFF0A1B4530 ? 000000007 ?
                                                   000000000 ? 0AEB68500 ?
opiodr()+984         call     kpoal8()             00000005E ? 000000017 ?
                                                   7FFF0A1B7410 ? 000000007 ?
                                                   000000001 ? 0AEB68500 ?
ttcpip()+1012        call     opiodr()             00000005E ? 000000017 ?
                                                   7FFF0A1B7410 ? 000000000 ?
                                                   0059C0A30 ? 0AEB68500 ?
opitsk()+1322        call     ttcpip()             00689E3B0 ? 7FFF0A1B5318 ?
                                                   7FFF0A1B7410 ? 000000000 ?
                                                   7FFF0A1B6F08 ? 7FFF0A1B7578 ?
opiino()+1026        call     opitsk()             000000003 ? 000000000 ?
                                                   7FFF0A1B7410 ? 000000001 ?
                                                   000000000 ? 4E5345200000001 ?
opiodr()+984         call     opiino()             00000003C ? 000000004 ?
                                                   7FFF0A1B85D8 ? 000000000 ?
                                                   000000000 ? 4E5345200000001 ?
opidrv()+547         call     opiodr()             00000003C ? 000000004 ?
                                                   7FFF0A1B85D8 ? 000000000 ?
                                                   0059C04E0 ? 4E5345200000001 ?
sou2o()+114          call     opidrv()             00000003C ? 000000004 ?
                                                   7FFF0A1B85D8 ? 000000000 ?
                                                   0059C04E0 ? 4E5345200000001 ?
opimai_real()+163    call     sou2o()              7FFF0A1B85B0 ? 00000003C ?
                                                   000000004 ? 7FFF0A1B85D8 ?
                                                   0059C04E0 ? 4E5345200000001 ?
main()+116           call     opimai_real()        000000002 ? 7FFF0A1B8640 ?
                                                   000000004 ? 7FFF0A1B85D8 ?
                                                   0059C04E0 ? 4E5345200000001 ?
__libc_start_main()  call     main()               000000002 ? 7FFF0A1B8640 ?
+244                                               000000004 ? 7FFF0A1B85D8 ?
                                                   0059C04E0 ? 4E5345200000001 ?
_start()+41          call     __libc_start_main()  000723098 ? 000000002 ?
                                                   7FFF0A1B8798 ? 000000000 ?
                                                   0059C04E0 ? 000000002 ?

--------------------- Binary Stack Dump ---------------------
...

经查询, 好像是这个BUG, Bug 7138239 - ORA-07445[_INTEL_FAST_MEMCPY.A()+10] FOR UPDATE

Details:
There is a problem with the fix from bug 4549673 which is included in 9.2.0.8 and 10.2.0.4 in that with that fix it is possible to get a dump under updgrh and/or private memory corruption. This issue can also cause malformed RCI information in the redo stream causing problems for log miner and Streams.
eg:
Corruption / dumps can occur when updating a migrated row where one of the columns is to be updated to NULL and an internal 1551 error occurs during the DML.(1551 errors are not visible to customers and are caught and handled internally)

Ora-07445 [INTEL_FAST_MEMCPY] Dump Under Updgrh From Update Statement

Bug 5868257 - Dump / memory corruption from UPDATE DML

Solution
To resolve this issue, you may choose any of these options:
1. Apply the 11.1.0.6 patchset which includes the bug fix.
2. Check for the availability of Patch 5868257 on MetaLink corresponding to your platform and database version.
3. If no patch is available, request a patch by creating a service request with Oracle Support.

打补丁 Patch 5868257 MALFORMED RCI MARKER REDO DUE TO ORA-1551 IN UPDATE DRIVER
或打最新的建议补丁集 10.2.0.4 GENERIC RECOMMENDED BUNDLE# 3., 包含了上面的5868257

也可能不是这个BUG，不管它了

-fin-

Sunday, January 25, 2009

ORA-600 kdsgrp1

ORA-600 kdsgrp1

修复数据库后, 告警日志报错

Errors in file /home/oracle/app/oracle/admin/s10/udump/s10_ora_23209.trc:
ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], []

跟踪文件显示:

*** SESSION ID:(1620.1) 2009-01-25 02:21:07.036
row 0281ec7f.4a continuation at
file# 10 block# 126079 slot 75 not found
**************************************************
KDSTABN_GET: 0 ..... ntab: 1
curSlot: 75 ..... nrows: 74
**************************************************
*** 2009-01-25 02:21:07.043
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], []
Current SQL statement for this session:
SELECT ID, LOCAL_UID, BYTES_ID, CHECKSUM, MIME_TYPE, PHYSICAL_CONTENT_ID, ASSET_TYPE, SOURCE_URL FROM ASSET WHERE LOCAL_UID =
(SELECT LOCAL_UID FROM DP_FEED_IMAGE WHERE FEED_IMAGE_ID=:1 AND SOURCE_URL IS NOT NULL)
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+31 call ksedst1() 000000000 ? 000000001 ?
7FFF96BEC710 ? 7FFF96BEC770 ?
7FFF96BEC6B0 ? 000000000 ?
ksedmp()+610 call ksedst() 000000000 ? 000000001 ?
7FFF96BEC710 ? 7FFF96BEC770 ?
7FFF96BEC6B0 ? 000000000 ?
ksfdmp()+21 call ksedmp() 000000003 ? 000000001 ?
7FFF96BEC710 ? 7FFF96BEC770 ?
7FFF96BEC6B0 ? 000000000 ?
kgerinv()+161 call ksfdmp() 000000003 ? 000000001 ?
7FFF96BEC710 ? 7FFF96BEC770 ?
7FFF96BEC6B0 ? 000000000 ?
kgeasnmierr()+163 call kgerinv() 006217D40 ? 01B5B28B0 ?
7FFF96BEC770 ? 7FFF96BEC6B0 ?
000000000 ? 000000000 ?
kdsgrp()+764 call kgeasnmierr() 006217D40 ? 01B5B28B0 ?
7FFF96BEC770 ? 7FFF96BEC6B0 ?
000000000 ? 000000001 ?
kdsfbr()+228 call kdsgrp() 000000000 ? 000000000 ?
2B2815CA49B0 ? 7FFF96BEC6B0 ?
000000000 ? 000000001 ?
qertbFetchByRowID() call kdsfbr() 2B2815CA49B0 ? 00000004B ?
+895 000000000 ? 000000001 ?
000000000 ? 0000000FD ?
subsr1()+515 call qertbFetchByRowID() 066C88320 ? 000000000 ?
000000000 ? 000000001 ?
000000000 ? 0000000FD ?
evaopn2()+4067 call subsr1() 066C88010 ? 000000000 ?
000000000 ? 000000001 ?
000000000 ? 0000000FD ?
qerixTunnelGetKey() call evaopn2() 066C87F20 ? 2B2815CA4BB8 ?
+1030 000000000 ? 000000001 ?
2B2815CBF9C0 ? 0000000FD ?
qerixStart()+1293 call qerixTunnelGetKey() 066C87F20 ? 2B2815CA4BB8 ?
000000000 ? 000000001 ?
2B2815CBF9C0 ? 066C87F20 ?
qertbStart()+956 call qerixStart() 066C87AA0 ? 2B2815CA4BB8 ?
2B2815CAF000 ? 000000001 ?
2B2815CBF9C0 ? 066C87F20 ?
selexe()+667 call qertbStart() 066C878A8 ? 000000001 ?
2B2815CAF000 ? 2B2815CAF468 ?
000000000 ? 066C87F20 ?
opiexe()+4671 call selexe() 066C8BE28 ? 7FFF96BEEBA8 ?
7FFF96BEEBA8 ? 066C8BE28 ?
000000000 ? 066C87F20 ?
kpoal8()+2273 call opiexe() 000000049 ? 000000003 ?
7FFF96BEF070 ? 00000000E ?
000000000 ? 066C87F20 ?
opiodr()+984 call kpoal8() 00000005E ? 000000017 ?
7FFF96BF1F50 ? 00000000E ?
000000001 ? 066C87F20 ?
ttcpip()+1012 call opiodr() 00000005E ? 000000017 ?
7FFF96BF1F50 ? 00000000E ?
005444950 ? 066C87F20 ?
opitsk()+1322 call ttcpip() 00621FA10 ? 7FFF96BEFF38 ?
7FFF96BF1F50 ? 000000000 ?
7FFF96BF1A48 ? 7FFF96BF20B8 ?
opiino()+1026 call opitsk() 000000003 ? 000000000 ?
7FFF96BF1F50 ? 000000001 ?
000000000 ? 48E082200000001 ?
opiodr()+984 call opiino() 00000003C ? 000000004 ?
7FFF96BF3118 ? 000000000 ?
000000000 ? 48E082200000001 ?
opidrv()+547 call opiodr() 00000003C ? 000000004 ?
7FFF96BF3118 ? 000000000 ?
005444400 ? 48E082200000001 ?
sou2o()+114 call opidrv() 00000003C ? 000000004 ?
7FFF96BF3118 ? 000000000 ?
005444400 ? 48E082200000001 ?
opimai_real()+163 call sou2o() 7FFF96BF30F0 ? 00000003C ?
000000004 ? 7FFF96BF3118 ?
005444400 ? 48E082200000001 ?
main()+116 call opimai_real() 000000002 ? 7FFF96BF3180 ?
000000004 ? 7FFF96BF3118 ?
005444400 ? 48E082200000001 ?
__libc_start_main() call main() 000000002 ? 7FFF96BF3180 ?
+244 000000004 ? 7FFF96BF3118 ?
005444400 ? 48E082200000001 ?
_start()+41 call __libc_start_main() 0006E8898 ? 000000002 ?
7FFF96BF32D8 ? 000000000 ?
005444400 ? 000000002 ?

--------------------- Binary Stack Dump ---------------------
...

可能是因为表和索引数据不一致造成的

检验表结构
set time on timing on
analyze table s3test.asset validate structure cascade;
analyze table s3test.dp_feed_image validate structure cascade;

12:22:38 SQL> set time on timing on
12:22:44 SQL> analyze table s3test.asset validate structure cascade;

Table analyzed.

Elapsed: 00:16:52.28
12:39:37 SQL>
13:00:57 SQL> analyze table s3test.dp_feed_image validate structure cascade;
analyze table s3test.dp_feed_image validate structure cascade
*
ERROR at line 1:
ORA-01499: table/index cross reference failure - see trace file

Elapsed: 00:05:44.41
13:09:11 SQL>

跟踪文件显示

Table/Index row count mismatch
table 1022161 : index 1022167, 0
Index root = tsn: 11 rdba: 0x02c0dd0c

查询是哪个索引坏了
col segment_name for a30
select owner, segment_name, segment_type
from dba_segments
where header_file = dbms_utility.data_block_address_file(to_number('02c0dd0c','xxxxxxxxx'))
and header_block = dbms_utility.data_block_address_block(to_number('02c0dd0c','xxxxxxxxx'));

SQL> col segment_name for a30
SQL> select owner, segment_name, segment_type
from dba_segments
where header_file = dbms_utility.data_block_address_file(to_number('02c0dd0c','xxxxxxxxx'))
and header_block = dbms_utility.data_block_address_block(to_number('02c0dd0c','xxxxxxxxx'));
2 3 4
OWNER SEGMENT_NAME SEGMENT_TYPE
------------------------------ ------------------------------ ------------------
S3TEST DP_FC_LOCAL_UID INDEX

SQL>

重建索引
set time on timing on
alter index s3test.dp_fc_local_uid rebuild online;

SQL> set time on timing on
13:35:45 SQL> alter index s3test.dp_fc_local_uid rebuild online;

Index altered.

Elapsed: 00:00:18.17
13:36:07 SQL>

问题解决
analyze table s3test.dp_feed_image validate structure cascade;

13:36:23 SQL> analyze table s3test.dp_feed_image validate structure cascade;

Table analyzed.

Elapsed: 00:06:50.82
13:43:15 SQL>

外部链接:
ORA-600 [kdsgrp1]
ORA-1499. Table/Index row count mismatch

-fin-

谢太数据库

谢太的最爱

Blog Archive

Thursday, September 3, 2009

no login prompt in vm console

Friday, July 24, 2009

agent status shows negative available disk space

Tuesday, May 12, 2009

unable to specify GMT timezone in kickstart in centos 5.3

Friday, February 27, 2009

sqlplus hangs on infinite calling times(null)

Friday, February 13, 2009

ora-7445 drexumcx

Tuesday, February 10, 2009

ORA-12899 with update trigger

Single resource deadlock with a zero DID

Thursday, February 5, 2009

ora-7445 _intel_fast_memcpy

Sunday, January 25, 2009

ORA-600 kdsgrp1

Followers

订阅谢太数据库

谢太的最爱

Blog Archive

Thursday, September 3, 2009

Friday, July 24, 2009

Tuesday, May 12, 2009

Friday, February 27, 2009

Friday, February 13, 2009

Tuesday, February 10, 2009

Thursday, February 5, 2009

Sunday, January 25, 2009

Followers