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 ONE Support launchpad (Login required).

Search for additional results

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