Home » RDBMS Server » Server Administration » ORA-27072 error on solaris(oracle ver 8.0.5.2) & Bug 774252
ORA-27072 error on solaris(oracle ver 8.0.5.2) & Bug 774252 [message #54565] Thu, 21 November 2002 14:47 Go to next message
Niraikalai Vijay
Messages: 9
Registered: November 2002
Junior Member
Hi,

I have been getting ORA-27072 error lately after resizing my tablespace to 1.1GB. I submitted message in Oracle metalink forum and came to know that I need to install a patch for Oracle version 8.0.5.2. But this patch only available for those having support license.
Currently I don't have one. I like to know whether any of you know how to resolve this issue.

The error text

. . exporting table SITE07
EXP-00056: ORACLE error 1115 encountered
ORA-01115: IO error reading block from file 4 (block # 262144)
ORA-01110: data file 4: '/homes/antaeus1/app/oradata/awp1/usr01.dbf'
ORA-27072: skgfdisp: I/O error
SVR4 Error: 25: Inappropriate ioctl for device
Additional information: 262143
. . exporting table SITE08 9809 rows exported

Any help on this will be really appreciated.

Thanks,
Niraikalai

Report message to a moderator

Re: ORA-27072 error on solaris(oracle ver 8.0.5.2) & Bug 774252 [message #54578 is a reply to message #54565] Fri, 22 November 2002 06:45 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
 
look into the block number being reported ( in your case it is 262144)
now multiply 262144 * your DB_BLOCK_SIZE.
if it is showin less than 2GB, then it is a reported bug.
you have to open an TAR.

Report message to a moderator

Previous Topic: increasing RBS
Next Topic: My database slowdown after 1 week...!!!!! Urgent
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 19:48:04 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.