Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

The Oracle instance I am working with is not coming up after issuing a startup. All I get is the following:

SQL> startup
ORACLE instance started.

Total System Global Area 1.2300E+10 bytes
Fixed Size                  2263088 bytes
Variable Size            1.002E+10 bytes
Database Buffers         3018334336 bytes
Redo Buffers               48056256 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 5038
Session ID: 221 Serial number: 3

For ORA-03113: there shouldn't be any network issues, as this session is logged as sysdba on the machine. And this instance has been working for over two months with no problems.

The oracle service is also running and was able to restart.

Environment: Windows 2008 Enterprise SP1, Oracle 11g R2.

I'd really appreciate any direction and help you could offer to troubleshoot and resolve this issue.


Here are the details from alerts.log:

KCF: read, write or open error, block=0xf0412 online=1
        file=25 'C:\ORADATAFILES\ORAPROD03\USERS03.DBF'
        error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 665) The requested operation could not be completed due to a file system limitation'
Errors in file C:\ORACLE\diag\rdbms\ORAPROD03\ORAPROD03\trace\ORAPROD03_dbw1_224.trc:
Errors in file C:\ORACLE\diag\rdbms\ORAPROD03\ORAPROD03\trace\ORAPROD03_dbw1_224.trc:
ORA-63999: data file suffered media failure
ORA-01114: IO error writing block to file 25 (block # 984082)
ORA-01110: data file 25: 'C:\ORADATAFILES\ORAPROD03\USERS03.DBF'
ORA-27072: File I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 665) The requested operation could not be completed due to a file system limitation
Sun Aug 19 10:26:42 2012
KCF: read, write or open error, block=0xf04e2 online=1
        file=25 'C:\ORADATAFILES\ORAPROD03\USERS03.DBF'
        error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 665) The requested operation could not be completed due to a file system limitation'
Errors in file C:\ORACLE\diag\rdbms\ORAPROD03\ORAPROD03\trace\ORAPROD03_dbw0_5624.trc:
DBW1 (ospiC: 224): terminating the instance due to error 63999

trace file has this error message:

ORA-00449: background process 'DBW1' unexpectedly terminated with error 63999

Now, I understand that the USER03.DBF data file is somehow inaccessable. But the permissions on the file are "Full Modify" and nothing else is accessing this specific file, like a backup software or antivirus; this is a dedicated oracle box.

Given the the file is not being able to be read or write from, what are my options? The file size is 27GB, but size on disk is 4GB; I am not sure if this is of any significance. And disk is definatly not out of space.

Autoextend is set at 100MB. And database is about 150GB. Within alerts.log, there were over 50 autoextend notes before the corrupt block error showed up.

share|improve this question
1  
Have you checked the alert log for the database? –  DCookie Aug 19 '12 at 4:33
    
I agree with DCookie - you need to check the alert log. –  APC Aug 19 '12 at 8:44
    
But just to be clear: are you saying you got this error while connecting to the database in a local session, that is +on the database server+ itself? Because that seems unlikely. –  APC Aug 19 '12 at 8:46
    
@apc: yes, it is on the database server. dcookie: I will go over the alerts.log and post what I discover. –  lvchalla Aug 19 '12 at 12:32
    
Extreme file fragmentation could be an issue (blogs.technet.com/b/mikelag/archive/2011/02/09/…), though that seems to be reported for Exchange & SQL Server. Did you have a very low autoextend size on that datafile? –  Mat Aug 19 '12 at 18:48
show 1 more comment

migrated from stackoverflow.com Aug 19 '12 at 9:19

This question came from our site for professional and enthusiast programmers.

2 Answers

O/S-Error: (OS 665) The requested operation could
  not be completed due to a file system limitation

So the windows error 665 is the reason for the error an the error refers to file C:\ORADATAFILES\ORAPROD03\USERS03.DBF.What is the problem with the file? The following article discusses this error message: What factors can lead to Win32 error 665 (file system limitation)?. If the reason is file fragmentation a patch is available. I know it is to late but maybe a restore will not be necessary in this situation.

share|improve this answer
add comment

Well, the data file couldn't be recovered.

So we restored to the most recent (consistent) backup. That's our solution.

share|improve this answer
    
You should immediately take a backup now and is your database in archive log mode? –  steve Aug 23 '12 at 4:07
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.