Symptom
Oracle cannot open database and errors like following ones are displayed in alert log:
ALTER DATABASE OPEN
SUCCESS: diskgroup DATA was mounted
Errors in file /oracle/<SID>/saptrace/diag/rdbms/<sid>/<SID>/trace/<SID>_dbw0_XXXXXXXX.trc:
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '+DATA/<sid>/datafile/system.XXX.XXXXXXXXX'
ORA-17503: ksfdopn:2 Failed to open file
+DATA/<sid>/datafile/system.XXX.XXXXXXXXX
ORA-15260: permission denied on ASM disk group
Errors in file /oracle/<SID>/saptrace/diag/rdbms/<sid>/<SID>/trace/<SID>_dbw0_XXXXXXXX.trc
Read more...
Environment
- SAP systems with Oracle database and ASM used. It can be a RAC installation or not
- Not restricted to a SAP product or SAP product version
Keywords
Oracle, ASM, Oracle_RAC, ORA-01157, ORA-01110, ORA-17503, +DATA, ORA-15260, start, database open, permission, attribute , KBA , BC-DB-ORA , Oracle , BC-DB-ORA-RAC , Real Application Clusters (RAC) , Problem
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.