This content has been marked as final. Show 5 replies
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_dbw0_11087.trc:
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: '/u01/app/oracle/orcl/example01.dbf'
ORA-27086: unable to lock file - already in use
Linux Error: 11: Resource temporarily unavailable
Additional information: 8
Additional information: 10950
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_11152.trc:
ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
ORA-01110: data file 2: '/u01/app/oracle/orcl/sysaux01.dbf'
ORA-1157 signalled during: ALTER DATABASE OPEN...
I think you have already lot of questions. Besides update output of the below query also
Shutdown completely, again startup in "MOUNT" status and then
SQL> select file#, name,status,error,fuzzy from v$datafile_header;and
$ls -ltr /u01/app/oracle/orcl/