[grid@huntdb02 ~]$export ORACLE_SID=txzldb2
[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
-------------------------------------------------------- ---------- ------------ --------------- -- -- ---------------
ora.BACKDG.dg diskgroup L ONLINE ONLINE huntdb01 0 0
ora.BACKDG.dg diskgroup L ONLINE ONLINE huntdb02 0 0
ora.DATA.dg diskgroup L ONLINE ONLINE huntdb01 0 0
ora.DATA.dg diskgroup L ONLINE ONLINE huntdb02 0 0
ora.LISTENER.lsnr Listener L ONLINE ONLINE huntdb01 0 0
ora.LISTENER.lsnr Listener L ONLINE ONLINE huntdb02 0 0
ora.LISTENER_SCAN1.lsnr SCAN Listener C ONLINE ONLINE huntdb02 0 0
ora.SYSTEMDG.dg diskgroup L ONLINE ONLINE huntdb01 0 0
ora.SYSTEMDG.dg diskgroup L ONLINE ONLINE huntdb02 0 0
ora.asm ASM L ONLINE ONLINE huntdb01 0 0Started
ora.asm ASM L ONLINE ONLINE huntdb02 0 0 Started
ora.cvu cvu C ONLINE ONLINE huntdb02 0 0
ora.gsd Gbl Svc Daemon L ONLINE OFFLINE (huntdb01) 0 0
ora.gsd Gbl SvcDaemon L ONLINE OFFLINE (huntdb02) 0 0
ora.huntdb01.vip Cluster VIP C ONLINE ONLINE huntdb01 0 0
ora.huntdb02.vip Cluster VIP C ONLINE ONLINE huntdb02 0 0
ora.net1.network Network (VIP) L ONLINE ONLINE huntdb01 0 0
ora.net1.network Network (VIP) L ONLINE ONLINE huntdb02 0 0
ora.oc4j OC4J C ONLINE ONLINE huntdb02 0 0
ora.ons Ora NotifSvc L ONLINE ONLINE huntdb01 0 0
ora.ons Ora NotifSvc L ONLINE ONLINE huntdb02 0 0
ora.scan1.vip SCAN VIP C ONLINE ONLINE huntdb02 0 0
ora.txzldb.db database C ONLINE ONLINE huntdb01 0 0 Open
ora.txzldb.db database C ONLINE ONLINE huntdb02 0 0 Open
[grid@huntdb02 ~]$srvctl status asm -a
ASM is running onhuntdb01,huntdb02
ASM is enabled.
[grid@huntdb02 ~]$srvctl status diskgroup -g systemdg -a
Disk Groupsystemdg is running on huntdb01,huntdb02
Disk Groupsystemdg is enabled
现在基本可以肯定是环境变量导致的结果
CRS_HOME=/g01/app/11.2.0/grid/
ORACLE_HOME=/g01/app/11.2.0/grid/
ORACLE_BASE=/g01
ORACLE_SID=+ASM2
PATH=$CRS_HOME/bin:$PATH:$HOME/bin:$ORACLE_HOME/bin
export PATH CRS_HOME ORACLE_BASE ORACLE_SID
ORACLE_HOME
修改环境变量如下(去掉grid最后的斜杠)
RS_HOME=/g01/app/11.2.0/grid
ORACLE_HOME=/g01/app/11.2.0/grid
ORACLE_BASE=/g01
ORACLE_SID=+ASM2
PATH=$CRS_HOME/bin:$PATH:$HOME/bin:$ORACLE_HOME/bin
export PATH
CRS_HOME ORACLE_BASE ORACLE_SID ORACLE_HOME
登录测试
[grid@huntdb02 ~]$sqlplus "/as sysasm"
SQL*Plus: Release11.2.0.3.0 Production on Wed Jul 9 15:10:48 2014
Copyright (c)1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the RealApplication Clusters and Automatic Storage Management options
SQL>
亿速云「云服务器」,即开即用、新一代英特尔至强铂金CPU、三副本存储NVMe SSD云盘,价格低至29元/月。点击查看>>
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。