原因:环境变量设置错误
[grid@shdb02~]$ cat /u01/app/oracle/product/11.2.0/db_1/log/diag/asmcmd/user_oracle/shdb02/alert/alert.log29-Oct-2018:03Connected to an idle instance.29-Oct-2018:03ASMCMD-8102: no connection to Oracle ASM; command requires Oracle ASM to run29-Oct-2018:04Connected to an idle instan...
[grid@huntdb02 ~]$sqlplus "/as sysasm" SQL*Plus: Release11.2.0.3.0 Production on Wed Jul 9 15:07:55 2014 Copyright (c)1982, 2011, Oracle. All rights reserved. Connected to anidle instance. [root@huntdb02 ~]#crsstat Resource Name Resource Type Target State Node FC RC State Details ...
asmcmd “connected to an idle instance” – not This is more a note to myself in case I’ll encounter a similar environment. But maybe it helps others – at leastmysearch results weren’t suitable to Windows in the first place. Issue C:\> set ORACLE_HOME=C:\path\to\grid\home C:\...
Connected to an idle instance. 使用asmcmd启动和停止ASM 实例 用于管理的ASM 元数据位于ASM 实例内包含的动态性能视图内。通常通过ASM 实用程序使用SQL 语言来访问这些视图。要求了解SQL 语言增加了掌握ASM 的学习时间,而且SQL 语言培训通常不在系统管理员和存储管理员的学习范围内。asmcmd实用程序提供了一个类似伪...
$sqlplus/assysasmSQL*Plus:Release11.2.0.3.0Production on Sat Jan2120:34:312016Copyright(c)1982,2011,Oracle.All rightsreserved.Connectedto an idle instance.SQL>startupORA-01078:failureinprocessing system parametersORA-29701:unable to connect to Cluster Synchronization Service ...
Connected to an idle instance. SQL>startup ORACLE instance started. Total System Global Area 188743680 bytes Fixed Size 1218436 bytes Variable Size 83888252 bytes Database Buffers 100663296 bytes Redo Buffers 2973696 bytes Database mounted. Database opened. ...
Connected to an idle instance. 11:39:50 SYS@ +ASM>startup nomount ASM instance started Total System Global Area 83886080 bytes Fixed Size 1217836 bytes Variable Size 57502420 bytes ASM Cache 25165824 bytes 11:39:57 SYS@ +ASM>select name ,state from v$asm_diskgroup; ...
Connected to an idle instance. 11:39:50 SYS@ +ASM>startup nomount ASM instance started Total System Global Area 83886080 bytes Fixed Size 1217836 bytes Variable Size 57502420 bytes ASM Cache 25165824 bytes 11:39:57 SYS@ +ASM>select name ,state from v$asm_diskgroup; ...
Marking disk "/dev/loop1" as an ASM disk: [ OK ] /etc/init.d/oracleasm createdisk ASMD2 /dev/loop2 /etc/init.d/oracleasm createdisk ASMD3 /dev/loop3 /etc/init.d/oracleasm createdisk ASMD4 /dev/loop4 /etc/init.d/oracleasm createdisk ASMD5 /dev/loop5 ...