Has anyone had simular problems with Oracle 8.1.5 (8i) database on an
HP-UX 11.00 server. I have the PMON process id hang, and the database
has to be restarted, it does not happen all the time, but only once or
twice a month, at different times of the day or night. This is the
following error I get:
Dump file /opt/app/oracle/xxxx/logs/<db_name>/pmon_20200.trc
Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production
ORACLE_HOME = /opt/app/oracle/xxxx/product/8.1.5
System name: HP-UX
Node name: <host_name>
Release: B.11.00
Version: B
Machine: 9000/889
Instance name: <db_name>
Redo thread mounted by this instance: 1
Oracle process number: 2
Unix process pid: 20200, image: oracle@<host_name> (PMON)
- 2002.08.22.07.22.24.295
- SESSION ID:(1.1) 2002.08.22.07.22.24.237
Exception signal: 11, code = 7eff25a0
sc_onstack: 00000000cdabc000, sc_mask 00000000000004e0
ORA-07445: exception encountered: core dump [11] [2130650528]
[3450585088] [1248] [] []
----- Call Stack Trace -----
calling call entry argument values in
hex
location type point (? means dubious
value)
-------------------- -------- --------------------
ssexhd + 256 ???? ksedst 1D15 ? 0 ? B ? 0 ?
ssexhd + 8 ???? ssexhd 0 ? 16 ? 0 ? 4E0 ?
kmmlrs + 232 ???? Adr: 0xC01F10A0 1 ? 1 ? 39488 ?
3D64C970 ?
kmmlrl + 1624 ???? kmmlrs 1B20000 ? 150035 ?
160007 ?
7D20008 ?
ksucln + 360 ???? kmmlrl 70 ? 2148 ? 100 ?
CDAB0150 ?
ksucln + 8 ???? ksucln 134B7A8 ? CDAB0150
? 2 ? 96 ?
opirip + 524 ???? ksbrdp 7EFF1760 ? 40117810
? 4048 ?
0 ?
opidrv + 716 ???? opirip 7EFF0DC8 ? 169CD50
?
169CD38 ? 2F ?
sou2o + 204 ???? opidrv 169C9D0 ? 7EFF0AB0
?
7EFF0AF0 ? 1BF ?
main + 260 ???? sou2o 0 ? 0 ? 0 ? 0 ?
main + 8 ???? main 0 ? 0 ? 0 ? 0 ?
Adr: 0xC013CB34 ???? Adr: 0xC013CC34 0 ? 0 ? 0 ? 0 ?
TBS$#var#tmp#_0_1194 ???? Adr: 0x31393334 0 ? 7EFF044D ?
7EFF043B ?
7EFF0432 ?
----- Argument/Register Address Dump -----
Argument/Register addr=1d15. Dump of memory from 0x1CD5 to 0x1E15
1CC0 00000000 00000000
00000000
1CE0 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
Repeat 8 times
1E00 00000000 00000000 00000000 00000000 00000000 00000000
Argument/Register addr=0. Dump of memory from 0x0 to 0x100
000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
Repeat 7 times
Argument/Register addr=4e0. Dump of memory from 0x4A0 to 0x5E0
4A0 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00000000
Repeat 9 times
Argument/Register addr=39488. Dump of memory from 0x39448 to 0x39588
39440 0000105C 00007740 40100700 00000155 0D00FFFF
FFFFFFFF
39460 00007747 00789E58 00000155 0300FFFF 0000105E 00007747 40100708
00000155
39480 0D00FFFF FFFFFFFF 0000774E 005C9F28 00000155 0300FFFF 00001060
0000774E
394A0 40100710 00000155 0D00FFFF FFFFFFFF 00007755 005CB134 00000155
0300FFFF
394C0 00001062 00007755 40100718 00000155 0D00FFFF 000000E8 0000775D
00BB683C
394E0 00000155 0300FFFF 00001064 0000775D 40100720 00000155 0D00FFFF
FFFFFFFF
39500 00007765 00BA1BD8 00000155 0300FFFF 00001066 00007765 40100728
00000155
39520 0D00FFFF FFFFFFFF 0000776E 00BA1A54 00000155 0300FFFF 00001068
0000776E
39540 40100730 00000155 0D00FFFF FFFFFFFF 00007777 00BA197C 00000155
0300FFFF
39560 0000106A 00007777 40100738 00000155 0D00FFFF FFFFFFFF 00007780
00BA18B8
39580 00000155 0300FFFF
Argument/Register addr=150035. Dump of memory from 0x14FFF5 to
0x150135
14FFE0 D2B61FF0 8EC02000
08000240
150000 47C13EF1 D03F1FF0 87E22142 4BD43D19 22A20000 36B62289 0E961290
34010020
150020 4BDF3E99 87E020FA 347A0000 34D90000 4BD83EA1 4BD73E91 34141822
6BD43F99
150040 6BC13F91 34150014 6BD53F89 4BD63E79 6BD63F81 4BC13E81 6BC13F79
4BDF3E89
150060 6BDF3F71 6BC03F69 2B7FDFFF 483408A0 4A950068 6BD53F61 2B7FDFFF
483608A0
150080 4AC10070 6BC13F59 E8400000 284EA01E 34210A78 002010BF 001F1820
E4200000
1500A0 37E20000 4BD33FC1 E8001320 34053FFF 34080000 4BDF3D29 8BE847F2
4BD43D31
1500C0 0E882095 86A027AA 4BD63D31 0EC82089 6520009C 3401000C 4BDF3E99
87E0210A
1500E0 347A0000 34D90000 4BD83EA1 4BD73E91 34141846 6BD43F99 6BC13F91
34150014
150100 6BD53F89 4BD63E79 6BD63F81 4BC13E81 6BC13F79 4BDF3E89 6BDF3F71
6BC03F69
150120 2B7FDFFF 483408A0 4A950B48 6BD53F61 2B7FDFFF 483608A0
Argument/Register addr=160007. Dump of memory from 0x15FFC7 to
0x160107
15FFC0 E85F08F5 46790024 838B2338 08000240 487A00A8 4B5D0068
E85F08C5
15FFE0 47B90020 838B2308 08000240 487A00A8 4B590068 E85F0895 47390018
838B22D8
160000 08000240 487A00A8 4B580068 E85F0865 47190054 838B22A8 08000240
487A00A8
160020 4B570068 E85F0835 46F90000 838B2278 08000240 487A00A8 4B5F0068
E85F0805
160040 47F9000C 838B2248 08000240 487A00A8 4B4E0068 E85F07D5 45D90028
838B2218
160060 08000240 487A00A8 4B4D0068 E85F07A5 45B9007C 838B21E8 08000240
487A00A8
160080 4B420068 4459002C E85F076D 08000240 838B21B0 08000240 487A00A8
4B410068
1600A0 E85F073D 44390030 838B2180 08000240 487A00A8 4B5C0068 E85F070D
47990034
1600C0 838B2150 08000240 487A00A8 4B560068 E85F06DD 46D90050 838B2120
08000240
1600E0 487A00A8 4B550068 E85F06AD 46B9004C 838B20F0 08000240 487A00A8
4B540068
160100 E85F067D 4699003C
Argument/Register addr=70. Dump of memory from 0x30 to 0x170
etc...............
I've done a "strings" command on the core dump file but can't tell
what the error is. Any help would be appreciated.
Thank you,
Dave
Received on Tue Aug 27 2002 - 15:49:10 CDT
