Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle is suddenly failed

Phung Ba Vien_1
Occasional Visitor

Oracle is suddenly failed

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 [...[............]


=========
2 REPLIES
Eric Antunes
Honored Contributor

Re: Oracle is suddenly failed

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


Each and every day is a good day to learn.
Yogeeraj_1
Honored Contributor

Re: Oracle is suddenly failed

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)