错误信息如下,我在OEM上也连不上通过EM可以连上
[oracle@ltgateway bdump]$ cat ora10g_pmon_30172.trc
/data/oracle/admin/ora10g/bdump/ora10g_pmon_30172.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /data/oracle/product/10.2.1
System name:Linux
Node name:ltgateway
Release:2.6.9-22.ELsmp
Version:#1 SMP Mon Sep 19 18:32:14 EDT 2005
Machine:i686
Instance name: ora10g
Redo thread mounted by this instance: 1
Oracle process number: 2
Unix process pid: 30172, image: oracle@ltgateway (PMON)
*** 2007-07-25 16:17:55.952
*** SERVICE NAME
SYS$BACKGROUND) 2007-07-25 16:17:55.952
*** SESSION ID
170.1) 2007-07-25 16:17:55.952
PMON unable to acquire latch20003d74 process allocation level=1
Location from where latch is held: ksukia:
Context saved from call: 0
state=busy, wlstate=free
gotten 188 times wait, failed first 0 sleeps 0
gotten 99 times nowait, failed: 0
possible holder pid = 21 ospid=2447
----------------------------------------
SO: 0x6a2b64bc, type: 2, owner: (nil), flag: INIT/-/-/0x00
(process) Oracle pid=21, calls cur/top: (nil)/0x6a3c2964, flag: (0) -
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 1089 8 12
last post received-location: ksusig
last process to post me: 6a2b64bc 5 0
last post sent: 0 0 200
last post sent-location: kmmpsh
last process posted by me: 6a2b3cd0 1 0
(latch info) wait_event=0 bits=2
holding(efd=4) 20003d74 process allocation level=1
Location from where latch is held: ksukia:
Context saved from call: 0
state=busy, wlstate=free
Process Group: DEFAULT, pseudo proc: 0x6a2e55e4
O/S info: user: oracle, term: pts/0, ospid: 2447
OSD pid info: Unix process pid: 2447, image: oracle@ltgateway (TNS V1-V3)
Short stack dump: ksdxfstk()+19<-ksdxcb()+1321<-sspuser()+81<-0070E7A2
Dump of memory from 0x6A2A2974 to 0x6A2A2AF8
6A2A2970
0000000F 6A82A7A4 00000010[.......j....]
6A2A2980 0003139D 6A3C2964 00000003 0003139D[....d)<j........]
6A2A2990 6A4D0C90 0000000B 0003139D 6A38960C[..Mj..........8j]
6A2A29A0 00000004 00031291 6A453A84 00000005[.........:Ej....]
6A2A29B0 0003139D 68553778 00000007 0003139D[....x7Uh........]
6A2A29C0 685537FC 00000007 0003139D 68553904[.7Uh.........9Uh]
6A2A29D0 00000007 0003139D 6A4D0E64 0000000B[........d.Mj....]
6A2A29E0 0003139D 685541D8 00000007 0003139D[.....AUh........]
6A2A29F0 68554818 00000007 0003139D 6855489C[.HUh.........HUh]
6A2A2A00 00000007 0003139D 68554920 00000007[........ IUh....]
6A2A2A10 0003139D 685549A4 00000007 0003139D[.....IUh........]
6A2A2A20 68554A28 00000007 0003139D 00000000[(JUh............]
6A2A2A30 00000000 00000000 00000000 00000000[................]
Repeat 11 times
6A2A2AF0 00000000 00000000
[........]
*** 2007-07-25 16:17:55.980
PMON unable to acquire latch20003d74 process allocation level=1
Location from where latch is held: ksukia:
Context saved from call: 0
state=busy, wlstate=free
gotten 188 times wait, failed first 0 sleeps 0
gotten 99 times nowait, failed: 0
possible holder pid = 21 ospid=2447
*** 2007-07-25 16:17:58.348
PMON unable to acquire latch20003d74 process allocation level=1
Location from where latch is held: ksukia:
Context saved from call: 0
state=busy, wlstate=free
gotten 188 times wait, failed first 0 sleeps 0
gotten 99 times nowait, failed: 0
possible holder pid = 21 ospid=2447
*** 2007-07-25 16:18:00.720
PMON unable to acquire latch20003d74 process allocation level=1
Location from where latch is held: ksukia:
Context saved from call: 0
state=busy, wlstate=free
gotten 188 times wait, failed first 0 sleeps 0
gotten 99 times nowait, failed: 0
possible holder pid = 21 ospid=2447
*** 2007-07-25 16:18:03.094
PMON unable to acquire latch20003d74 process allocation level=1
Location from where latch is held: ksukia:
Context saved from call: 0
state=busy, wlstate=free
gotten 188 times wait, failed first 0 sleeps 0
gotten 99 times nowait, failed: 0
possible holder pid = 21 ospid=2447
*** 2007-07-25 16:18:05.440
PMON unable to acquire latch20003d74 process allocation level=1
Location from where latch is held: ksukia:
Context saved from call: 0
state=busy, wlstate=free
gotten 188 times wait, failed first 0 sleeps 0
gotten 99 times nowait, failed: 0
possible holder pid = 21 ospid=2447
*** 2007-07-25 16:18:07.794
PMON unable to acquire latch20003d74 process allocation level=1
Location from where latch is held: ksukia:
Context saved from call: 0
state=busy, wlstate=free
gotten 188 times wait, failed first 0 sleeps 0
gotten 99 times nowait, failed: 0
possible holder pid = 21 ospid=2447
*** 2007-07-25 16:18:10.092 |