- 最后登录
- 2017-5-31
- 在线时间
- 156 小时
- 威望
- 60
- 金钱
- 1885
- 注册时间
- 2011-12-16
- 阅读权限
- 50
- 帖子
- 75
- 精华
- 0
- 积分
- 60
- UID
- 113
|
2#
发表于 2014-8-28 16:05:34
[root@xxxxx~]# vi /usr/oracle/app/oracle/diag/rdbms/xxxxx/xxxxx1/trace/xxxxx1_ora_23336.trc
Trace file /usr/oracle/app/oracle/diag/rdbms/xxxxx/xxxxx1/trace/xxxxx1_ora_23336.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORACLE_HOME = /usr/oracle/app/oracle/product/11.2.0/db_2
System name: Linux
Node name: gtaq11
Release: 2.6.32-431.el6.x86_64
Version: #1 SMP Sun Nov 10 22:19:54 EST 2013
Machine: x86_64
Instance name: xxxxx1
Redo thread mounted by this instance: 1
Oracle process number: 309
Unix process pid: 23336, image: oracle@xxxxxxx1 (TNS V1-V3)
*** 2014-08-27 12:17:00.455
*** SESSION ID:(3664.48931) 2014-08-27 12:17:00.455
*** CLIENT ID:() 2014-08-27 12:17:00.455
*** SERVICE NAME:(SYS$USERS) 2014-08-27 12:17:00.455
*** MODULE NAME:(beremote@xxxxxx1 (TNS V1-V3)) 2014-08-27 12:17:00.455
*** ACTION NAME:() 2014-08-27 12:17:00.455
WARNING: failed to open a disk[/dev/asm-data2]
ORA-15025: could not open disk "/dev/asm-data2"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
kfk_debug_get_user_groups: uid:2, euid:501, gid:0, egid:504
WARNING: failed to open a disk[/dev/asm-data2]
ORA-15025: could not open disk "/dev/asm-data2"
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3
kfk_debug_get_user_groups: uid:2, euid:501, gid:0, egid:504
WARNING: disk locally closed resulting in I/O error
WARNING: Read Failed. group:3 disk:1 AU:920 offset:16384 size:16384
path:Unknown disk
incarnation:0xe968aabb synchronous result:'I/O error'
subsys:Unknown library iop:0x7f71b15c1000 bufp:0x7f71b17a7e00 osderr:0x0 osderr1:0x0
WARNING: failed to read mirror side 1 of virtual extent 0 logical extent 0 of file 260 in group [3.3284687426] from disk DATADG_0001 allocation unit 920 reason error; if possible, will try another mirror side
DDE: Problem Key 'ORA 202' was flood controlled (0x5) (no incident)
ORA-00202: control file: '+DATADG/xxxxx/controlfile/current.260.853170001'
ORA-15081: failed to submit an I/O operation to a disk
*** 2014-08-27 12:17:00.458
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=1, mask=0x0)
----- Error Stack Dump -----
ORA-00202: control file: '+DATADG/xxxxx/controlfile/current.260.853170001'
ORA-15081: failed to submit an I/O operation to a disk
----- Current SQL Statement for this session (sql_id=6hz7hx94wrdkn) -----
select LOG_MODE from V$DATABASE
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
skdstdst()+36 call kgdsdst() 000000000 ? 000000000 ?
7FFFFE34CBC8 ? 000000001 ?
000000001 ? 000000002 ?
ksedst1()+98 call skdstdst() 000000000 ? 000000000 ?
7FFFFE34CBC8 ? 000000001 ?
000000000 ? 000000002 ?
ksedst()+34 call ksedst1() 000000000 ? 000000001 ?
7FFFFE34CBC8 ? 000000001 ?
000000000 ? 000000002 ?
dbkedDefDump()+2741 call ksedst() 000000000 ? 000000001 ?
7FFFFE34CBC8 ? 000000001 ?
000000000 ? 000000002 ?
ksedmp()+36 call dbkedDefDump() 000000001 ? 000000000 ?
7FFFFE34CBC8 ? 000000001 ?
000000000 ? 000000002 ?
kcccsi()+126 call ksedmp() 000000001 ? 000000000 ?
7FFFFE34CBC8 ? 000000001 ?
000000000 ? 000000002 ?
kccrhd()+1626 call kcccsi() 0000000CC ? 000000001 ?
000000001 ? 000000001 ?
000000000 ? 000000002 ?
kccgft_refresh_hdr( call kccrhd() 7F71B178B478 ? 7FFFFE349400 ?
)+112 000000000 ? 000000002 ?
000000000 ? 000000002 ?
kccgftcs()+706 call kccgft_refresh_hdr( 7F71B178B478 ? 7FFFFE349400 ?
) 000000000 ? 000000002 ?
000000000 ? 000000002 ?
kccgft()+59 call kccgftcs() 7F71B178B468 ? 7F71B1780D00 ?
7F71B178B220 ? 000000000 ?
000000000 ? 000000000 ?
kccxdi()+81 call kccgft() 000000000 ? 000000000 ?
7FFFFE349400 ? 000000000 ?
000000000 ? 000000000 ?
qerfxFetch()+521 call kccxdi() 000000000 ? 000000000 ?
7F71B178B220 ? 7F71B1780D00 ?
8C34A7EA8 ? 000000000 ?
rwsfcd()+103 call qerfxFetch() 8C34A8100 ? 7F71B178AE98 ?
000000000 ? 000000000 ?
7F7100000001 ? 000000000 ?
qerjotFetch()+453 call rwsfcd() 8C34A7CA8 ? 7F71B178B868 ?
000000000 ? 000000000 ?
7F7100000001 ? 000000000 ?
opifch2()+2995 call qerjotFetch() 8C34A7A70 ? 7F71B17895E8 ?
00917A034 ? 7FFFFE352F50 ?
000000001 ? 8C34A7998 ?
kpoal8()+2929 call opifch2() 000000089 ? 000000005 ?
7FFFFE353560 ? 7F71B1788268 ?
000000001 ? 8C34A7998 ?
opiodr()+916 call kpoal8() 00000005E ? 00000001C ?
7FFFFE3564C0 ? 7F71B1788268 ?
000000001 ? 100000001 ?
ttcpip()+2242 call opiodr() 00000005E ? 00000001C ?
7FFFFE3564C0 ? 000000000 ?
009B916F0 ? 100000001 ?
opitsk()+1668 call ttcpip() 00BB09C30 ? 0094D6EB0 ?
7FFFFE3564C0 ? 000000000 ?
7FFFFE355F18 ? 7FFFFE3566B4 ?
opiino()+961 call opitsk() 00BB09C30 ? 000000001 ?
7FFFFE3564C0 ? 000000000 ?
7FFFFE355F18 ? 7FFFFE3566B4 ?
opiodr()+916 call opiino() 00000003C ? 000000004 ?
7FFFFE357C38 ? 000000000 ?
7FFFFE355F18 ? 7FFFFE3566B4 ?
opidrv()+565 call opiodr() 00000003C ? 000000004 ?
7FFFFE357C38 ? 000000000 ?
009B911A0 ? 7FFFFE3566B4 ?
sou2o()+98 call opidrv() 00000003C ? 000000004 ?
7FFFFE357C38 ? 000000000 ?
009B911A0 ? 7FFFFE3566B4 ?
opimai_real()+128 call sou2o() 7FFFFE357C10 ? 00000003C ?
000000004 ? 7FFFFE357C38 ?
009B911A0 ? 7FFFFE3566B4 ?
ssthrdmain()+252 call opimai_real() 000000002 ? 7FFFFE357E00 ?
000000004 ? 7FFFFE357C38 ?
009B911A0 ? 7FFFFE3566B4 ?
main()+196 call ssthrdmain() 000000002 ? 7FFFFE357E00 ?
000000001 ? 000000000 ?
009B911A0 ? 7FFFFE3566B4 ?
__libc_start_main() call main() 000000002 ? 7FFFFE357FA8 ?
+253 000000001 ? 000000000 ?
009B911A0 ? 7FFFFE3566B4 ?
_start()+36 call __libc_start_main() 000A0AF64 ? 000000002 ?
7FFFFE357F98 ? 000000000 ?
009B911A0 ? 7FFFFE3566B4 ?
|
|