Oracle is suddenly failed

[Phung Ba Vien_1]

Hi all,

Hi all,
I have an Oracle database 8.1.7.4 for HP-UX 11i, and run on HP 9000/800,
about 1000 user.

Oracle is suddenly Failded. but I can not find out what is cause. Please hepl me.

When Oracle run, I use glance command to monitor, I see the CPU and Memory are 100%.

When I checked the Oracle trace file, it message that
=======================================
/home/oracle/admin/PORA817/udump/ora_12470_pora817.trc
Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.4.0 - 64bit Production
ORACLE_HOME = /home/oracle/product/8.0.5
System name: HP-UX
Node name: ipcaspa
Release: B.11.11
Version: U
Machine: 9000/800
Instance name: PORA817
Redo thread mounted by this instance: 1
Oracle process number: 131
Unix process pid: 12470, image: oracle@ipcaspa (TNS V1-V3)

*** SESSION ID:(129.2) 2004-11-29 14:25:37.448
kgefec: fatal error 0
*** 2004-11-29 14:25:37.496
ksedmp: internal or fatal error
ORA-00603: ORACLE server session terminated by fatal error
ORA-02051: another session in same transaction failed
ORA-02051: another session in same transaction failed
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedmp()+236 ? ksedst() 000000000 ?
8000000100005810 ?
4000000000B85903 ?
000000258 ?
ksfdmp()+24 ? ksedmp() 000000803 ? 000000000 ?
000000000 ? 000000001 ?
kgefec()+196 ? ksfdmp() 000000000 ? 000000001 ?
800003FFFE9F6880 ?
0341E6A40 ?
k2send()+7420 ? kgefec() 000AAF068 ?
FFFFFFFFFFFFFFFF ?
000000000 ? 000000001 ?
kpotxcap()+512 ? k2send() 000000068 ?
5555555555555555 ?
00000006E ? 000000068 ?
kpotxen()+1028 ? kpotxcap() 420D11C6C0 ? 000000005 ?
800003FFFE9F4D40 ?
000000000 ?
opiodr()+2092 ? kpotxen() 000000000 ?
4000000000C45507 ?
000000000 ? 000000000 ?
ttcpip()+4672 ? opiodr() 2001100000000 ?
80000001000A2F78 ?
000000001 ?
4000000000559A68 ?
opitsk()+748 ? ttcpip() 800003FFD00142E8 ?
C00000000004F167 ?
000000002 ?
800003FFD000EDF8 ?
opiino()+1328 ? opitsk() 000000000 ? 000000000 ?
000000000 ? 000000000 ?
opiodr()+2092 ? opiino() 4000000000573BE0 ?
5555555555555555 ?
000000040 ?
800003FFD000EDF8 ?
opidrv()+1696 ? opiodr() 00000048C ?
C000000000012CBF ?
000000947 ? 000000000 ?
sou2o()+32 ? opidrv() 000000000 ? 201000000000000 ?
000000000 ? 000000000 ?
main()+200 ? sou2o() 000000000 ? 000000000 ?
800003FFFE9F0E10 ?
000000000 ?
$START$()+152 ? main() 000000001 ?
800003FFFE9F0ACA ?
800003FFFE9F0A08 ?
800003FFFE9F08DE ?
----- Argument/Register Address Dump -----
Argument/Register addr=000000000.
Dump of memory from 0x000000000 to 0x000000100
00000000 00000000 00000000 00000000 00000000 [................]
Repeat 15 times
Argument/Register addr=8000000100005810.
Dump of memory from 0x8000000100005810 to 0x8000000100005910
00005810 800003FF FE9F5DD8 800003FF FE9F67A8 [......].......g.]
00005820 80000001 000B0CE0 02000000 00000000 [................]
00005830 00000803 00000000 00000000 00000000 [................]
00005840 00000000 00000000 00000000 00000000 [................]
00005850 00000000 00000000 80000001 000B0CE0 [................]
00005860 02000000 00000000 00000803 00000000 [................]
00005870 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
00005890 80000001 000B0CE0 02000000 00000000 [................]
000058A0 0000025B 00000000 00000000 00000000 [...[............]


=========

[Eric Antunes]

Hi,

The first strange thing I see is your $ORACLE_HOME: /home/oracle/product/8.0.5? I think it should be something more explicit and according to your rdbms version, something like:

/home/oracle/product/8.1.7

Maybe you're facing a memory issue. Check this thread:

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=129382

Best Regards,

Eric

[Yogeeraj_1]

hi,

as Eric mentioned above, it is most likely a memory problem.

You should also have a look at your alert.log. There is also a likelihood of a runway oracle process.

please post more details (e.g. error in alert log, application types that you run, are you on MTS or dedicated?)


regards
Yogeeraj