ORA-01078 ORA-01565 ORA-27041 raw devices

最新推荐文章于 2023-11-21 14:37:30 发布

aicon

最新推荐文章于 2023-11-21 14:37:30 发布

阅读量1.7k

点赞数

分类专栏： Oracle EBS Oracle 文章标签： oracle disk system processing sql service

本文链接：https://blog.csdn.net/aicon/article/details/5506016

版权

Oracle 同时被 2 个专栏收录

523 篇文章 0 订阅

订阅专栏

Oracle EBS

416 篇文章 0 订阅

订阅专栏

SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '/fs/demo/demo_spfile'
ORA-27041: unable to open file
Linux Error: 13: Permission denied
Additional information: 2

原因查找过程：

vmfs-> ll
total 0
lrwxrwxrwx 1 oracle oinstall 13 Apr 5 14:40 demo_ctl1 -> /dev/raw/raw2
lrwxrwxrwx 1 oracle oinstall 13 Apr 5 14:40 demo_ctl2 -> /dev/raw/raw3
lrwxrwxrwx 1 oracle oinstall 13 Apr 5 14:40 demo_ctl3 -> /dev/raw/raw4
lrwxrwxrwx 1 oracle oinstall 14 Apr 5 14:40 demo_pwd -> /dev/raw/raw13
lrwxrwxrwx 1 oracle oinstall 13 Apr 5 14:40 demo_redo1 -> /dev/raw/raw5
lrwxrwxrwx 1 oracle oinstall 13 Apr 5 14:40 demo_redo2 -> /dev/raw/raw6
lrwxrwxrwx 1 oracle oinstall 13 Apr 5 14:40 demo_redo3 -> /dev/raw/raw7
lrwxrwxrwx 1 oracle oinstall 13 Apr 5 14:40 demo_spfile -> /dev/raw/raw1
lrwxrwxrwx 1 oracle oinstall 13 Apr 5 14:40 sysaux_dbf1 -> /dev/raw/raw9
lrwxrwxrwx 1 oracle oinstall 13 Apr 5 14:40 system_dbf1 -> /dev/raw/raw8
lrwxrwxrwx 1 oracle oinstall 14 Apr 5 14:40 temptbs_dbf -> /dev/raw/raw12
lrwxrwxrwx 1 oracle oinstall 14 Apr 5 14:40 undotbs_dbf -> /dev/raw/raw11
lrwxrwxrwx 1 oracle oinstall 14 Apr 5 14:40 users_dbf1 -> /dev/raw/raw10

vmfs->cd /dev/raw/

vmfs->ll

发现所有raw devices属主都是root！！！

改配置文件：

[root@vmfs etc]# cd udev/
[root@vmfs udev]# ls
devices permissions.d rules.d scripts udev.conf

[root@vmfs udev]# cd permissions.d/
[root@vmfs permissions.d]# ls
50-udev.permissions

[root@vmfs permissions.d]# vi 50-udev.permissions

# /etc/udev/udev.permissions: permission/ownership map for udev

......

# camera devices
camera*:root:root:0600
usb/dc2xx*:root:root:0600
usb/mdc800*:root:root:0600

