- Community Home
- >
- Servers and Operating Systems
- >
- Operating System - OpenVMS
- >
- Oracle Export Crash
-
-
Categories
- Topics
- Hybrid IT with Cloud
- Mobile & IoT
- IT for Data & Analytics
- Transformation
- Strategy and Technology
- Products
- Cloud
- Integrated Systems
- Networking
- Servers and Operating Systems
- Services
- Storage
- Company
- Events
- Partner Solutions and Certifications
- Welcome
- Welcome
- Announcements
- Tips and Tricks
- Feedback
-
Blogs
- Alliances
- Around the Storage Block
- Behind the scenes @ Labs
- Converged Data Center Infrastructure
- Digital Transformation
- Grounded in the Cloud
- HPE Careers
- HPE Storage Tech Insiders
- Infrastructure Insights
- Inspiring Progress
- Internet of Things (IoT)
- My Learning Certification
- Networking
- OEM Solutions
- Servers: The Right Compute
- Telecom IQ
- Transforming IT
-
Quick Links
- Community
- Getting Started
- FAQ
- Ranking Overview
- Rules of Participation
- Contact
- Email us
- Tell us what you think
- Information Libraries
- Integrated Systems
- Networking
- Servers
- Storage
- Other HPE Sites
- Support Center
- Enterprise.nxt
- Marketplace
- Aruba Airheads Community
-
Categories
-
Forums
-
Blogs
-
InformationEnglish
Oracle Export Crash
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
02-02-2006 11:16 PM
02-02-2006 11:16 PM
Oracle Export Crash
Oracle Export Crash
An Oracle (Complete) Export crashed on two occasions for the following reasons:
Crash #1:
%SYSTEM-F-ACCVIO, access violation, reason mask=00, virtual address=00000000010A7FC0, PC=00000000002115C4, PS=0000001B
Crash #2:
%SYSTEM-F-ASTFLT, AST fault, SP=010A7FC0, param=00000BAD, PC=0000000000211688, PS=0000001B, target PC=0000000000000BAD, PS=0000001B
Exports on other occasions executed without error.
Any help would be appreciated.
Thank You
Niall
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
02-02-2006 11:43 PM
02-02-2006 11:43 PM
Re: Oracle Export Crash
Re: Oracle Export Crash
does a previous version of the filename you use in the export exists?
If so, the newly created export file takes some attributes of the 'old' file and the export may fail.
This happened to me some time ago and it took me some time to find out why.
Rgds
Marc
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
02-02-2006 11:43 PM
02-02-2006 11:43 PM
Re: Oracle Export Crash
Re: Oracle Export Crash
these are software programming errors, most likley in the Oracle code. The program counter in both cases is within P0 space, the user program space. If you have a process running the same image, you could use SDA> SHOW PROC/IMA
To collect more information, in case this happens again, you could activate process dumps before running these images:
$ SET PROC/DUMP
then run the image. Or - if it's a detached process and you can influence the RUN command, add a /DUMP.
In case of an improperly handled condition, a process dump would be generated in the default directory and called imagename.DMP. You can analyze such a dump with ANAL/PROCESS.
If you've collected a process dump and have a service contract with Oracle (assuming that V7.3 is still a supported version), you could log a call. Unfortunately, process dump analysis on OpenVMS V7.1-2 process dumps is - in most cases - bound to the system, where the process dump has happenend.
Consider to obtain and install the most recent available patches for Oracle.
Volker.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
02-04-2006 01:34 AM
02-04-2006 01:34 AM
Re: Oracle Export Crash
Re: Oracle Export Crash
That said, I also agree with Volker (That's a no-brainer.. he is always right about VMS thingies :-):
"these are software programming errors, most likley in the Oracle code."
Specially crash #2. Check out that 'target PC' and 'param'... The HEX address actually reads "BAD". So some code (EXP? VMS?anticipated it could get in trouble there!
May we assume that the basic setup has been running succesfully for years and years, exporting (as backup?) frequently? What changed?
- DB size?
- Disk space?
- OS upgrade/patch?
- Hardware (cpus, mem, io)
- Was there an ORA-006xx error reported?
- Was there a .TRC file generated
- Is it related to a specific TABLE/USER?
Even if nothing changed you'll need to capture a bunch of this before raising a call to Oracle.
Of course they might just laugh when you mention 7.3.. and VMS :-(.
Hein.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
02-05-2006 10:44 PM
02-05-2006 10:44 PM
Re: Oracle Export Crash
Re: Oracle Export Crash
The previous (export) file is deleted before beginning the export.
Volker,
Yes, worth trying.
Hein,
No messages in the ALERT log.
The crashes occurred when exporting different tables.
No changes to software or hardware.
Thanks to all for your suggestions.
I will put the question to some of the specialist Oracle fora.
Niall.
Hewlett Packard Enterprise International
- Communities
- HPE Blogs and Forum
© Copyright 2018 Hewlett Packard Enterprise Development LP