Shulou(Shulou.com)06/01 Report--

[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 2014Copyright (c) 1982, 2011, Oracle. All rights reserved.Connected to anidle instance. [root@huntdb02] # crsstatResource 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 0Startedora.asm ASM L ONLINE ONLINE huntdb02 0 0 Startedora.cvu cvu C ONLINE ONLINE huntdb02 0 0 ora.gsd Gbl SvcDaemon 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 Openora.txzldb.db database C ONLINE ONLINE huntdb02 0 0 Open [grid@huntdb02 ~] $srvctl status asm-aASM is running onhuntdb01 Huntdb02ASM is enabled. [grid@huntdb02] $srvctl status diskgroup-g systemdg-aDisk Groupsystemdg is running on huntdb01,huntdb02Disk Groupsystemdg is enabled

Now it is almost certain that it is the result of environmental variables.

CRS_HOME=/g01/app/11.2.0/grid/ORACLE_HOME=/g01/app/11.2.0/grid/ORACLE_BASE=/g01ORACLE_SID=+ASM2PATH=$CRS_HOME/bin:$PATH:$HOME/bin:$ORACLE_HOME/binexport PATH CRS_HOME ORACLE_BASE ORACLE_SIDORACLE_HOME

Modify the environment variable as follows (remove the last slash of grid)

RS_HOME=/g01/app/11.2.0/gridORACLE_HOME=/g01/app/11.2.0/gridORACLE_BASE=/g01ORACLE_SID=+ASM2PATH=$CRS_HOME/bin:$PATH:$HOME/bin:$ORACLE_HOME/binexport PATHCRS_HOME ORACLE_BASE ORACLE_SID ORACLE_HOME

Login test

[grid@huntdb02] $sqlplus "/ as sysasm" SQL*Plus: Release11.2.0.3.0 Production on Wed Jul 9 15:10:48 2014Copyright (c) 1982, 2011, Oracle. All rights reserved.Connected to:Oracle Database11g Enterprise Edition Release 11.2.0.3.0-64bit ProductionWith the RealApplication Clusters and Automatic Storage Management optionsSQL >

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.