- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: SIGBUS error on import
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- 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
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-16-2004 10:52 AM
тАО04-16-2004 10:52 AM
SIGBUS error on import
We are in the process of converting from Oracle 8.1.7.4 to 9.2.0.4. We occasionally have a problem with the import crashing while it is importing a particularly large stored procedure.
ORA-07445: exception encountered: core dump [qcstda()+236] [SIGBUS] [unknown code] [0x000000000] [] []
I saw some similar messages about SIGBUS errors on this forum and increased maxdsize and maxdsize64 to 2gb each. It worked once, but then an import failed the next day.
Has anyone seen this? Any suggestions?
Thanks
Tim
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-16-2004 06:29 PM
тАО04-16-2004 06:29 PM
Re: SIGBUS error on import
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-16-2004 07:28 PM
тАО04-16-2004 07:28 PM
Re: SIGBUS error on import
http://metalink.oracle.com/metalink/plsql/showdoc?db=Not&id=208922.1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-16-2004 11:41 PM
тАО04-16-2004 11:41 PM
Re: SIGBUS error on import
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-17-2004 10:29 AM
тАО04-17-2004 10:29 AM
Re: SIGBUS error on import
Does it always fail on a single stored procedure, or does it fail on random large ones?
What buffer parameter are you setting for the import as well?
Does the rest of the database complete successfully before hand (tables/indexes). What about dropping the procedure in 8i, and reloading it in 9i?
Thanks,
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-17-2004 10:50 AM
тАО04-17-2004 10:50 AM
Re: SIGBUS error on import
Please check this link:
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=242927
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-17-2004 07:07 PM
тАО04-17-2004 07:07 PM
Re: SIGBUS error on import
For example:
sqlplus "/ as sysdba"
alter system set "_plsql_load_without_compile"=true scope=spfile;
startup force;
imp ....
Then afterwards go through the procedures and compile them individually.
Also, you should be on 9205 patchset.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-18-2004 12:57 AM
тАО04-18-2004 12:57 AM
Re: SIGBUS error on import
Why dont u go for a physical backup restore and upgrade the database.
Recently we did this for converting for a 9.0.1.4 RAC to 9.2.0.4 RAC.
It surely will be more time saving than an import.
Regards.
Shaffat.