今天在虚拟机上安装11g RAC,安装好GRID以及创建好相关DG都一切正常,但是用asmcmd登录查看的时候却出现了问题,情况如下:
[grid@hcn1 ~]$ asmcmd
Connected to an idle instance.
ASMCMD> quit
[grid@hcn1 ~]$
[grid@hcn1 trace]$
[grid@hcn1 trace]$ export ORACLE_SID=+ASM1
[grid@hcn1 trace]$ asmcmd
Connected to an idle instance.
ASMCMD> quit
[grid@hcn1 trace]$ sqlplus '/as sysdba'
SQL*Plus: Release 11.2.0.3.0 Production on Wed Jan 16 15:03:27 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> quit
Disconnected
[grid@hcn1 trace]$
查看日志也是正常的,查看dg状态也是正常
[grid@hcn1 trace]$ srvctl status diskgroup -g backupdg -a
Disk Group backupdg is running on hcn1,hcn2
Disk Group backupdg is enabled
[grid@hcn1 trace]$
[grid@hcn1 trace]$
[grid@hcn1 trace]$ srvctl status diskgroup -g dbdg -a
Disk Group dbdg is running on hcn1,hcn2
Disk Group dbdg is enabled
[grid@hcn1 trace]$
[grid@hcn1 trace]$
查看环境变量:
[grid@hcn1 ~]$ cat .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
ORACLE_BASE=/g01
ORACLE_HOME=/g01/app/11.2.0/grid/
ORACLE_SID=+ASM1
CRS_HOME=/g01/app/11.2.0/grid/
PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
export PATH ORACLE_BASE ORACLE_HOME CRS_HOME ORACLE_SID
[grid@hcn1 ~]$
[grid@hcn1 ~]$
还是没发现有啥子问题,本来想怀疑是BUG的(但是由于这个系统是我头两天刚装好,自己测试删除后,重新做的虚拟机重新安装的,应该不会出现这样的稀奇古怪的BUG)最后只能寻找google,居然也有人遇到,而且还是itpub的斑竹(我也遇到了不冤),O(∩_∩)O哈!
http://www.itpub.net/thread-1300215-4-1.html
看完这个讨论了几大篇的帖子,发现是ORACLE_HOME和CRS_HOME后面多带了个 “/",哎,重新设置后,登录成功
[grid@hcn1 ~]$
[grid@hcn1 ~]$ asmcmd
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 4096 1048576 5120 5025 0 5025 0 N BACKUPDG/
MOUNTED EXTERN N 512 4096 1048576 10240 10143 0 5025 0 N DBDG/
MOUNTED EXTERN N 512 4096 1048576 2048 1652 0 1652 0 Y SYSTEMDG/
ASMCMD>
ASMCMD>
总结下,环境变量也很重要啊,遇到这样的问题,确实不太好处理掉