环境:root@stlin3p ~]# uname -a
Linux stlin3p.quist.ch 2.6.18-164.el5 #1 SMP Tue Aug 18 15:51:48 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux
[root@stlin3p ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 5.4 (Tikanga)
[root@stlin3p ~]# rpm -qa|grep oracleasm
oracleasm-2.6.18-164.el5-2.0.5-1.el5
oracleasm-support-2.1.3-1.el5
oracleasmlib-2.0.4-1.el5oracleasm日志:
1、如下为reboot服务器后,自动scandisks的日志信息:
Creating /dev/oracleasm mount point: /dev/oracleasm
Loading module "oracleasm": oracleasm
Mounting ASMlib driver filesystem: /dev/oracleasm
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...我的判断是:自动scandisks的时候,在等待某个信息超时,scanning 超时,没有成功scan.
2、如下为服务器起来后,手工执行scandisks的日志信息:
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
Disk "VOL1" does not exist or is not instantiated
Instantiating disk "VOL1"
Disk "VOL2" does not exist or is not instantiated
Instantiating disk "VOL2"
Disk "VOL3" does not exist or is not instantiated
Instantiating disk "VOL3"
Disk "VOL4" does not exist or is not instantiated
Instantiating disk "VOL4"
Disk "ORADATA1" does not exist or is not instantiated
Instantiating disk "ORADATA1"
Disk "ORADATA2" does not exist or is not instantiated
Instantiating disk "ORADATA2"
Disk "FRADATA1" does not exist or is not instantiated
Instantiating disk "FRADATA1"这个为什么不去验证disk “VOL1”“VOL2”等?只是instantiating disk?
3、如下是,过一段时间后:第二次手工scandisks的日志信息
Reloading disk partitions: done
Cleaning any stale ASM disks...
Validating disk "FRADATA1"
Validating disk "ORADATA1"
Validating disk "ORADATA2"
Validating disk "VOL1"
Validating disk "VOL2"
Validating disk "VOL3"
Validating disk "VOL4"
Scanning system for ASM disks...
Disk "VOL1" is a valid ASM disk
Disk "VOL2" is a valid ASM disk
Disk "VOL3" is a valid ASM disk
Disk "VOL4" is a valid ASM disk
Disk "ORADATA1" is a valid ASM disk
Disk "ORADATA2" is a valid ASM disk
Disk "FRADATA1" is a valid ASM disk
Linux stlin3p.quist.ch 2.6.18-164.el5 #1 SMP Tue Aug 18 15:51:48 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux
[root@stlin3p ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 5.4 (Tikanga)
[root@stlin3p ~]# rpm -qa|grep oracleasm
oracleasm-2.6.18-164.el5-2.0.5-1.el5
oracleasm-support-2.1.3-1.el5
oracleasmlib-2.0.4-1.el5oracleasm日志:
1、如下为reboot服务器后,自动scandisks的日志信息:
Creating /dev/oracleasm mount point: /dev/oracleasm
Loading module "oracleasm": oracleasm
Mounting ASMlib driver filesystem: /dev/oracleasm
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...我的判断是:自动scandisks的时候,在等待某个信息超时,scanning 超时,没有成功scan.
2、如下为服务器起来后,手工执行scandisks的日志信息:
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
Disk "VOL1" does not exist or is not instantiated
Instantiating disk "VOL1"
Disk "VOL2" does not exist or is not instantiated
Instantiating disk "VOL2"
Disk "VOL3" does not exist or is not instantiated
Instantiating disk "VOL3"
Disk "VOL4" does not exist or is not instantiated
Instantiating disk "VOL4"
Disk "ORADATA1" does not exist or is not instantiated
Instantiating disk "ORADATA1"
Disk "ORADATA2" does not exist or is not instantiated
Instantiating disk "ORADATA2"
Disk "FRADATA1" does not exist or is not instantiated
Instantiating disk "FRADATA1"这个为什么不去验证disk “VOL1”“VOL2”等?只是instantiating disk?
3、如下是,过一段时间后:第二次手工scandisks的日志信息
Reloading disk partitions: done
Cleaning any stale ASM disks...
Validating disk "FRADATA1"
Validating disk "ORADATA1"
Validating disk "ORADATA2"
Validating disk "VOL1"
Validating disk "VOL2"
Validating disk "VOL3"
Validating disk "VOL4"
Scanning system for ASM disks...
Disk "VOL1" is a valid ASM disk
Disk "VOL2" is a valid ASM disk
Disk "VOL3" is a valid ASM disk
Disk "VOL4" is a valid ASM disk
Disk "ORADATA1" is a valid ASM disk
Disk "ORADATA2" is a valid ASM disk
Disk "FRADATA1" is a valid ASM disk
解决方案 »
- 请问ora-01403:no data found
- 头大,请大虾提供百万数据查询优化思路。
- 求存储过程:根据字段判断取前一个月的值,输出结果集(有测试数据)
- 怎么实现把3段SELECT 语句连接成一个过程。
- 在线等,求教sql语句
- 请问新建例程的时候,如果不能提供域名,数据库是不是会转而使用 US.ORACLE.COM作为缺省?
- ORACLE中文字符变成了一大堆#号?急
- 谁能将在ORACLE存贮过程中,使用游标的情况给讲解一下,最好提供几个例子。
- 谢谢chooser(chooser)的指点,那么请问哪里有应用服务器和另外两个服务器连接的资料呢?或者请给介绍几本书给我!
- 求救:向oracle中一个BLOB字段插入一个图片的方法,出错信息如下,源码如下,高分给第一个告知原因的人
- 为什么不能更新数据库
- 关于oracle administration assistant添加操作系统数据库管理员用户?
1、为reboot服务器后,自动scandisks的日志信息2、手工scandisks的日志信息
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
oracleasm-read-label: Unable to open device "/dev/sdb1": No such file or directory
Disk "VOL1" does not exist or is not instantiated
Instantiating disk "VOL1"
Disk "VOL2" does not exist or is not instantiated
Instantiating disk "VOL2"
Disk "VOL3" does not exist or is not instantiated
Instantiating disk "VOL3"
Disk "VOL4" does not exist or is not instantiated
Instantiating disk "VOL4"
Disk "ORADATA1" does not exist or is not instantiated
Instantiating disk "ORADATA1"
Disk "ORADATA2" does not exist or is not instantiated
Instantiating disk "ORADATA2"
Disk "FRADATA1" does not exist or is not instantiated
Instantiating disk "FRADATA1"中间有一个错误:
oracleasm-read-label: Unable to open device "/dev/sdb1": No such file or directory以后无论scandisks不会出现?
3、如下是,过一段时间后:第二次手工scandisks的日志信息Reloading disk partitions: done
Cleaning any stale ASM disks...
Validating disk "FRADATA1"
Validating disk "ORADATA1"
Validating disk "ORADATA2"
Validating disk "VOL1"
Validating disk "VOL2"
Validating disk "VOL3"
Validating disk "VOL4"
Scanning system for ASM disks...
Disk "VOL1" is a valid ASM disk
Disk "VOL2" is a valid ASM disk
Disk "VOL3" is a valid ASM disk
Disk "VOL4" is a valid ASM disk
Disk "ORADATA1" is a valid ASM disk
Disk "ORADATA2" is a valid ASM disk
Disk "FRADATA1" is a valid ASM disk
SAN存储:IBM DS3950
oracle 11.2.0.1 RAC + ASM