Thursday, April 5, 2012

Resolving Error ORA-01115, ORA-01110 and ORA-15081 connecting Database

If you are getting error ORA-01115, ORA-01110 and ORA-15081 after you connected to a database or while connecting to the database accessing header of SQL as mentioned below.

SQL*Plus: Release 11.2.0.2.0 Production on Mon April 5 17:01:10 2012Copyright (c) 1982, 2010, Oracle. All rights reserved.Connected to:



Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production


With the Partitioning, Real Application Clusters and Automatic Storage Management

SQL> select * from v$instance;


select * from v$instance
*


ERROR at line 1:


ORA-01115: IO error reading block from file (block # )
ORA-01110: data file 1: '+DATA/test/datafile/system.dbf'ORA-15081: failed to submit an I/O operation to a disk

The real cause of this above error is nothing else but just because you might be trying to connect with the user which doesn't belong to dba, oper, asmadmin, etc operating system group.

To correct this error just you can assign the o/s user to an appropriate group and it will get resolved.

Hope this will help you and please give your feedback/comments about our blog which helps us in improving it.

7 comments:

  1. Dear Author,
    Here is one kind of error which brings your mentioned errors also.

    Kindly explain me what is the cause,, is it the same cause of user or some thing else we have to check ?!?

    REP-0451 : Unhandled exception ORA-01115: IO error reading block from file 77 (block# 34758)
    ORA-01110: data file 77: 'location of db file /file08.dbf'
    ORA-07373:swhich was raised in a statement starting at line 1 of XGL_LOAD_DAT_FOR_BPRC, called statement starting at line 116 of AFTERPFORM.

    ReplyDelete
  2. Hello Abdul,

    I believe you are receiving this error in Oracle Reports. I would highly appreciate if you can share XGL_LOAD_DAT_FOR_BPRC because we need to understand that was the statement in it which caused this for you.

    As you can see that you have IO Error as well as db file it can be block corruption as well which we aren't sure until we see XGL_LOAD_DAT_FOR_BPRC.

    ReplyDelete
  3. Abdul,

    Also do let us know if there is any O/S or Oracle level patches applied on the server.

    Thanks,
    Bhavik

    ReplyDelete
  4. Abdul,

    Also do let us know if there is any O/S or Oracle level patches applied on the server.

    Thanks,
    ingress

    ReplyDelete
  5. sorry for my late reply,, [4 months old].

    There is no patches applied on this server,, its a old Oracle finance 6 server with the database of 7

    I will post the remaining parts.. thank u again,,

    ReplyDelete
  6. I'm running into the same error, but the OS groups assignment didn't solve it.
    The user is a member of all the groups where "oracle" user is a member: dba oper dgdba kmdba asmdba asmoper asmadmin

    I still get the:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-01115: IO error reading block from file (block # )
    ORA-01110: data file 1: '+DATA/sfpr01/datafile/system.399.829185907'
    ORA-15081: failed to submit an I/O operation to a disk

    Any other suggestions?

    Thanks!
    OT

    ReplyDelete
    Replies
    1. Was it working earlier or its just a fresh server? Also can you please check the permission on the asm disk that you have created and share the alert log file so that we can analyse the same and help you out.

      Delete