一个简单的问题，查了半个小时，记录一下

最新推荐文章于 2021-02-18 20:08:20 发布

ct827519

最新推荐文章于 2021-02-18 20:08:20 发布

阅读量110

点赞数

文章标签：数据库

Unable To Connect To ASM Due To SQL*Plus Shows “Connected To An Idle Instance. [ID 1179825.1]

--------------------------------------------------------------------------------

修改时间 30-SEP-2010 类型 PROBLEM 状态 PUBLISHED

In this Document
Symptoms
Cause
Solution

--------------------------------------------------------------------------------

Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.2 - Release: 10.2 to 11.2
Information in this document applies to any platform.

Symptoms

1) On a new ASM installation/configuration (Standalone or RAC) you are not able to connect to the ASM instance due to the SQL*Plus shows “Connected to an idle instance.”

[grid@dbaasm ~]$ sqlplus "/as sysasm"

SQL*Plus: Release 11.2.0.1.0 Production on Wed Aug 18 09:20:55 2010

Connected to an idle instance.

2) You confirmed the ASM installation/configuration successfully completed.

3) Also, the ASM instance is up and running:

[grid@dbaasm ~]$ ps -fea | grep asm_
grid 9226 1 0 Aug11 ? 00:00:00 asm_asmb_+ASM
grid 27656 1 0 May14 ? 00:02:41 asm_pmon_+ASM
grid 27658 1 0 May14 ? 00:00:00 asm_vktm_+ASM
grid 27662 1 0 May14 ? 00:00:01 asm_gen0_+ASM
grid 27664 1 0 May14 ? 00:00:13 asm_diag_+ASM
grid 27666 1 0 May14 ? 00:00:02 asm_psp0_+ASM
grid 27668 1 0 May14 ? 00:45:27 asm_dia0_+ASM
grid 27670 1 0 May14 ? 00:00:03 asm_mman_+ASM
grid 27672 1 0 May14 ? 00:00:05 asm_dbw0_+ASM
grid 27674 1 0 May14 ? 00:00:05 asm_lgwr_+ASM
grid 27676 1 0 May14 ? 00:00:03 asm_ckpt_+ASM
grid 27678 1 0 May14 ? 00:00:06 asm_smon_+ASM
grid 27680 1 0 May14 ? 00:00:07 asm_rbal_+ASM
grid 27682 1 0 May14 ? 00:12:19 asm_gmon_+ASM
grid 27684 1 0 May14 ? 00:00:06 asm_mmon_+ASM
grid 27686 1 0 May14 ? 00:00:50 asm_mmnl_+ASM
grid 28051 1 0 May18 ? 00:00:00 asm_vbg0_+ASM
grid 28306 1 0 May18 ? 00:05:32 asm_vdbg_+ASM
grid 28308 1 0 May18 ? 00:00:00 asm_vmb0_+ASM
grid 28310 1 0 May18 ? 00:00:00 asm_vbg1_+ASM
grid 28312 1 0 May18 ? 00:00:00 asm_vbg2_+ASM

4) You started the ASM instance with the same OS user used to install the ASM Oracle Home (10gR2 or 11gR1) or Grid Infrastructure Home (11gR2), so this is OK.

Cause
1) The environment variables are set as follow:

[grid@dbaasm ~]$ env | grep ORA
ORACLE_SID=+ASM
ORACLE_BASE=/u01/app/grid
ORACLE_HOME=/u01/app/grid/product/11.2.0/grid/

2) The problem is due to the ORACLE_HOME variable has an extra ‘/’ at the end of the full path:

ORACLE_HOME=/u01/app/grid/product/11.2.0/grid/

Solution
Remove the extra ‘/’ at the end of the full path, then you will be able to connect to the ASM instance:

[grid@dbaasm ~]$ export ORACLE_HOME=/u01/app/grid/product/11.2.0/grid
[grid@dbaasm ~]$ echo $ORACLE_HOME
/u01/app/grid/product/11.2.0/grid
[grid@dbaasm ~]$ sqlplus "/as sysasm"

SQL*Plus: Release 11.2.0.1.0 Production on Wed Aug 18 09:27:20 2010

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Automatic Storage Management option

SQL> show parameter instance_name

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_name string +ASM

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/19423/viewspace-1056976/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/19423/viewspace-1056976/