oracleASM挂载不上

最新推荐文章于 2023-03-15 10:37:11 发布

转载最新推荐文章于 2023-03-15 10:37:11 发布 · 342 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/flyback/articles/6061891.html

文章标签：

#数据库

本文记录了在尝试使用SQL Plus关闭数据库实例及通过grid用户检查集群资源状态时遇到的问题。包括因权限不足导致的关闭失败、ASM实例警告以及部分集群资源离线等问题。同时展示了udev规则配置和磁盘组的状态。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

###切换成sqlplus / as sysasm 否则会报错

SQL> shutdown immediate;
ORA-01031: insufficient privileges

SQL> conn / as sysasm
Connected.
SQL> shutdown immediate;

ORA-00099: warning: no parameter file specified for ASM instance
ORA-01031: insufficient privileges

[oracle@stagedb ~]$ crs_stat -t
-bash: crs_stat: command not found
[oracle@stagedb ~]$ su - grid
Password:
[grid@stagedb ~]$ crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora.DATA.dg    ora....up.type OFFLINE   OFFLINE
ora.FRA.dg     ora....up.type OFFLINE   OFFLINE
ora....ER.lsnr ora....er.type ONLINE    ONLINE    stagedb
ora.asm        ora.asm.type   ONLINE    ONLINE    stagedb
ora.cssd       ora.cssd.type ONLINE    ONLINE    stagedb
ora.diskmon    ora....on.type OFFLINE   OFFLINE
ora.evmd       ora.evm.type   ONLINE    ONLINE    stagedb
ora.ons        ora.ons.type   OFFLINE   OFFLINE
ora.sumapay.db ora....se.type OFFLINE   OFFLINE
[grid@stagedb ~]$ crsctl start resource ora.ons
CRS-2501: Resource 'ora.ons' is disabled
CRS-4000: Command Start failed, or completed with errors.
[grid@stagedb ~]$ crsctl start resource

ORA-15001: diskgroup "DATA" does not exist or is not mounted

60-raw.rules                 70-persistent-net.rules      90-hal.rules                 98-kexec.rules               99-oracle-asmdevices.rules
[root@stagedb ~]# cat /etc/udev/rules.d/99-oracle-asmdevices.rules
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="36000c2950e342ab97c6fa0305b3d0caf", NAME="asm-diskb", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="36000c2996f44e24d2d53b77518cf7393", NAME="asm-diskc", OWNER="grid", GROUP="asmadmin", MODE="0660"
[root@stagedb ~]# /sbin/scsi_id -u grid -g asadmin -d /dev/asm-diskb
You have mail in /var/spool/mail/root
[root@stagedb ~]# /sbin/scsi_id -u grid -g asadmin -d /dev/asm-diskc
[root@stagedb ~]# ll /dev/asm
ls: 无法访问/dev/asm: 没有那个文件或目录
[root@stagedb ~]# df -lh
Filesystem            Size Used Avail Use% Mounted on
/dev/mapper/vg00-root
                      181G   11G 161G   7% /
tmpfs                 3.8G 139M 3.7G   4% /dev/shm
/dev/sda2             477M   63M 385M 15% /boot
/dev/sda1             200M 260K 200M   1% /boot/efi
/dev/mapper/vg00-var   50G   22G   25G 47% /u01
[root@stagedb ~]# ll /dev/asm-di
ls: 无法访问/dev/asm-di: 没有那个文件或目录
[root@stagedb ~]# /sbin/scsi_id -u grid -g asadmin -d /dev/sdb
36000c29bebabb62b58bf639d7baab94c
You have mail in /var/spool/mail/root
[root@stagedb ~]# /sbin/scsi_id -u grid -g asadmin -d /dev/sdc
36000c292bdfd35410e1dd6e5da45eb94

/sbin/start_udev
Starting udev: [ OK ]

cat /etc/udev/rules.d/99-oracle-asmdevices.rules
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="36000c29bebabb62b58bf639d7baab94c", NAME="asm-diskb", OWNER="grid", GROUP="asmadmin", MODE="0660"
#KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="36000c2950e342ab97c6fa0305b3d0caf", NAME="asm-diskb", OWNER="grid", GROUP="asmadmin", MODE="0660"
#KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="36000c2996f44e24d2d53b77518cf7393", NAME="asm-diskc", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="36000c292bdfd35410e1dd6e5da45eb94", NAME="asm-diskc", OWNER="grid", GROUP="asmadmin", MODE="0660"

转载于:https://www.cnblogs.com/flyback/articles/6061891.html