dumps due to ORA: 01116

[Former Member]

HELLO,

We are getting too many dumps in ECC system "DBIF__RSQL_SQL_ERROR"

Please find the log

How to correct the error

    Database error text........: "ORA-01116: error in opening database file

     83#ORA-01110: data file 83: '/oracle/SID/sapdata12/sr3_67/sr3.data67'#ORA-2704

    1: unable to open file#Linux-x86_64 Error: 13: Permission denied#Additional

     information: 3"

    Internal call code.........: "[RSQL/FTCH/MARM ]"

    Please check the entries in the system log (Transaction SM21).

Regards,

uday

[Reagan]

Stop the SAP system and correct the permission/ownership of all the datafiles under the /oracle/SID/sapdata* file systems. Make sure the files have orasid:dba ownership.

Start the database and SAP

Regards

RB

[Former Member]

Hi,

As per your question & dump arises may be few things happen-:

1.) Please check permission of all datafiles at OS Level.

2.)Please check sm21 Log .

3.) Please check any datafile may be missing or deleted.

4.) check alert &  trace log of oracle in path /oracle/SID/saptrace.../...

Please check the following points hope this will resolve issue.

get back if u require further assistance.

[Former Member]

Hi,

As per our colleague, the dumps are due to permission change to some files as per CERT.

Can some one throw some light on this!

Thanks,

uday

[Sriram2009]

Hi Udaya

Could you check this SAP Note

546006 - Problems with Oracle due to operating system errors

605859 - SAPDBA: Check/repair database - Fatal error during shutdown

BR

SS