Oracle启动报错ORA-01114，ORA-01110，ORA-27091，ORA-27041解决方法之一

最新推荐文章于 2024-08-20 20:35:11 发布

uc5152534

最新推荐文章于 2024-08-20 20:35:11 发布

阅读量1.1k

点赞数

文章标签： oracle sql

本文链接：https://blog.csdn.net/uc5152534/article/details/120183887

版权

SQL> startup
ORACLE instance started.

Total System Global Area 521936896 bytes
Fixed Size 2214936 bytes
Variable Size 348128232 bytes
Database Buffers 167772160 bytes
Redo Buffers 3821568 bytes
Database mounted.

ORA-01114: IO error writing block to file 1 (block # 1)
ORA-01110: data file 1: ‘/u01/oradata/prod/system01.dbf’
ORA-27091: unable to queue I/O
ORA-27041: unable to open file
Linux-x86_64 Error: 13: Permission denied
Additional information: 3

最初查看文件所属的用户，发现错误：
[oracle@bjcuug prod]$ ll
total 1613684
-rw-r----- 1 775 oinstall 9748480 Sep 6 18:01 control01.ctl
drwxr-xr-x 2 775 oinstall 4096 Sep 6 17:27 disk3
-rw-r----- 1 775 oinstall 104865792 Sep 6 17:26 example01.dbf
-rw-r----- 1 775 oinstall 52429312 Sep 6 18:01 redo01.log
-rw-r----- 1 775 oinstall 52429312 Sep 6 17:26 redo02.log
-rw-r----- 1 775 oinstall 52429312 Sep 6 17:56 redo03.log
-rw-r----- 1 775 oinstall 534781952 Sep 6 18:01 sysaux01.dbf
-rw-r----- 1 775 oinstall 713039872 Sep 6 18:01 system01.dbf
-rw-r----- 1 775 oinstall 30416896 Sep 6 17:27 temp01.dbf
-rw-r----- 1 775 oinstall 104865792 Sep 6 18:01 undotbs01.dbf
-rw-r----- 1 775 oinstall 5251072 Sep 6 17:26 users01.dbf
更改：
[root@bjcuug oradata]# chown -R oracle:oinstall prod/

[root@bjcuug prod]# ll
total 1613684
-rw-r----- 1 oracle oinstall 9748480 Sep 8 16:49 control01.ctl
drwxr-xr-x 2 oracle oinstall 4096 Sep 6 17:27 disk3
-rw-r----- 1 oracle oinstall 104865792 Sep 6 17:26 example01.dbf
-rw-r----- 1 oracle oinstall 52429312 Sep 6 18:01 redo01.log
-rw-r----- 1 oracle oinstall 52429312 Sep 6 17:26 redo02.log
-rw-r----- 1 oracle oinstall 52429312 Sep 6 17:56 redo03.log
-rw-r----- 1 oracle oinstall 534781952 Sep 6 18:01 sysaux01.dbf
-rw-r----- 1 oracle oinstall 713039872 Sep 6 18:01 system01.dbf
-rw-r----- 1 oracle oinstall 30416896 Sep 6 17:27 temp01.dbf
-rw-r----- 1 oracle oinstall 104865792 Sep 6 18:01 undotbs01.dbf
-rw-r----- 1 oracle oinstall 5251072 Sep 6 17:26 users01.dbf

再次启动成功：
SQL> startup
ORACLE instance started.

Total System Global Area 521936896 bytes
Fixed Size 2214936 bytes
Variable Size 348128232 bytes
Database Buffers 167772160 bytes
Redo Buffers 3821568 bytes
Database mounted.
Database opened.