连接 Oracle 11G R2 ASM实例 开始连接ASM时候，效仿10G的方法却怎么都连接不到ASM 连接的都是idle实例 [root@tip02 ~]# su - oracle [oracle@tip02 ~]$ export ORACLE_SID=+ASM2 [oracle@tip02 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Wed May 16 18:23:39 2012 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to an idle instance. 查看资料后，11G连接ASM与10G还是有变化，需要切换到grid用户 设置ORACLE_HOME再连接 [oracle@tip02 ~]$ su - grid 口令： [grid@tip02 ~]$ oraenv ORACLE_SID = [+ASM2] ? The Oracle base remains unchanged with value /u01/app/grid [grid@tip02 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Wed May 16 18:35:35 2012 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Real Application Clusters and Automatic Storage Management options SQL> show parameter sga NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ lock_sga boolean FALSE sga_max_size big integer 568M sga_target big integer 0 SQL> select instance_name from v$instance; INSTANCE_NAME ---------------- +ASM2 SQL>
本文出自 “O Record” 博客，请务必保留此出处http://evils798.blog.51cto.com/8983296/1420887