- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: I/O error
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-08-2005 12:47 AM
тАО04-08-2005 12:47 AM
I/O error
I need a help on following things..
Daily the server DB is going down.. Following are error..
KCF: write/open error block=0x3d2a online=1
file=159 /oradata/u005/ACCDW/ACCDW_gcldm_idx_04.dbf
error=27072 txt: 'HP-UX Error: 14: Bad address
Additional information: 15658'
Fri Apr 8 14:21:13 2005
Errors in file /oracle/admin/ACCDW/bdump/dbw0_8850_accdw.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01114: IO error writing block to file 159 (block # 15658)
ORA-01110: data file 159: '/oradata/u005/ACCDW/ACCDW_gcldm_idx_04.dbf'
ORA-27072: skgfdisp: I/O error
HP-UX Error: 14: Bad address
Additional information: 15658
DBW0: terminating instance due to error 1242
And oracle corresponding dsikd are not giving any I/O error while checking with dd command.
Help me !
With Regards,
Shankar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-08-2005 12:50 AM
тАО04-08-2005 12:50 AM
Re: I/O error
For all disks which is releated to oracle giving the following outputs in dd
dd if=/dev/rdsk/c0t2d0 of=/dev/null bs=2048 count=1000
1000+0 records in
1000+0 records out
Shankar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-08-2005 12:55 AM
тАО04-08-2005 12:55 AM
Re: I/O error
Could it be permission problem on the mountpoints or a largefiles problem on the filesystems?
Regards,
Robert-Jan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-08-2005 12:55 AM
тАО04-08-2005 12:55 AM
Re: I/O error
the problem is proably no the reading, but the writing!
Is there any additional info in the trc file?
I would say you have a fault block/disk.
See metalink for rescuing/moving the good data.
May be worthwhile looking at a new disk!
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-08-2005 01:07 AM
тАО04-08-2005 01:07 AM
Re: I/O error
It appears to be a disk problem. That is why it is giving you a write error. Which disks are u using? starage or what? Are alternate paths available to the disk?
Moreover your dd is not checking the complete disk for reading.
HTH,
Devender
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-08-2005 04:10 PM
тАО04-08-2005 04:10 PM
Re: I/O error
But i need further more info on this..
Shankar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-09-2005 12:20 PM
тАО04-09-2005 12:20 PM
Re: I/O error
dd if=/dev/rdsk/c0t2d0 of=/dev/null bs=128k
And look in syslog (/var/adm/syslog/syslog.log). The errors will be timestamped so look at syslog at Fri Apr 8 14:21:13 2005.
Note that the bad address error may be due to using lvreduce. lvreduce knows nothing about filesystems and without the very latest version of HP-UX, the very latest LVM and VxFS pathes and the priced-product Online JFS, you cannot reduce a filesystem with destroying the data. Using lvreduce on a filesystem means that the directory will provide an address to the VxFS filesystem that no longer exists.
Bill Hassell, sysadmin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-10-2005 01:38 PM
тАО04-10-2005 01:38 PM
Re: I/O error
In case of KCF: write/open errors, error code and additional information is the most important part. Check and verify to see if it is a Disk problem first. If the Harddisk is fine, then it could be the oracle data file have problme while writing to it. The File suffered media failure and there is some I/O error in writing to the datafile as seen in the aler.log.
This could had been caused because the file was locked by some backup process, and so the database opened failed. Make sure that the backup window does not exceed and does not clash with the DB open time. Online backup is recommended, to avoid these problems
If the datafile has become unusable then it either needs to be recovered or dropped. It depends on the type of data that is on the tablespace (data file).
If the datafile is dropped all data in it will be lost. But if you have a logical backup, then one of the solutions will be :- You have to turn the tablespace offline in order to issue an alter database open and then you should be able to drop the tablespace (datafile), recreate the tablespace with new datafile sizes, recover the data from my logic backup (via imp utility)
The other solution will be to recover in point in time before the problem occurred from a good backup
In general If the Media recovery is required then
restore the old backup of the datafile
recover the datafile/tablespace
For error ├в 'HP-UX Error: 14: Bad address├в , there is a BUG. BUG 1533290 ├в Aynch read/write failed├в This is if the RDBMS release is Oracle Server - Enterprise Edition 8.1.7.0 and OS is HP-UX 11.0The fix or a workaround for this bug is to set the parameter DISK_ASYNCH_IO to FALSE and install HP-UX patch PHKL_22126
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-11-2005 01:22 AM
тАО04-11-2005 01:22 AM
Re: I/O error
I'm getting some log in syslog..
Is releted to DB ?
Apr 8 21:25:30 suboz032 vmunix: WARNING: ioctl: DLKM is not initialized
Apr 8 21:25:30 suboz032 vmunix: WARNING: ioctl: DLKM is not initialized
Mean while i am checking all disks releted to DB
Shankar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-11-2005 02:03 AM
тАО04-11-2005 02:03 AM
Re: I/O error
What does, following say??
echo "mod_initialized/D" | adb =k /stand/vmunix /dev/kmem
If it says 0, you will have to recompile the kernel again.
Anil