Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

12.2.0.1.0 getting "OSD-04011: GetFileInformationByHandle() failure, unable to obtain file info"

Ric Van DykeMay 24 2017 — edited May 24 2017

I just installed Oracle Enterprise 12.2.0.1.0 on my Lenovo Laptop (Windows 7 professional, 64Bit, 8G Ram, 2 dual core i5-2520M CPUs).  I did a default install with database creation using a virtual user, I am not using ASM.  I'm getting "OSD-04011: GetFileInformationByHandle() failure, unable to obtain file info" errors constantly.   The database seems to be working fine, although I haven't done a lot with it as I'd like to figure out what this error is all about and fix that before I get rolling.

My searching on this error here and elsewhere seem to turn up little and all the hits appear to years old and also always mention ASM which I'm not using.   As far as I can tell from looking at file permissions, none appear to have any restrictions limiting access to any of the users on my laptop.

I'm assuming there is something simple I've missed either in the install or the file system.  Any help would be greatly appreciated. Thanks for looking.

Example from the alert log:

2017-05-24T09:29:53.535478-04:00

Errors in file C:\APP\RVANDYKE\VIRTUAL\diag\rdbms\hotsos12\hotsos12\trace\hotsos12_mmnl_7960.trc:

ORA-27037: unable to obtain file status

OSD-04011: GetFileInformationByHandle() failure, unable to obtain file info

O/S-Error: (OS 5) Access is denied.

2017-05-24T09:31:31.099058-04:00

Errors in file C:\APP\RVANDYKE\VIRTUAL\diag\rdbms\hotsos12\hotsos12\trace\hotsos12_m000_9672.trc:

ORA-27037: unable to obtain file status

OSD-04011: GetFileInformationByHandle() failure, unable to obtain file info

O/S-Error: (OS 5) Access is denied.

A mentioned trace file will look something like this. It seems to happen for any database file, this on happens to be the temp tablespace file:

Trace file C:\APP\RVANDYKE\VIRTUAL\diag\rdbms\hotsos12\hotsos12\trace\hotsos12_m000_9672.trc

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

Build label:    RDBMS_12.2.0.1.0_WINDOWS.X64_170210.4

Windows NT Version V6.1 Service Pack 1

ORACLE_HOME =  C:\app\rvandyke\virtual\product\12.2.0\dbhome_1

Node name           : RVANDYKE05

CPU                 : 4 - type 8664, 2 Physical Cores

Process Affinity    : 0x0x0000000000000000

Memory (Avail/Total):

Instance name: hotsos12

Redo thread mounted by this instance: 1

Oracle process number: 49

Windows thread id: 9672, image: ORACLE.EXE (M000)

*** 2017-05-24T09:31:31.099058-04:00

*** SESSION ID:(132.21603) 2017-05-24T09:31:31.099058-04:00

*** CLIENT ID:() 2017-05-24T09:31:31.099058-04:00

*** SERVICE NAME:(SYS$BACKGROUND) 2017-05-24T09:31:31.099058-04:00

*** MODULE NAME:(MMON_SLAVE) 2017-05-24T09:31:31.099058-04:00

*** ACTION NAME:(Monitor Tablespace Thresholds) 2017-05-24T09:31:31.099058-04:00

*** CLIENT DRIVER:() 2017-05-24T09:31:31.099058-04:00

Error in computing freespace for file 000000001498BFE0 C:\APP\RVANDYKE\VIRTUAL\ORADATA\HOTSOS12\TEMP01.DBF

ORA-27037: unable to obtain file status

OSD-04011: GetFileInformationByHandle() failure, unable to obtain file info

O/S-Error: (OS 5) Access is denied.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 21 2017
Added on May 24 2017
15 comments
3,499 views