RE: Report coredump w/r25run

Bruce,

Thanks for the ideas.

I'll try the stack lookup utility, but I'm not getting any ORA- errors that I can see.

Yes the SQL runs fine from sqlplus outside of r25run.

Any more ideas??

Stephen

>>> Bruce.Reardon_at_comalco.riotinto.com.au 08/22/02 09:13PM >>>
What is in the core dump?
Have tried putting that through the Metalink ora-600 / stack lookup utility at
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=153788.1 ?

Have you tried running the queries that the reports run from SQL - does it still core dump?

HTH,
Bruce Reardon

-----Original Message-----
Sent: Friday, 23 August 2002 13:53

Tru64 unix and VMS

Suddenly all reports that were working just fine this morning quit working. In Unix we get memory fault and a coredump. In VMS we get "%SYSTEM-F-ACCVIO, access violation...".

I have a TAR open already, but I'm hoping one of you guys will be able to point me to a solution or at least some more troubleshooting steps.

Here's what I've tried and the results.

1. r25run interactive from 2 different VMS machines and 1 Unix machine. Unix = memory fault and core dump VMS = access violation
2. Tried connecting to dev database with same results.

Still to be tried

3. Oracle support said "might be an emulator issue, so try it from host." I will try that in the AM when sysadmins come in to let me into the computer room.

4. Metalink I found Note:1074085.6 which suggested unsetting the LOGICAL DEBUG_SLFIND (in VMS ,so I don't know if this will help the unix side of the problem)

Does anyone have any other insight that might point me in the right direction??

TIA
Stephen

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Reardon, Bruce (CALBBAY)
  INET: Bruce.Reardon_at_comalco.riotinto.com.au 

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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.com
-- 
Author: Stephen Andert
  INET: StephenAndert_at_firsthealth.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).