asm无法加载磁盘
来源:互联网 发布:spss类似的软件 编辑:程序博客网 时间:2024/05/16 07:47
--数据库启动后发现找到磁盘
SQL> select group_number,disk_number,mount_status,header_status,name,path from v$asm_disk;
no rows selected
--查看磁盘
[root@rudy init.d]# oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
Instantiating disk "ASM_VOL1"
Unable to instantiate disk "ASM_VOL1"
Instantiating disk "ASM_VOL2"
Unable to instantiate disk "ASM_VOL2"
--尝试重新启动oracleasm
[root@rudy init.d]# /etc/init.d/oracleasm restart
Initializing the Oracle ASMLib driver: [FAILED]
--查看oracleasm日志
more /var/log/oracleasm
Cleaning any stale ASM disks...
Scanning system for ASM disks...
oracleasm-read-label: Unable to open device "/dev/sda1": No such file or directory
Disk "ASM_VOL1" does not exist or is not instantiated
Instantiating disk "ASM_VOL1"
oracleasm-instantiate-disk: Unable to open manager: No such device or address
Unable to instantiate disk "ASM_VOL1"
Disk "ASM_VOL2" does not exist or is not instantiated
Instantiating disk "ASM_VOL2"
oracleasm-instantiate-disk: Unable to open manager: No such device or address
Unable to instantiate disk "ASM_VOL2"
oracleasm-read-label: Unable to open device "/dev/dm-0": No such file or directory
oracleasm-read-label: Unable to open device "/dev/dm-0": No such file or directory
oracleasm-read-label: Unable to open device "/dev/dm-0": No such file or directory
oracleasm-read-label: Unable to open device "/dev/dm-0": No such file or directory
oracleasm-read-label: Unable to open device "/dev/dm-1": No such file or directory
oracleasm-read-label: Unable to open device "/dev/dm-1": No such file or directory
oracleasm-read-label: Unable to open device "/dev/dm-1": No such file or directory
oracleasm-read-label: Unable to open device "/dev/dm-1": No such file or directory
oracleasm-read-label: Unable to open device "/dev/dm-2": No such file or directory
oracleasm-read-label: Unable to open device "/dev/dm-2": No such file or directory
oracleasm-read-label: Unable to open device "/dev/dm-2": No such file or directory
oracleasm-read-label: Unable to open device "/dev/dm-2": No such file or directory
oracleasm-read-label: Unable to open device "/dev/dm-3": No such file or directory
oracleasm-read-label: Unable to open device "/dev/dm-3": No such file or directory
oracleasm-read-label: Unable to open device "/dev/dm-3": No such file or directory
oracleasm-read-label: Unable to open device "/dev/dm-3": No such file or directory
oracleasm-read-label: Unable to open device "/dev/dm-4": No such file or directory
oracleasm-read-label: Unable to open device "/dev/dm-4": No such file or directory
oracleasm-read-label: Unable to open device "/dev/dm-4": No such file or directory
oracleasm-read-label: Unable to open device "/dev/dm-4": No such file or directory
oracleasm-read-label: Unable to open device "/dev/dm-5": No such file or directory
oracleasm-read-label: Unable to open device "/dev/dm-5": No such file or directory
oracleasm-read-label: Unable to open device "/dev/dm-5": No such file or directory
oracleasm-read-label: Unable to open device "/dev/dm-5": No such file or directory
Loading module "oracleasm": failed
Unable to load module "oracleasm"
--再最后可以看到是找不到ASM组件oracleasm.ko
Loading module "oracleasm": failed
Unable to load module "oracleasm"
--在文件系统中查找
[root@rudy rules.d]# find / -name oracleasm.ko
/lib/modules/2.6.18-308.el5/kernel/drivers/addon/oracleasm/oracleasm.ko
--手工安装ASM组件
[root@rudy rules.d]# /sbin/insmod /lib/modules/2.6.18-308.el5/kernel/drivers/addon/oracleasm/oracleasm.ko
--重新执行asm使其enable
/etc/init.d/oracleasm enable
--查看资源状态为OFFLINE
[oracle@rudy ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....DATA.dg ora....up.type ONLINE OFFLINE
ora....ER.lsnr ora....er.type ONLINE ONLINE rudy
ora....ER.lsnr ora....er.type ONLINE ONLINE rudy
ora.asm ora.asm.type ONLINE ONLINE rudy
ora.cssd ora.cssd.type ONLINE ONLINE rudy
ora.diskmon ora....on.type ONLINE ONLINE rudy
ora.evmd ora.evm.type ONLINE ONLINE rudy
ora....prod.db ora....se.type ONLINE OFFLINE
ora.ons ora.ons.type OFFLINE OFFLINE
--停止crs资源
[oracle@rudy ~]$ crs_stop -all
CRS-2500: Cannot stop resource 'ora.ons' as it is not running
Attempting to stop `ora.PRD_LISTENER.lsnr` on member `rudy`
Attempting to stop `ora.LISTENER.lsnr` on member `rudy`
Attempting to stop `ora.evmd` on member `rudy`
Attempting to stop `ora.diskmon` on member `rudy`
Attempting to stop `ora.asm` on member `rudy`
CRS-5016: Process "/opt/app/oracle/grid/bin/lsnrctl" spawned by agent "/opt/app/oracle/grid/bin/oraagent.bin" for action "stop" failed: details at "(:CLSN00010:)" in "/opt/app/oracle/grid/log/rudy/agent/ohasd/oraagent_oracle/oraagent_oracle.log"
Stop of `ora.LISTENER.lsnr` on member `rudy` succeeded.
Stop of `ora.PRD_LISTENER.lsnr` on member `rudy` succeeded.
Stop of `ora.evmd` on member `rudy` succeeded.
Stop of `ora.diskmon` on member `rudy` succeeded.
Stop of `ora.asm` on member `rudy` succeeded.
Attempting to stop `ora.cssd` on member `rudy`
Stop of `ora.cssd` on member `rudy` succeeded.
CRS-0216: Could not stop resource 'ora.ons'.
--重新启动
[oracle@rudy ~]$ crs_start -all
CRS-2501: Resource 'ora.ons' is disabled
Attempting to start `ora.PRD_LISTENER.lsnr` on member `rudy`
Attempting to start `ora.LISTENER.lsnr` on member `rudy`
Attempting to start `ora.cssd` on member `rudy`
Attempting to start `ora.diskmon` on member `rudy`
Attempting to start `ora.evmd` on member `rudy`
Start of `ora.evmd` on member `rudy` succeeded.
Start of `ora.diskmon` on member `rudy` succeeded.
Start of `ora.LISTENER.lsnr` on member `rudy` succeeded.
Start of `ora.PRD_LISTENER.lsnr` on member `rudy` succeeded.
Start of `ora.cssd` on member `rudy` succeeded.
Attempting to start `ora.asm` on member `rudy`
Start of `ora.asm` on member `rudy` succeeded.
Attempting to start `ora.ASM_DATA.dg` on member `rudy`
Start of `ora.ASM_DATA.dg` on member `rudy` succeeded.
Attempting to stop `ora.labaprod.db` on member `rudy`
Stop of `ora.labaprod.db` on member `rudy` succeeded.
Attempting to start `ora.labaprod.db` on member `rudy`
Start of `ora.labaprod.db` on member `rudy` succeeded.
CRS-2660: Resource 'ora.ons' or all of its instances are disabled
--再次查看资源状态ONLINE
[oracle@rudy ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....DATA.dg ora....up.type ONLINE ONLINE rudy
ora....ER.lsnr ora....er.type ONLINE ONLINE rudy
ora....ER.lsnr ora....er.type ONLINE ONLINE rudy
ora.asm ora.asm.type ONLINE ONLINE rudy
ora.cssd ora.cssd.type ONLINE ONLINE rudy
ora.diskmon ora....on.type ONLINE ONLINE rudy
ora.evmd ora.evm.type ONLINE ONLINE rudy
ora....prod.db ora....se.type ONLINE ONLINE rudy
ora.ons ora.ons.type OFFLINE OFFLINE
--而后连接数据库正常
--一些常用命令
/etc/init.d/oracleasm start
/etc/init.d/oracleasm status
/etc/init.d/oracleasm restart
cat /etc/sysconfig/oracleasm
/etc/init.d/oracleasm scandisks
/etc/init.d/oracleasm listdisks
/etc/init.d/oracleasm querydisk /dev/sda1
tail -19 /var/log/oracleasm
0 0
- asm无法加载磁盘
- ASM无法自动加载磁盘组问题
- asm磁盘加载小记
- 在虚拟机上添加共享磁盘后节点2的ASM实例无法加载到
- ASM无法发现磁盘组----ORA-29780
- ASM 无法发现候选磁盘组----丢失的ASM磁盘组 ASM的磁盘组无法挂载
- asm 磁盘组 软连接 连接目标不存在导致实例asm 磁盘组无法拉起
- 单实例ASM无法创建磁盘组问题处理
- 11g DBCA无法找到ASM磁盘组
- Oracle 11gR2 RAC DBCA无法识别ASM磁盘组
- ASM的磁盘组无法挂载解决办法
- Oracle 11gR2 RAC DBCA无法识别ASM磁盘组
- ASM 无法发现候选磁盘组----grid 11.2.0.3 asm 自检通不过 prvf-5184
- 当ASM磁盘组无法MOUNT之时如何找到对应的物理磁盘?
- ASM在线替换ASM磁盘
- Oracle 10g ASM - 创建DISKGROUP时无法识别ASM磁盘ORCL:DATA*及无法全部挂载的问题
- asm 实例无法加载diskgroups,ORA-15110: no diskgroups mounted
- asm 实例无法加载diskgroups,ORA-15110: no diskgroups mounted
- struts2 SUCCESS cannot be resolved to a variable
- 关于解决字符乱码问题及对ucGUI底层实现字符显示的浅析
- 面向对象编程3大特性 7大原则
- JS验证服务器控件textbox输入只能是两位数字
- Ant入门学习
- asm无法加载磁盘
- 从C#程序中调用非受管DLLs
- android.database.CursorWindowAllocationException: Cursor window allocation of 2048 kb failed. # Open
- QML类型说明-EnginioReply
- Linux 库文件的配置:pkg-config的使用
- 单精度浮点数转换成十六进制
- zoj3816,Generalized Palindromic Number,牡丹江网络赛,乱搞
- Sending of multipart/form-data of request in Qt
- 如何使用strace+pstack利器分析程序性能