Re: ORA-07745

Eric,

Thank you for the reply, I'm currently running 8.1.5 (32-bit) I forgot to mention. My company currently does not have Oracle support, even though 8.1.5 is not supportted, and from reading the other messages on this posting, the concensus is to upgrade to a supported version, such as 8.1.7. I'd also like management here to get the Oracle Support renewed.

-Dave Steele

ecstahl_at_aol.com (ECStahl) wrote in message news:<20020827234524.08433.00000003_at_mb-da.aol.com>...
> 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 Wed Aug 28 2002 - 09:27:58 CDT