Ora-1157 ora-1110错误解决案例一枚

1、数据库打开报错如下:

SQL> alter database open;

alter database open

*

ERROR at line 1:

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

ORA-01110: data file 4: '/weblogic/oradata/orcl/users01.dbf'

2、查看告警日志,同样报错:

Thu Nov 10 17:58:14 2016

alter database open

Thu Nov 10 17:58:14 2016

Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_dbw0_22383.trc:

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

ORA-01110: data file 4: '/weblogic/oradata/orcl/users01.dbf'

ORA-27041: unable to open file

Linux-x86_64 Error: 13: Permission denied

Additional information: 9

Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_dbw0_22383.trc:

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

ORA-01110: data file 5: '/weblogic/oradata/orcl/users02.dbf'

ORA-27041: unable to open file

Linux-x86_64 Error: 13: Permission denied

Additional information: 9

Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_24033.trc:

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

ORA-01110: data file 4: '/weblogic/oradata/orcl/users01.dbf'

ORA-1157 signalled during: alter database open...

3、因为报错linux错误,所以查看具体的数据文件权限,发现数据文件权限都变成了weblogic:

[root@slave1 weblogic]# ll

total 24

drwx------. 2 weblogic weblogic 16384 May  6  2016 lost+found

drwxrwxr-x. 3 weblogic weblogic  4096 May  6  2016 Oracle

drwxr-xr-x. 3weblogic weblogic  4096 Aug 16 10:20 oradata

4、修改数据文件权限:

[root@slave1 weblogic]# chown -R oracle:oinstall  Oracle/

[root@slave1 weblogic]# chown -R oracle:oinstall  oradata/

[root@slave1 weblogic]# ll

total 24

drwx------. 2 weblogic weblogic 16384 May  6  2016 lost+found

drwxrwxr-x. 3 oracle   oinstall  4096 May  6  2016 Oracle

drwxr-xr-x. 3 oracle   oinstall  4096 Aug 16 10:20 oradata

5、成功打开数据库,告警日志也没有再次报错:

SQL> alter database open;

Database altered.

原文地址:https://www.cnblogs.com/wcwen1990/p/6656785.html