- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- file size is not a multiple of logical block size
Operating System - HP-UX
1753479
Members
5206
Online
108794
Solutions
Forums
Categories
Company
Local Language
юдл
back
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
юдл
back
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
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Topic Options
- 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
тАО08-30-2002 10:10 AM
тАО08-30-2002 10:10 AM
file size is not a multiple of logical block size
Hi all,
We I try to open the ORACLE 8.1.7.3 database, I get the following error.
ORA-01110: data file 1: '/u03/oradata/asmsdb/system01.dbf'
ORA-27046: file size is not a multiple of logical block size
DB_BLOCK_SIZE is 8192
Please help
Thanks
We I try to open the ORACLE 8.1.7.3 database, I get the following error.
ORA-01110: data file 1: '/u03/oradata/asmsdb/system01.dbf'
ORA-27046: file size is not a multiple of logical block size
DB_BLOCK_SIZE is 8192
Please help
Thanks
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-30-2002 10:31 AM
тАО08-30-2002 10:31 AM
Re: file size is not a multiple of logical block size
Well, the first question is: Is it? Do an ls -l /u03/oradata/asmsdb/system01.dbf; it's possible that the file has been corruptted by someone appending to it or other commands.
If it ain't broke, I can fix that.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-30-2002 10:35 AM
тАО08-30-2002 10:35 AM
Re: file size is not a multiple of logical block size
By any chance, did you change the db_block_size paramter in init.ora?
If it ain't broke, I can fix that.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-30-2002 03:58 PM
тАО08-30-2002 03:58 PM
Re: file size is not a multiple of logical block size
Hi Sushil,
verify in your ALERT.LOG, that the DB_BLOCK_SIZE in your "init*ora" is really still the same as it was last time the instance was successfully started. A simple "grep -i db_block_size" onto your ALERT.LOG should be sufficient.
If both are the same, then somebody damaged your datafile - restore from your backup, then.
If they are different, then somebody damaged your "init*ora" file - use the value from the ALERT.LOG, then.
HTH,
Wodisch
verify in your ALERT.LOG, that the DB_BLOCK_SIZE in your "init*ora" is really still the same as it was last time the instance was successfully started. A simple "grep -i db_block_size" onto your ALERT.LOG should be sufficient.
If both are the same, then somebody damaged your datafile - restore from your backup, then.
If they are different, then somebody damaged your "init*ora" file - use the value from the ALERT.LOG, then.
HTH,
Wodisch
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP