- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Error while extending table space
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
тАО06-20-2005 07:14 PM
тАО06-20-2005 07:14 PM
When I was extending tablespace, i got an error :
ALTER DATABASE DATAFILE '/u01/oradata/rman/cat1rman.dbf' RESIZE 500m
*
ERROR at line 1:
ORA-01237: cannot extend datafile 8
ORA-01110: data file 8: '/u01/oradata/rman/cat1rman.dbf'
ORA-19502: write error on file "/u01/oradata/rman/cat1rman.dbf", blockno
53395
(blocksize=6144)
ORA-27072: skgfdisp: I/O error
Additional information: 53395
Please help me to resolve problem. I need to solve asap.
Thanks for your help
Best regards,
Otong
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-20-2005 07:24 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-20-2005 07:28 PM
тАО06-20-2005 07:28 PM
Re: Error while extending table space
You need to check on the disk where the database sit-on, looks like there's an issue in there based on (ORA-19502 & ORA-27072). Check the syslog.log, event.log & use dd to check the disk or STM to see the growing defect-list.
Backup is the good plan also on this situation.
Cheers,
AW
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-20-2005 08:24 PM
тАО06-20-2005 08:24 PM
Re: Error while extending table space
To check space on /u01, do:
#bdf /u01
To check where the used space is, execute:
#du -k /u01|more
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-20-2005 08:37 PM
тАО06-20-2005 08:37 PM
Re: Error while extending table space
ORA-01237: cannot extend datafile 8
ORA-01110: data file 8: '/u01/oradata/rman/cat1rman.dbf'
ORA-19502: write error on file "/u01/oradata/rman/cat1rman.dbf", blockno 53395
(blocksize=6144)
ORA-27072: skgfdisp: I/O error
The above errors could be due to the following reasons. As the other posts mentioned, it could be due to
1. Due to lack of available disk space on the hard drive. Increase space available on hard drive.
2. The default location rman writes to, $oracle_home/dbs, is full. You can free up space in the default location
3. When creating a data file and if you are using raw device, ensure that the data file is smaller than the size of the raw device. If you have a 100 MB raw partition, do not allocate a data file of 100 MB. Instead allocate a datafile of 100 MB - 1 MB; 99 MB. The rule of thumb is to leave 1MB unused. Following this rule ensures that you will not write over cylinder 0 of the disk.
4. Iif it is a file io error then add the following parameter to your init
disk_asynch_io = false
Explanation : ├в DISK_ASYNCH_IO can be used to control whether I/O to datafiles, controlfiles and logfiles are asynchronous. If a platform supports asynchronous I/O to disk, it is recommended that this parameter is left to its default. However, if the asynchronous I/O implementation is not stable, this parameter can be set to FALSE to disable asynchronous I/O. If a platform does not support asynchronous I/O to disk, this parameter has no effect."
Indir
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-21-2005 04:01 AM
тАО06-21-2005 04:01 AM
Re: Error while extending table space
in case you cannot extend due to diskspace problem on that file system, you can also add another datafile(from another file system of course) to that same tablespace.
hope this helps!
regards
yogeeraj