| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: HP-UX 11i/9.2.0.3/Strange Executions
Mladen,
You apparently have never been involved in supporting SAP. :)
He may not be able to contact Oracle directly.
And if it involves a patch, that patch must come from SAP.
Jared
"Gogala, Mladen" <MGogala_at_oxhp.com>
Sent by: ml-errors_at_fatcity.com
07/21/2003 02:34 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:
Subject: RE: HP-UX 11i/9.2.0.3/Strange Executions
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:mgogala_at_oxhp.com
-----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)" <mvergara_at_guidant.com>
Sent by: ml-errors_at_fatcity.com
07/21/2003 02:04 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
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
,
: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: mvergara_at_guidant.com 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: ListGuru_at_fatcity.com (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: Jared.Still_at_radisys.com 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: ListGuru_at_fatcity.com (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: MGogala_at_oxhp.com 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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inReceived on Mon Jul 21 2003 - 16:52:19 CDT
 |
 |