SAP Knowledge Base Article - Preview

2858093 - ORA-01157 ORA-01110 when adding resource - NetWeaver

Symptom

When you are adding resource to cluster in Oracle Fail Safe environment, you are getting error ORA-01157 and ORA-01110:

ORA-01157: cannot identify/lock data file 3 - see DBWR trace file

ORA-01110: data file 3: '<file_name>'

Then you check Oracle alert log, you found error:

ORA-51106: check failed to complete due to an error.  See error below

ORA-48223: Interrupt Requested - Fetch Aborted - Return Code [448] [HM_FINDING]

ORA-27041: unable to open file

OSD-04002: unable to open file

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

ORA-01122: database file 246 failed verification check

ORA-01110: data file 246: 'I:\ORACLE\<SID>\SAPDATA1\SYSAUX_2\SYSAUX.DATA2'

ORA-01565: error in identifying file 'I:\ORACLE\<SID>\SAPDATA1\SYSAUX_2\SYSAUX.DATA2'

ORA-27041: unable to open file

OSD-04002: unable to open file

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

 


Read more...

Environment

Oracle

Keywords

 ORA-01157,ORA-01110,ORA-51106,ORA-48223,ORA-27041,OSD-04002,ORA-01122,ORA-01565,Access is denied , KBA , BC-DB-ORA , Oracle , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.