Gooora 发表于 2013-10-10 12:55:19

执行asmcmd 提示 Connected to an idle instance

环境：系统OEL6u4 x86_64
oracle 112030 64bit，双节点RAC
故障描述：数据库可以正常使用，在两个节点上运行asmcmd 提示
Connected to an idle instance.
sqlplus / as sysasm也是提示
Connected to an idle instance.
执行ps -ef | grep ASM
asm的进程都在
节点1
.bash_profile的内容
export ORACLE_BASE=/g01/app/grid
export GRID_HOME=/g01/app/11.2.0/grid
export ORACLE_HOME=/g01//app/11.2.0/grid
export ORACLE_SID=+ASM1
节点2
export ORACLE_BASE=/g01/app/grid
export GRID_HOME=/g01/app/11.2.0/grid
export ORACLE_HOME=/g01//app/11.2.0/grid
export ORACLE_SID=+ASM2
执行
crsctl status resource -t
除了gsd以外的资源都是online

Maclean Liu(刘相兵 发表于 2013-10-10 13:10:06

ps -ef|grep asm_

找一个ASM进程的SPID

给出

cd /proc/$SPID/environ

Gooora 发表于 2013-10-10 13:19:25

感谢刘老师的回复。
cat /proc/19897/environ   
__CLSAGFW_TYPE_NAME=ora.asm.typeHOSTNAME=rac1.ecp888.comORA_CRS_HOME=/g01/app/11.2.0/gridTERM=linuxSHELL=/bin/bash__CRSD_CONNECT_STR=(ADDRESS=(PROTOCOL=IPC)(KEY=OHASD_IPC_SOCKET_11))HISTSIZE=1000NLS_LANG=AMERICAN_AMERICA.AL32UTF8SSH_CLIENT=192.168.1.171 3470 22CRF_HOME=/g01/app/11.2.0/gridQTDIR=/usr/lib64/qt-3.3QTINC=/usr/lib64/qt-3.3/includeSSH_TTY=/dev/pts/3GIPCD_PASSTHROUGH=false__CRSD_AGENT_NAME=/g01/app/11.2.0/grid/bin/oraagent_grid__CRSD_MSG_FRAME_VERSION=2USER=rootLD_LIBRARY_PATH=/g01/app/11.2.0/grid/lib:/etc/ORCLcluster/libLS_COLORS=rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:mi=01;05;37;41:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.tbz=01;31:*.tbz2=01;31:*.bz=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=01;36:*.au=01;36:*.flac=01;36:*.mid=01;36:*.midi=01;36:*.mka=01;36:*.mp3=01;36:*.mpc=01;36:*.ogg=01;36:*.ra=01;36:*.wav=01;36:*.axa=01;36:*.oga=01;36:*.spx=01;36:*.xspf=01;36:__CLSAGENT_INCARNATION=2ORASYM=/g01/app/11.2.0/grid/bin/oraagent.binMAIL=/var/spool/mail/rootPATH=NXDIR=/usr/NXPWD=/ENV_FILE=/g01/app/11.2.0/grid/crs/install/s_crsconfig_rac1_env.txtLANG=en_US.UTF-8TZ=Asia/Chongqing__IS_HASD_AGENT=TRUE__CLSAGENT_LOG_NAME=ora.asm.type_gridHISTCONTROL=ignoredupsSHLVL=2HOME=/root__CLSAGENT_LOGDIR_NAME=ohasdLD_ASSUME_KERNEL=__CLSAGENT_USER_NAME=gridLOGNAME=rootQTLIB=/usr/lib64/qt-3.3/libCVS_RSH=sshSSH_CONNECTION=192.168.1.171 3470 192.168.1.80 22LESSOPEN=|/usr/bin/lesspipe.sh %sORACLE_HOME=/g01/app/11.2.0/gridG_BROKEN_FILENAMES=1ORACLE_SID=+ASM1ORA_NET2_DESC=31,34ORACLE_SPAWNED_PROCESS=1SKGP_SPAWN_DIAG_PRE_FORK_TS=1381378978SKGP_SPAWN_DIAG_POST_FORK_TS=1381378978SKGP_HIDDEN_ARGS=<FATAL/S/PMON/x0/x1/x0/x3C3D11B8/19819/19819/x0/x2/x1/x3C3D11FE/1381378978/1381378978>0SKGP_SPAWN_DIAG_PRE_EXEC_TS=1381378978

Maclean Liu(刘相兵 发表于 2013-10-10 19:52:52

ORACLE_HOME=/g01/app/11.2.0/grid
export ORACLE_HOME=/g01//app/11.2.0/grid

==> 你多了个斜杠

ORACLE_SID=+ASM1

Gooora 发表于 2013-10-10 20:06:27

是这里的问题，多谢刘老师

Liu Maclean(刘相兵 发表于 2014-1-14 20:45:03

PS:
如果是在Solaris平台上的话  可以使用pargs 等命令诊断该类问题

Connected to an idle instance.
Connected to an idle instance.
Connected to an idle instance.
Connected to an idle instance.
Connected to an idle instance.
Connected to an idle instance.
Connected to an idle instance.

wangyq 发表于 2014-1-14 21:17:35

so good !  ML  v5  

licharles 发表于 2014-1-15 10:32:48

积累了。
页: [1]
查看完整版本: 执行asmcmd 提示 Connected to an idle instance