在虚拟机上添加共享磁盘后节点2的ASM实例无法加载到
在节点1用DBCA给ASM增加磁盘图形过程比较容易,新建了两个目录分别是ARCHLOG和BACKUP. 可不能装载节点2上面!
[Oracle@node2bdump]$ export ORACLE_SID=+ASM2
[oracle@node2bdump]$ asmcmd
ASMCMD>ll
commands:
--------
cd
du
find
help
ls
lsct
lsdg
mkalias
mkdir
pwd
rm
rmalias
ASMCMD>ls
ARCHLOG/
BACKUP/
DATA/
ASMCMD>cd DATA
ASMCMD>ls
MYRAC/
ASMCMD>cd ..
ASMCMD>cd ARCHLOG
无法进入该目录
启动ASM实例
SQL>startup
ORA-32004:obsolete and/or deprecated parameter(s) specified
ASMinstance started
TotalSystem Global Area 92274688 bytes
FixedSize 1217884 bytes
VariableSize 65890980 bytes
ASMCache 25165824 bytes
ORA-15032:not all alterations performed
ORA-15003:diskgroup "DATA" already mounted in another lock name space
ORA-15003:diskgroup "BACKUP" already mounted in another lock name space
ORA-15003:diskgroup "ARCHLOG" already mounted in another lock name space
ASM实例已经存在
[oracle@node2dbs]$ ps -ef | grep asm_
oracle 26435 1 0 17:05 ? 00:00:00 asm_pmon_+ASM2
oracle 26437 1 0 17:05 ? 00:00:00 asm_diag_+ASM2
oracle 26439 1 0 17:05 ? 00:00:00 asm_psp0_+ASM2
oracle 26459 1 0 17:05 ? 00:00:01 asm_lmon_+ASM2
oracle 26461 1 0 17:05 ? 00:00:00 asm_lmd0_+ASM2
oracle 26463 1 0 17:05 ? 00:00:00 asm_lms0_+ASM2
oracle 26480 1 0 17:05 ? 00:00:00 asm_mman_+ASM2
oracle 26482 1 0 17:05 ? 00:00:00 asm_dbw0_+ASM2
oracle 26484 1 0 17:05 ? 00:00:00 asm_lgwr_+ASM2
oracle 26486 1 0 17:05 ? 00:00:00 asm_ckpt_+ASM2
oracle 26488 1 0 17:05 ? 00:00:00 asm_smon_+ASM2
oracle 26490 1 0 17:05 ? 00:00:00 asm_rbal_+ASM2
oracle 26492 1 0 17:05 ? 00:00:00 asm_gmon_+ASM2
oracle 26564 1 0 17:05 ? 00:00:00 asm_lck0_+ASM2
oracle 32297 24832 0 17:09 pts/1 00:00:00 grep asm_
exportORACLE_SID=+ASM2
sqlplus/ as sysdba
SQL>shutdown immediate;
SQL>conn / as sysdba
Connectedto an idle instance.
SQL>startup
ASMinstance started
TotalSystem Global Area 92274688 bytes
FixedSize 1217884 bytes
VariableSize 65890980 bytes
ASMCache 25165824 bytes
ORA-15032:not all alterations performed
ORA-15063:ASM discovered an insufficient number of disks for diskgroup
"BACKUP"
ORA-15063:ASM discovered an insufficient number of disks for diskgroup
"ARCHLOG"