无法启动 ASM实例

ZALBB

Tonylion888 发表于 2015-5-6 15:20
你就是个2B

讲话客气点，

Tonylion888

ZALBB 发表于 2015-8-31 17:33
讲话客气点，

与你无关，

ZALBB

Tonylion888 发表于 2015-9-1 13:18
与你无关，

有人反馈此帖吵架，言语粗鄙，我是版主，自然要禁止此行为，

zhanghuiyun0978

遇到过同样的的问题，oracle 11g r2ASM由专门的用户grid来维护，请确认该用户的环境变量配置文件设置是否正确，我的环境如下，确保ORACLE_SID=+ASM2与系统ASM进程 一致
# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH
export ORACLE_HOME=/g01/11ggrid/app/11.2.0/grid
export GRID_HOME=/g01/11ggrid/app/11.2.0/grid
export PATH=$GRID_HOME/bin:$GRID_HOME/OPatch:/sbin:/bin:/usr/sbin:/usr/bin
export ORACLE_SID=+ASM2
export LD_LIBRARY_PATH=$GRID_HOME/lib:$GRID_HOME/lib32
export ORACLE_BASE=/g01
export ORA_NLS10=$ORACLE_HOME/nls/data
export NLS_LANG="AMERICAN_AMERICA.ZHS16GBK"
[grid@rac1 ~]$ ps -ef|grep asm
grid      3097     1  0 Dec03 ?        00:01:51 asm_pmon_+ASM2
grid      3099     1  0 Dec03 ?        00:17:26 asm_vktm_+ASM2
grid      3103     1  0 Dec03 ?        00:00:13 asm_gen0_+ASM2
grid      3105     1  0 Dec03 ?        00:06:59 asm_diag_+ASM2
grid      3107     1  0 Dec03 ?        00:00:45 asm_ping_+ASM2
grid      3109     1  0 Dec03 ?        00:00:13 asm_psp0_+ASM2
grid      3111     1  0 Dec03 ?        00:51:33 asm_dia0_+ASM2
grid      3113     1  0 Dec03 ?        00:20:49 asm_lmon_+ASM2
grid      3115     1  0 Dec03 ?        00:22:58 asm_lmd0_+ASM2
grid      3122     1  0 Dec03 ?        00:20:02 asm_lms0_+ASM2
grid      3126     1  0 Dec03 ?        00:00:18 asm_lmhb_+ASM2
grid      3128     1  0 Dec03 ?        00:00:16 asm_mman_+ASM2
grid      3130     1  0 Dec03 ?        00:00:15 asm_dbw0_+ASM2
grid      3132     1  0 Dec03 ?        00:00:16 asm_lgwr_+ASM2
grid      3134     1  0 Dec03 ?        00:00:23 asm_ckpt_+ASM2
grid      3136     1  0 Dec03 ?        00:00:12 asm_smon_+ASM2
grid      3138     1  0 Dec03 ?        00:03:02 asm_rbal_+ASM2
grid      3140     1  0 Dec03 ?        00:02:35 asm_gmon_+ASM2
grid      3142     1  0 Dec03 ?        00:00:32 asm_mmon_+ASM2
grid      3144     1  0 Dec03 ?        00:01:19 asm_mmnl_+ASM2
grid      3150     1  0 Dec03 ?        00:00:53 asm_lck0_+ASM2
grid      3178     1  0 Dec03 ?        00:00:12 asm_asmb_+ASM2
grid      3180     1  0 Dec03 ?        00:00:40 oracle+ASM2_asmb_+asm2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle    6879     1  0 Dec03 ?        00:00:13 ora_asmb_nc5db2
grid      6883     1  0 Dec03 ?        00:00:42 oracle+ASM2_asmb_nc5db2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid     25395 23611  0 09:56 pts/1    00:00:00 grep asm

helencc

遇到了同样的问题, 已解决! 分享下~

我的 ORACLE_HOME 之前的配置是 ORACLE_HOME=/u01/app/grid/product/11.2.0/grid/
修改成 ORACLE_HOME=/u01/app/grid/product/11.2.0/grid      --去掉了 grid 目录后斜杠
去掉后就正常了.... 好奇怪, 绝对目录后有无 / 还有区别吗??


[grid@Helen grid]$ echo $ORACLE_HOME
/u01/app/grid/product/11.2.0/grid/
[grid@Helen grid]$
[grid@Helen grid]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.1.0 Production on Wed Sep 23 22:32:32 2020

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-15149: another ASM instance found running on the host
SQL>
SQL> exit
Disconnected
[grid@Helen grid]$
[grid@Helen grid]$ export ORACLE_HOME=/u01/app/grid/product/11.2.0/grid
[grid@Helen grid]$
[grid@Helen grid]$ echo $ORACLE_HOME
/u01/app/grid/product/11.2.0/grid
[grid@Helen grid]$
[grid@Helen grid]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.1.0 Production on Wed Sep 23 22:33:27 2020

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


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

SQL> select instance_name, status from v$instance;

INSTANCE_NAME    STATUS
---------------- ------------
+ASM             STARTED

SQL>
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Automatic Storage Management option
[grid@Helen grid]$
[grid@Helen grid]$ vi ~/.bash_profile

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export ORACLE_SID=+ASM
export ORACLE_BASE=/u01/app/grid
# export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/grid/
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/grid
export PATH=$ORACLE_HOME/bin:$PATH

export PATH

[grid@Helen grid]$ source ~/.bash_profile
[grid@Helen grid]$

helencc

遇到了同样的问题, 已解决! 分享下~

我的 ORACLE_HOME 之前的配置是 ORACLE_HOME=/u01/app/grid/product/11.2.0/grid/
修改成 ORACLE_HOME=/u01/app/grid/product/11.2.0/grid      --去掉了 grid 目录后斜杠
去掉后就正常了.... 好奇怪, 绝对目录后有无 / 还有区别吗??


[grid@Helen grid]$ echo $ORACLE_HOME
/u01/app/grid/product/11.2.0/grid/
[grid@Helen grid]$
[grid@Helen grid]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.1.0 Production on Wed Sep 23 22:32:32 2020

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-15149: another ASM instance found running on the host
SQL>
SQL> exit
Disconnected
[grid@Helen grid]$
[grid@Helen grid]$ export ORACLE_HOME=/u01/app/grid/product/11.2.0/grid
[grid@Helen grid]$
[grid@Helen grid]$ echo $ORACLE_HOME
/u01/app/grid/product/11.2.0/grid
[grid@Helen grid]$
[grid@Helen grid]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.1.0 Production on Wed Sep 23 22:33:27 2020

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


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

SQL> select instance_name, status from v$instance;

INSTANCE_NAME    STATUS
---------------- ------------
+ASM             STARTED

SQL>
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Automatic Storage Management option
[grid@Helen grid]$
[grid@Helen grid]$ vi ~/.bash_profile

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export ORACLE_SID=+ASM
export ORACLE_BASE=/u01/app/grid
# export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/grid/
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/grid
export PATH=$ORACLE_HOME/bin:$PATH

export PATH

[grid@Helen grid]$ source ~/.bash_profile
[grid@Helen grid]$