Is or are ALL of the SAP form identical on both servers? It could be the
SAP is different on the servers and be the cause of the problem.
Ron
>>> [EMAIL PROTECTED] 07/21/03 05:34PM >>>
He needs to contact oracle support, because the dump came from the
oracle server process. If he's lucky, the one-off patch is already
published
and he only needs to download it from Metalink and apply it. If not,
then he has to wait for oracle 9BF (BF = Bug Free)
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-----Original Message-----
Sent: Monday, July 21, 2003 5:20 PM
To: Multiple recipients of list ORACLE-L
SIGSEGV = Segment Violation = invalid address = bad code
Sounds like you need to contact SAP and/or Oracle support.
Jared
"Vergara, Michael (TEM)" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/21/2003 02:04 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc:
Subject: HP-UX 11i/9.2.0.3/Strange Executions
Hi Everyone!
HELP!
I upgraded my SAP *PRODUCTION* instance to 9.2.0.3 over the weekend.
Everything up until now has been OK. However, I now have some
SAP Transactions (read: data entry forms) that are abending
unexpectedly.
What's strange is that when we run the transaction on our Stage
server the explain plan is different, and the query succeeds. In
PRD, the query is a single-step, and in stage it gets broken out
into sub-queries and executed there.
I created a report of all the database parameters. There is no
difference that cannot be explained by the difference in CPUs,
database name, or application paths. They are fundamentally
identical.
But the query aborts on PRD. I am attaching the top few lines
of a typical trace file. ANY help, RTFM references, suggestions,
incantations, incense, or holy water will be appreciated.
Thanks,
Mike
*** 2003-07-21 14:52:06.921
*** SESSION ID:(326.5957) 2003-07-21 14:52:06.886
Exception signal: 11 (SIGSEGV), code: 0 (unknown code), addr:
0x800000016ede9f30, PC: [0x4000000001331c0c, kghfrmrg()+596]
Registers:
r1: 800000010000d9e8 r22: 6e6178d8 sr4: 7df0c00
rp: 0 arg3: 800000016ede9f28 sr0: 67c9c00
r3: 40000000013319b8 arg2: c00000006e615fa0 sr1: d7db000
r4: 0 arg1: 6e615fa0 sr2: 0
r5: 0 arg0: c0b38f0000001131 sr3: 0
r6: 7ffffffc dp: 80000001000ca608 sr5: 6930000
r7: 0 ret0: 0 sr6: a814c00
r8: 80000001007d3798 ret1: 800000000000000 sr7: 67c9c00
r9: 80000001007d3780 sp: 800003ffbfff6880 cr0: 0
r10: 0 r31: 6 cr8: 77f6368
r11: 0 sar: 38 cr9: 77f6378
r12: 0 pcoqh: 4000000001331c0f ccr: 0
r13: 10000 pcsqh: 6930000 cr12: 494c008
r14: 800003ffbfff48c0 pcoqt: 4000000001331a93 cr13: 4a2b008
r15: 800003ffbfff48c8 pcsqt: 6930000 cr24: 4a2c808
r16: 40000000003f85d0 eiem: ffffffffffffffff cr25: 4a2a808
r17: af0 iir: 72f50010 cr26: 4a2c808
r18: 0 isr: a814c00 mpsfu_hi:
80000001000e36c8
r19: 800000010000d9e8 ior: 800000016ede9f30 mpsfu_lo: 0
r20: 0 ipsw: ff080cff1f mpsfu_ov: 41
r21: 80000001007d2650 goto: 97f68 pad: 0
*** 2003-07-21 14:52:07.811
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kghfrmrg()+596] [SIGSEGV]
[unknown code] [0x800000016EDE9F30] [] []
Current SQL statement for this session:
SELECT T_00 . "MATNR" , T_00 . "PRDHA" , T_01 . "MAKTX" FROM "MARA"
T_00 ,
"MAKT" T_01 WHERE ( T_01 . "MANDT" = :A0 AND T_01 . "MATNR" = T_00 .
"MA
TNR" ) AND T_00 . "MANDT" = :A1 AND ( ( T_00 . "MATNR" BETWEEN :A2 AND
:A3
OR T_00 . "MATNR" BETWEEN :A4 AND :A5 OR T_00 . "MATNR" BETWEEN :A6 AND
:A7 OR T_00 . "MATNR" BETWEEN :A8 AND :A9 OR T_00 . "MATNR" BETWEEN
:A10
AND :A11 OR T_00 . "MATNR" BETWEEN :A12 AND :A13 OR T_00 . "MATNR"
BETWEEN
:A14 AND :A15 OR T_00 . "MATNR" BETWEEN :A16 AND :A17 OR T_00 .
"MATNR"
BETWEEN :A18 AND :A19 ) OR T_00 . "MATNR" IN ( :A20 , :A21 , :A22 ,
:A23 ,
:A24 , :A25 , :A26 , :A27 , :A28 , :A29 , :A30 , :A31 , :A32 , :A33 ,
:A34 , :A35 , :A36 , :A37 , :A38 , :A39 , :A40 , :A41 , :A42 , :A43 ,
:A44
,
:A45 , :A46 , :A47 , :A48 , :A49 , :A50 , :A51 , :A52 , :A53 , :A54 ,
:A55 , :A56 , :A57 , :A58 , :A59 , :A60 , :A61 , :A62 , :A63 , :A64 ,
:A65
,
:A66 , :A67 , :A68 , :A69 , :A70 , :A71 , :A72 , :A73 , :A74 , :A75 ,
:A76 , :A77 , :A78 , :A79 , :A80 , :A81 , :A82 , :A83 , :A84 , :A85 ,
:A86
,
:A87 , :A88 , :A89 , :A90 , :A91 , :A92 , :A93 , :A94 , :A95 , :A96 ,
:A97 , :A98 , :A99 , :A100 , :A101 , :A102 , :A103 , :A104 , :A105 ,
:A106
,
:A107 , :A108 , :A109 , :A110 , :A111 , :A112 , :A113 , :A114 , :A115
,
:A116 , :A117 , :A118 , :A119 , :A120 , :A121 , :A122 , :A123 , :A124 ,
:A
125 , :A126 , :A127 , :A128 , :A129 , :A130 , :A131 , :A132 , :A133 ,
:A134 , :A135 , :A136 , :A137 , :A138 , :A139 , :A140 , :A141 , :A142 ,
:A143
, :A144 , :A145 , :A146 , :A147 , :A148 , :A149 , :A150 , :A151 ,
:A152 ,
:A153 , :A154 , :A155 , :A156 , :A157 , :A158 , :A159 , :A160 , :A161 ,
:A162 , :A163 , :A164 , :A165 , :A166 , :A167 , :A168 , :A169 , :A170 ,
:A171 , :A172 , :A173 , :A174 , :A175 , :A176 , :A177 , :A178 , :A179 ,
:A1
80 , :A181 , :A182 , :A183 , :A184 , :A185 , :A186 , :A187 , :A188 ,
:A189
, :A190 , :A191 , :A192 , :A193 , :A194 , :A195 , :A196 , :A197 , :A198
, :A199 , :A200 , :A201 , :A202 , :A203 , :A204 , :A205 , :A206 , :A207
,
:A208 , :A209 , :A210 , :A211 , :A212 , :A213 , :A214 , :A215 , :A216 ,
:
A217 , :A218 , :A219 , :A220 , :A221 , :A222 , :A223 , :A224 , :A225 ,
:A226 , :A227 , :A228 , :A229 , :A230 , :A231 , :A232 , :A233 , :A234 ,
:A23
5 , :A236 , :A237 , :A238 , :A239 , :A240 , :A241 , :A242 , :A243 ,
:A244
, :A245 , :A246 , :A247 , :A248 , :A249 , :A250 , :A251 , :A252 , :A253
,
:A254 , :A255 , :A256 , :A257 , :A258 , :A259 , :A260 , :A261 ) ) AND
T_01 . "SPRAS" = :A262
----- Call Stack Trace -----
---
===========================================================================
Michael P. Vergara
Oracle DBA
Guidant Corporation
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vergara, Michael (TEM)
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gogala, Mladen
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ron Rogers
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
