Re: ORA-07745

Dave,

OS signal 11 is a SIGSEGV - segmentation violation ie the process tried to address a valid address, that it was not allowed to address.

It can come about for a number of reasons, including stack growth failure ie the process trying to grow its stack past the ulimit or maxssiz (32-bit) limits.

The kernels 64-bit stack parameter is maxssiz_64bit (if your database is 64-bit).

But in the context of an ORA-07745, I think you should check with Oracle support.

The several times I've seen this Oracle error, it was fixed by Oracle. eg modifying the fast_start_io_target init.ora param on an 8.0.5 database, or known bugs.

Regards,

Eric Stahl

DKBSteele_at_aol.com (Dave Steele) Wrote:

>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 - 22:45:24 CDT