Oracle 11.2.0.3 RAC节点2诡异状态
linux x86_64平台$ srvctl status database -d RAC
Instance rac1 is running on node rac1
Instance rac2 is running on node rac2
$ ps -ef |grep smon
root 5612 1 1 2013 ? 1-13:57:13 /u01/grid/11.2.0/bin/osysmond.bin
oracle 13319 1 0 Jan04 ? 00:01:06 ora_smon_rac2
oracle 17641 16009 0 15:25 pts/0 00:00:00 grep smon
grid 23837 1 0 2013 ? 00:01:28 asm_smon_+ASM2
sqlplus进去竟然说是空闲实例
$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jan 14 15:25:58 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> env |grep ORA看看SID设置没，对不对？ mql535 发表于 2014-1-14 15:34 static/image/common/back.gif
env |grep ORA看看SID设置没，对不对？
SID是对的 please show us the sid . wangyq 发表于 2014-1-14 15:47 static/image/common/back.gif
please show us the sid .
SID是对的 贴出.bash_profile 一般数据低级常见错误，诊断方法见：
http://t.askmaclean.com/thread-3190-1-1.html
Liu Maclean(刘相兵 发表于 2014-1-14 20:43 static/image/common/back.gif
一般数据低级常见错误，诊断方法见：
http://t.askmaclean.com/thread-3190-1-1.html
老师，看到了您的连接，我的smon信息如下：
# ps -ef |grep smon
root 5612 1 1 2013 ? 1-14:18:50 /u01/grid/11.2.0/bin/osysmond.bin
oracle 13319 1 0 Jan04 ? 00:01:11 ora_smon_rac2
grid 23837 1 0 2013 ? 00:01:29 asm_smon_+ASM2
root 31845 4208 0 08:40 pts/0 00:00:00 grep smon
# cat /proc/13319/environ
HOSTNAME=rac2SHELL=/bin/bashTERM=linuxHISTSIZE=1000NLS_LANG=american_america.ZHS16GBKORACLE_UNQNAME=racQTDIR=/usr/lib64/qt-3.3OLDPWD=/u01/oracle/arch2QTINC=/usr/lib64/qt-3.3/includeUSER=oracleTEMP=/tmpORA_NLS11=/u01/oracle/11.2.0/db_1/nls/dataLS_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:ORACLE_SID=rac2ORACLE_BASE=/u01/oracleTNS_ADMIN=/u01/oracle/11.2.0/db_1/network/adminMAIL=/var/spool/mail/oraclePATH=PWD=/u01/oracle/arch1JAVA_HOME=/usr/local/javaTHREADS_FLAG=nativeLANG=en_US.UTF-8KDE_IS_PRELINKED=1KDEDIRS=/usrORACLE_TERM=xtermHISTCONTROL=ignoredupsSHLVL=1HOME=/home/oracleLOGNAME=oracleQTLIB=/usr/lib64/qt-3.3/libCVS_RSH=sshCLASSPATH=/u01/oracle/11.2.0/db_1/JRE:/u01/oracle/11.2.0/db_1/jlib:/u01/oracle/11.2.0/db_1/rdbms/jlib:/u01/oracle/11.2.0/db_1/network/jlibLESSOPEN=|/usr/bin/lesspipe.sh %sORACLE_HOME=/u01/oracle/11.2.0/db_1NLS_DATE_FORMAT=YYYY:MM:DD HH24:MI:SSG_BROKEN_FILENAMES=1_=/u01/oracle/11.2.0/db_1/bin/sqlplusORA_NET2_DESC=9,12ORACLE_SPAWNED_PROCESS=1SKGP_SPAWN_DIAG_PRE_FORK_TS=1388804027SKGP_SPAWN_DIAG_POST_FORK_TS=1388804027SKGP_HIDDEN_ARGS=<FATAL/S/SMON/x0/x14/x0/x8CEDDE18/13276/13163/x13/x15/x1/x8CEDE39A/1388804027/1388804027>0SKGP_SPAWN_DIAG_PRE_EXEC_TS=1388804027 另外附两个节点的环境变量
$ more .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
ORACLE_SID=rac1;export ORACLE_SID
#ORACLE_SID=rac2;export ORACLE_SID
ORACLE_UNQNAME=rac;export ORACLE_UNQNAME
JAVA_HOME=/usr/local/java; export JAVA_HOME
ORACLE_BASE=/u01/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/11.2.0/db_1;export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
NLS_DATE_FORMAT="YYYY:MM:DD HH24:MI:SS";export NLS_DATE_FORMAT
NLS_LANG=american_america.ZHS16GBK; export NLS_LANG
TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN
ORA_NLS11=$ORACLE_HOME/nls/data; export ORA_NLS11
PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin:$ORA_CRS_HOME/bin
PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib
export CLASSPATH
THREADS_FLAG=native; export THREADS_FLAG
export TEMP=/tmp
export TMPDIR=/tmp
umask 022
$ more .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
#ORACLE_SID=rac1;export ORACLE_SID
ORACLE_SID=rac2;export ORACLE_SID
ORACLE_UNQNAME=rac;export ORACLE_UNQNAME
JAVA_HOME=/usr/local/java; export JAVA_HOME
ORACLE_BASE=/u01/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/11.2.0/db_1;export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
NLS_DATE_FORMAT="YYYY:MM:DD HH24:MI:SS";export NLS_DATE_FORMAT
NLS_LANG=american_america.ZHS16GBK; export NLS_LANG
TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN
ORA_NLS11=$ORACLE_HOME/nls/data; export ORA_NLS11
PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin:$ORA_CRS_HOME/bin
PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib
export CLASSPATH
THREADS_FLAG=native; export THREADS_FLAG
export TEMP=/tmp
export TMPDIR=/tmp
umask 022 环境变量太多了 ， 排除问题
只设置 ORACLE_SID 和 ORACLE_HOME PS:
重启实例后 是否能正常登陆，如果能 那么也可以排除环境变量的因素 Liu Maclean(刘相兵 发表于 2014-1-15 14:25 static/image/common/back.gif
PS:
重启实例后 是否能正常登陆，如果能 那么也可以排除环境变量的因素
非常感谢老师，我现在一直没重启实例，是想定位一下问题的根本原因。有可能是内存不足，但奇怪的是实例进程都在，就是连接进数据库的时候显示是空闲实例。
另外在论坛看到您12年的一个分享，我把我的问题补充到了下面，链接如下：http://t.askmaclean.com/forum.php?mod=viewthread&tid=1145&pid=21324&page=1&extra=#pid21324，麻烦老师帮助诊断一下，感谢。
页:
[1]