From: nstacks2001@netscape.net
Date: Thu Jun 05 2003 - 12:43:03 EDT
Managers,
We upgraded our 2 node GS160 cluster to Tru64 5.1a and applied patch kit one. After doing so, our DBA's started seeing this oracle error. We have logged calls with both Oracle and HP, but have yet to find a cause or resolution. Was wanting to see if anyone on the list has seen this behavior. The error is below, from the oracle log. We are not seeing any errors on the system side, other than oracle processes taking up most of the memory, and we have all memory available to use, and also we are seeing a high number of fault pages. Also, the DBA's are seeing some small corruption in some oracle temp files. Message from DBA follows.
Thank you,
David W. Stacks
Systems Manager
210-475-8218
The problem is still the same. After upgrade and changing hardware paths OS is eem not
statble as causing so many page fault in "vmstat" report.
procs memory pages intr cpu
r w u act free wire fault cow zero react pin pout in sy cs us sy id
12 879 191 1M 156K 89K 27M 1M 19M 2634 2M 0 1K 11K 11K 27 11 62
16 868 190 1M 158K 89K 3248 56 113 0 101 0 798 11K 17K 28 20 52
15 878 190 1M 158K 89K 3918 791 2588 0 503 0 1K 14K 17K 30 21 48
16 876 190 1M 158K 89K 3083 248 1868 0 147 0 3K 16K 19K 32 21 47
14 872 191 1M 160K 89K 3117 591 3680 0 151 0 3K 13K 23K 29 24 47
14 868 190 1M 160K 89K 100 22 264 0 20 0 409 9K 21K 29 12 59
14 871 191 1M 159K 89K 1584 75 994 0 40 0 180 9K 18K 28 13 58
16 865 190 1M 160K 89K 2516 313 1074 0 171 0 1K 12K 17K 28 21 51
15 865 190 1M 160K 89K 2767 665 517 0 651 0 913 13K 16K 27 20 53
14 877 190 1M 158K 89K 4197 852 1572 0 815 0 1K 12K 19K 28 22 50
That is triggering Oracle Dead Lock frequently since it up .
Please contact COMPAQ to straight it up . I am feeling that
we are runing Production Oracle in a unstable OS .
Mon Jun 2 15
:57:55 2003
ORA-000060: Deadlock detected. More info in file /d001/app/zprdora/zprddb/8.1.7/
admin/udump/ora_531415.trc.
Mon Jun 2 16:02:38 2003
ORA-000060: Deadlock detected. More info in file /d001/app/zprdora/zprddb/8.1.7/
admin/udump/ora_531549.trc.
Mon Jun 2 16:02:43 2003
ORA-000060: Deadlock detected. More info in file /d001/app/zprdora/zprddb/8.1.7/
admin/udump/ora_531549.trc.
JN
__________________________________________________________________
McAfee VirusScan Online from the Netscape Network.
Comprehensive protection for your entire computer. Get your free trial today!
http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397
Get AOL Instant Messenger 5.1 free of charge. Download Now!
http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
This archive was generated by hypermail 2.1.7 : Sat Apr 12 2008 - 10:49:21 EDT