- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- IO error writing block to file
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-28-2007 11:53 PM
тАО01-28-2007 11:53 PM
Errors in file /oracle/PRD/saptrace/usertrace/prd_ora_27240.trc:
ORA-01114: IO error writing block to file 1025 (block # 137225)
ORA-27072: skgfdisp: I/O error
Additional information: 137225
Here's the "ls -l" of the the file:
-rw-rw---- 1 oraprd dba 117089131 Jan 25 03:41 /oracle/PRD/saptrace/usertrace/prd_ora_27240.trc
Here's what bdf shows:
8388608 7537800 824600 90% /oracle/PRD
I've searched both Oracle and HP sites, but could not find anything related. I'd appreciate your input/opinion on the cause and any pointers on how to go about rectifying this condition.
Thank you.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-29-2007 12:08 AM
тАО01-29-2007 12:08 AM
SolutionIt appears to be disk related, maybe one of your harddisk is failing or about to fail. Check /var/adm/syslog.log, and also run
dmesg command, and see if there is any trouble with your hardware, also run an
ioscan -fnC disk.
I also found this.
ORA-01114: IO error writing block to file string (block # string)
Cause: The device on which the file resides is probably offline. If the file is a temporary file, then it is also possible that the device has run out of space. This could happen because disk space of temporary files is not necessarily allocated at file creation time.
Action: Restore access to the device or remove unnecessary files to free up space.
And check this site for more info.
http://www.experts-exchange.com/Databases/Oracle/Q_20075060.html
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-29-2007 12:14 AM
тАО01-29-2007 12:14 AM
Re: IO error writing block to file
normally there is a OS error code associated shown.
In your case I would guess, either at a faulty block on the disk, a temporary full file system or a full tablespace/temp datafile.
Please check via:
select * from v$tablespace;
select * from dba_temp_files;
select * from dba_data_files;
Please also read:
http://forums1.itrc.hp.com/service/forums/helptips.do?#33 on how to reward any useful answers given to your questions.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-29-2007 12:49 AM
тАО01-29-2007 12:49 AM
Re: IO error writing block to file
The problem is solved. I have assigned points to both of you. Thanks again Fabian and Peter.
Sincerely,
Man Dinh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-29-2007 12:50 AM
тАО01-29-2007 12:50 AM