- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- DBWR crashing with ORA-7404 on HP-UX
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
тАО01-10-2005 06:46 PM
тАО01-10-2005 06:46 PM
DBWR crashing with ORA-7404 on HP-UX
Our database crashed due to the DBWR process terminated. The database can be restarted without any problem.
In the Oracle DBWR trace file:
error 7404 detected in background process
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-07404: sfareq: Timeout occurred waiting for request to complete.
Has anybody encountered this before? Any solution?
Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-10-2005 07:25 PM
тАО01-10-2005 07:25 PM
Re: DBWR crashing with ORA-7404 on HP-UX
http://dco-proxima.dco.pima.edu/oracle/bug/index/os000201.htm
http://dco-proxima.dco.pima.edu/oracle/bug/s479/b000027.htm
ORA-07404: sfareq: Timeout occurred waiting for request to complete.
Cause: The master database writer timed out waiting for a write or close to complete. One of the database writers may have stopped running.
Action: Check all database writer trace files. Shut down the database and try to warm start.
sks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-10-2005 07:41 PM
тАО01-10-2005 07:41 PM
Re: DBWR crashing with ORA-7404 on HP-UX
Problems have been indicated with HP-UX 10.20 and multiple db writers, which result in errors such as ├в ORA-07404: sfareq: Timeout occurred waiting for request to complete├в
The cause for this is the master database writer timed out waiting for a write or close to complete i. e the dbwr timed out waiting for a write to complete to disk. The key here is that Oracle requests an I/O and times out after 180 seconds. After the first timeout, a warning is written to the alert log and DBWR trace file. It then waits another 360 seconds, and if the writes still aren't done, DBWR terminates with an ORA-7404.
The action for this will be to check all database writer trace files. Shut down the database and try to warm start.
The workaround is to decrease the amount of dbwrs used on the system.
In metalink Bug No: 600823 discusses a port specific bug on HP when using multiple dbwrs.
There were quite a few bugs filed for these problems and 99% are due to OS hardware problems ├в This is what Oracle says.
I hope this helps
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-10-2005 10:42 PM
тАО01-10-2005 10:42 PM
Re: DBWR crashing with ORA-7404 on HP-UX
reduce the number of writers and/or split the transaction into smaller sections.
Also consider upgrading to get Oracle Support
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-11-2005 02:33 AM
тАО01-11-2005 02:33 AM
Re: DBWR crashing with ORA-7404 on HP-UX
I have talk to them & they said nobody modified the db_writers value... The bad side is the system is very critical system & we couldn't have a choice to try reducing the db_writers value...
I have talk to HP as well & they are saying it could be something on the kernel size...
any more suggestion???
Thank you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-11-2005 10:38 PM
тАО01-11-2005 10:38 PM
Re: DBWR crashing with ORA-7404 on HP-UX
Can I have the exact value of the MAXSIZ, MAXUPRC & MAXUSERS for my 7.3.4 database on hp-ux 10.2???
Tq