- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: ORA-01110, 01115, 27072 during database startu...
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
тАО02-09-2003 10:08 PM
тАО02-09-2003 10:08 PM
ORA-01110, 01115, 27072 during database startup
Oracle ver. 8.0.5
OS - HP UX 11.0
I did a database cloning from my development server to another server..Both the platforms are identical.
The cloning was successful. Then suddenly after 3-4 hrs the database shutdown abnormally..I checked the alertlog and found the above ORA- errors. All these errors were pointing to datafiles in filesystems mounted on the same volume group VG03.
Last week we had the same problem so we thought that the disk is the problem and replaced the disk and did the cloning process.
We don't have LTO on destination server thats why we did NFS and copied the offline files using CPIO.
I thought it might be because of largefiles disabled but then the files which we were corrupt were of varying sizes 150 mb to 2 GB. And there are other files which are of 2 GB on the same filesystem which don't have this problem.
Anybody has any clues?
rgds
nainesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-09-2003 10:39 PM
тАО02-09-2003 10:39 PM
Re: ORA-01110, 01115, 27072 during database startup
I/O problems.
check the /var/adm/syslog/syslog.log for further messages on the same.
REvert with those messages
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-09-2003 10:55 PM
тАО02-09-2003 10:55 PM
Re: ORA-01110, 01115, 27072 during database startup
It seems to be Bug 774252 which is fixed in 8.0.6.0 and 8.1.5:
<774252>
: ORA-27072 scanning across a 2Gb offset in a file
To determine if this is the problem that you are hitting we need to look at the
block number being reported with the ORA-01115 error. If this is multiplied by
the DB_BLOCK_SIZE and we are on the 2GB boundary.
Chris
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-09-2003 10:56 PM
тАО02-09-2003 10:56 PM
Re: ORA-01110, 01115, 27072 during database startup
Done that...no error messages..This disk resides in a Hash box..we faced the same problem last week so we replaced it with a new disk..Funny thing is only some files are getting corrupted..
The filesystems on these vg are mounted and i can access them and even create some files in it..
We are trying to figure out if it could be the disk cage that is causing a problem..
rgds
nainesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-09-2003 11:06 PM
тАО02-09-2003 11:06 PM
Re: ORA-01110, 01115, 27072 during database startup
ORA-01110: data file 59: '/oracle/D02/sapdata8/protd_2/protd.data2'
ORA-01114: IO error writing block to file 59 (block # 1)
ORA-27072: skgfdisp: I/O error
Filesize is not the problem..
If the bug was the problem then it should corrupt my other 2GB files residing on same filesystem as well as other filesystems..
rgds
nainesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-09-2003 11:14 PM
тАО02-09-2003 11:14 PM
Re: ORA-01110, 01115, 27072 during database startup
YOu should have permissions 660 on the datafiles.
check the attachment
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-09-2003 11:26 PM
тАО02-09-2003 11:26 PM
Re: ORA-01110, 01115, 27072 during database startup
The permissions and ownership are okay..no problem with that..rw-rw---- for all files..
rgds
nainesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-09-2003 11:29 PM
тАО02-09-2003 11:29 PM
Re: ORA-01110, 01115, 27072 during database startup
Please post your logfile
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-09-2003 11:32 PM
тАО02-09-2003 11:32 PM
Re: ORA-01110, 01115, 27072 during database startup
1.permissions of the datafile(which is okay with your env)
2.Free space on the file system
Can the file system accomodate that file into that(sufficient amount of free space)
Revert
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-09-2003 11:40 PM
тАО02-09-2003 11:40 PM
Re: ORA-01110, 01115, 27072 during database startup
My error: Bug 774252 is only reported for SOlaris
nevertheless:
Note:49946.1
Note:62427.1
Note:62407.1
BUG: 749600
said that certain 'core' functions in Oracle and it's tools do not support large files (>2GB) and shows your errors (especially in 8.0.5 but even in 8.1.5).
So this errors may not arise continuously and on all datafiles greater than 2 GB.
Hint:
- not to use files larger than 2 GB
- Upgrade to 9.x
Note this:
11.0 8.0.5 64-bit Desupported
11.0 8.0.5 Desupported
Chris