# raw devices
ram*:root:disk:0660
#raw/*:root:disk:0660
raw/*:oracle:dba:0660

# disk devices
hd*:root:disk:0660
sd*:root:disk:0660
dasd*:root:disk:0660
ataraid*:root:disk:0660
loop*:root:disk:0660
md*:root:disk:0660
ide/*/*/*/*/*:root:disk:0660
discs/*/*:root:disk:0660
loop/*:root:disk:0660
"50-udev.permissions" 206L, 3718C written
[root@vmfs permissions.d]#
[root@vmfs permissions.d]#

[root@vmfs permissions.d]# service rawdevices restart
Assigning devices:
           /dev/raw/raw1 -->   /dev/db_v1/db_d_12_sp
/dev/raw/raw1: bound to major 253, minor 25
           /dev/raw/raw2 -->   /dev/db_v3/db_d_13_ct1
/dev/raw/raw2: bound to major 253, minor 5
           /dev/raw/raw3 -->   /dev/db_v3/db_d_14_ct2
/dev/raw/raw3: bound to major 253, minor 6
           /dev/raw/raw4 -->   /dev/db_v3/db_d_15_ct3
/dev/raw/raw4: bound to major 253, minor 7
           /dev/raw/raw5 -->   /dev/db_v3/db_d_16_redo1
/dev/raw/raw5: bound to major 253, minor 8
           /dev/raw/raw6 -->   /dev/db_v3/db_d_17_redo2
/dev/raw/raw6: bound to major 253, minor 9
           /dev/raw/raw7 -->   /dev/db_v3/db_d_18_redo3
/dev/raw/raw7: bound to major 253, minor 10
           /dev/raw/raw8 -->   /dev/db_v1/db_d_1
/dev/raw/raw8: bound to major 253, minor 14
           /dev/raw/raw9 -->   /dev/db_v1/db_d_2
/dev/raw/raw9: bound to major 253, minor 15
           /dev/raw/raw10 -->   /dev/db_v1/db_d_3
/dev/raw/raw10: bound to major 253, minor 16
           /dev/raw/raw11 -->   /dev/db_v1/db_d_4
/dev/raw/raw11: bound to major 253, minor 17
           /dev/raw/raw12 -->   /dev/db_v1/db_d_5
/dev/raw/raw12: bound to major 253, minor 18
           /dev/raw/raw13 -->   /dev/db_v1/db_d_6
/dev/raw/raw13: bound to major 253, minor 19
           /dev/raw/raw14 -->   /dev/db_v1/db_d_7
/dev/raw/raw14: bound to major 253, minor 20
           /dev/raw/raw15 -->   /dev/db_v1/db_d_8
/dev/raw/raw15: bound to major 253, minor 21
           /dev/raw/raw16 -->   /dev/db_v1/db_d_9
/dev/raw/raw16: bound to major 253, minor 22
           /dev/raw/raw17 -->   /dev/db_v1/db_d_10
/dev/raw/raw17: bound to major 253, minor 23
           /dev/raw/raw18 -->   /dev/db_v1/db_d_11
/dev/raw/raw18: bound to major 253, minor 24
           /dev/raw/raw19 -->   /dev/db_v3/db_d_19
/dev/raw/raw19: bound to major 253, minor 11
           /dev/raw/raw20 -->   /dev/db_v3/db_d_20
/dev/raw/raw20: bound to major 253, minor 12
           /dev/raw/raw21 -->   /dev/db_v3/db_d_21
/dev/raw/raw21: bound to major 253, minor 13
           /dev/raw/raw22 -->   /dev/db_v4/db_d_22
/dev/raw/raw22: bound to major 253, minor 0
           /dev/raw/raw23 -->   /dev/db_v4/db_d_23
/dev/raw/raw23: bound to major 253, minor 1
           /dev/raw/raw24 -->   /dev/db_v4/db_d_24
/dev/raw/raw24: bound to major 253, minor 2
           /dev/raw/raw25 -->   /dev/db_v4/db_d_25
/dev/raw/raw25: bound to major 253, minor 3
           /dev/raw/raw26 -->   /dev/db_v4/db_d_26
/dev/raw/raw26: bound to major 253, minor 4
done
[root@vmfs permissions.d]# cd /dev/raw/

[root@vmfs raw]# ll
total 0
crw-rw---- 1 oracle dba 162, 1 Apr 7 11:41 raw1
crw-rw---- 1 oracle dba 162, 10 Apr 7 11:41 raw10
crw-rw---- 1 oracle dba 162, 11 Apr 7 11:41 raw11
crw-rw---- 1 oracle dba 162, 12 Apr 7 11:41 raw12
crw-rw---- 1 oracle dba 162, 13 Apr 7 11:41 raw13
crw-rw---- 1 oracle dba 162, 14 Apr 7 11:41 raw14
crw-rw---- 1 oracle dba 162, 15 Apr 7 11:41 raw15
crw-rw---- 1 oracle dba 162, 16 Apr 7 11:41 raw16
crw-rw---- 1 oracle dba 162, 17 Apr 7 11:41 raw17
crw-rw---- 1 oracle dba 162, 18 Apr 7 11:41 raw18
crw-rw---- 1 oracle dba 162, 19 Apr 7 11:41 raw19
crw-rw---- 1 oracle dba 162, 2 Apr 7 11:41 raw2
crw-rw---- 1 oracle dba 162, 20 Apr 7 11:41 raw20
crw-rw---- 1 oracle dba 162, 21 Apr 7 11:41 raw21
crw-rw---- 1 oracle dba 162, 22 Apr 7 11:41 raw22
crw-rw---- 1 oracle dba 162, 23 Apr 7 11:41 raw23
crw-rw---- 1 oracle dba 162, 24 Apr 7 11:41 raw24
crw-rw---- 1 oracle dba 162, 25 Apr 7 11:41 raw25
crw-rw---- 1 oracle dba 162, 26 Apr 7 11:41 raw26
crw-rw---- 1 oracle dba 162, 3 Apr 7 11:41 raw3
crw-rw---- 1 oracle dba 162, 4 Apr 7 11:41 raw4
crw-rw---- 1 oracle dba 162, 5 Apr 7 11:41 raw5
crw-rw---- 1 oracle dba 162, 6 Apr 7 11:41 raw6
crw-rw---- 1 oracle dba 162, 7 Apr 7 11:41 raw7
crw-rw---- 1 oracle dba 162, 8 Apr 7 11:41 raw8
crw-rw---- 1 oracle dba 162, 9 Apr 7 11:41 raw9
[root@vmfs raw]# pwd
/dev/raw

[root@vmfs u01]# cat oracle_raw.conf
system=/fs/demo/system_dbf1
sysaux=/fs/demo/sysaux_dbf1
undotbs1=/fs/demo/undotbs_dbf
users=/fs/demo/users_dbf1
temp=/fs/demo/temptbs_dbf
redo1_1=/fs/demo/demo_redo1
redo1_2=/fs/demo/demo_redo2
redo1_3=/fs/demo/demo_redo3
control1=/fs/demo/demo_ctl1
control2=/fs/demo/demo_ctl2
control3=/fs/demo/demo_ctl3
spfile=/fs/demo/demo_spfile
pwdfile=/fs/demo/demo_pwd
[root@vmfs u01]#

SQL> startup
ORACLE instance started.

Total System Global Area 281018368 bytes
Fixed Size                  1218944 bytes
Variable Size              83887744 bytes
Database Buffers          188743680 bytes
Redo Buffers                7168000 bytes
Database mounted.
Database opened.
SQL> select instance_name,status from v$instance;

INSTANCE_NAME STATUS
---------------- ------------
demo OPEN

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/fs/demo/system_dbf1
/fs/demo/undotbs_dbf
/fs/demo/sysaux_dbf1
/fs/demo/users_dbf1

SQL> select name from v$tempfile;

NAME
--------------------------------------------------------------------------------
/fs/demo/temptbs_dbf

SQL>