ASMCMD-8102: no connection to ASM解决方法
ASMCMD-8102: no connection to ASM; command requires ASM to run
安装好oracle 11g rac 后,进 asm 操作时,
一直提示这个报错,命令也无法执行。
[root@db1 ~]# su - grid
[grid@db1 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.FCA.dg
ONLINE ONLINE db1
ora.LISTENER.lsnr
ONLINE ONLINE db1
ora.ORADATA.dg
ONLINE ONLINE db1
ora.VOL.dg
ONLINE ONLINE db1
ora.asm
ONLINE ONLINE db1 Started
ora.gsd
OFFLINE OFFLINE db1
ora.net1.network
ONLINE ONLINE db1
ora.ons
ONLINE ONLINE db1
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE db1
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE db1
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE db1
ora.cvu
1 ONLINE ONLINE db1
ora.db1.vip
1 ONLINE ONLINE db1
ora.db2.vip
1 ONLINE INTERMEDIATE db1 FAILED OVER
ora.oc4j
1 ONLINE ONLINE db1
ora.racdb.db
1 ONLINE ONLINE db1 Open
2 ONLINE OFFLINE
ora.scan1.vip
1 ONLINE ONLINE db1
ora.scan2.vip
1 ONLINE ONLINE db1
ora.scan3.vip
1 ONLINE ONLINE db1
[grid@db1 ~]$ srvctl status asm
ASM 正在 db1 上运行
如果没有运行asm实例,使用以下命令打开。
[grid@db1 ~]$ srvctl start asm
检查状态正常,我这里是使用的虚拟机,为了节省内存,只开了一台机器。
[grid@db1 ~]$ cat /home/grid/.bash_profile
检查oracle_sid时,发现这个节点机的SID与第二个机器一样。
看来是没有修改,于是修改正常后,检测试 asm操作正常了。
[root@db1 ~]# su - grid
[grid@db1 ~]$ echo $ORACLE_SID
+ASM1
[grid@db1 ~]$ srvctl status asm
ASM 正在 db1 上运行
[grid@db1 ~]$ asmcmd
ASMCMD> ls
FCA/
ORADATA/
VOL/
ASMCMD> cd FCA
ASMCMD> ls
RACDB/
ASMCMD> cd RACDB
ASMCMD> ls
ARCHIVELOG/
BACKUPSET/
CONTROLFILE/
FLASHBACK/
ONLINELOG/
ASMCMD> cd FLASHBACK/
ASMCMD> ls
log_1.298.924951929
log_2.299.924951931
log_3.300.924963881
log_4.303.925031875
log_5.308.925048931
ASMCMD>
目录 返回
首页