2015.06.09

[root@rac2 bin]# su - grid
[grid@rac2 ~]$ asmcmd
Connected to an idle instance.
ASMCMD> startup
ORA-00304: requested INSTANCE_NUMBER is busy
Connected to an idle instance.

[grid@rac2 ~]$ ps -ef | grep ASM
grid 3207 1 0 18:11 ? 00:00:00 asm_pmon_+ASM2
grid 3209 1 0 18:11 ? 00:00:00 asm_psp0_+ASM2
grid 3211 1 5 18:11 ? 00:01:18 asm_vktm_+ASM2
grid 3215 1 0 18:11 ? 00:00:00 asm_gen0_+ASM2
grid 3217 1 0 18:11 ? 00:00:01 asm_diag_+ASM2
grid 3219 1 0 18:11 ? 00:00:00 asm_ping_+ASM2
grid 3221 1 0 18:11 ? 00:00:01 asm_dia0_+ASM2
grid 3223 1 0 18:11 ? 00:00:03 asm_lmon_+ASM2
grid 3225 1 0 18:11 ? 00:00:02 asm_lmd0_+ASM2
grid 3227 1 0 18:11 ? 00:00:07 asm_lms0_+ASM2
grid 3231 1 0 18:11 ? 00:00:00 asm_lmhb_+ASM2
grid 3233 1 0 18:11 ? 00:00:00 asm_mman_+ASM2
grid 3235 1 0 18:11 ? 00:00:00 asm_dbw0_+ASM2
grid 3237 1 0 18:11 ? 00:00:00 asm_lgwr_+ASM2
grid 3239 1 0 18:11 ? 00:00:00 asm_ckpt_+ASM2
grid 3241 1 0 18:11 ? 00:00:00 asm_smon_+ASM2
grid 3243 1 0 18:11 ? 00:00:00 asm_rbal_+ASM2
grid 3245 1 0 18:11 ? 00:00:00 asm_gmon_+ASM2
grid 3247 1 0 18:11 ? 00:00:00 asm_mmon_+ASM2
grid 3249 1 0 18:11 ? 00:00:00 asm_mmnl_+ASM2
grid 3251 1 0 18:11 ? 00:00:00 asm_lck0_+ASM2
grid 3260 1 0 18:11 ? 00:00:00 oracle+ASM2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 3276 1 0 18:11 ? 00:00:00 oracle+ASM2_ocr (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 3283 1 0 18:11 ? 00:00:00 asm_asmb_+ASM2
grid 3285 1 0 18:11 ? 00:00:00 oracle+ASM2_asmb_+asm2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 3459 1 0 18:11 ? 00:00:00 oracle+ASM2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 3465 1 0 18:11 ? 00:00:00 oracle+ASM2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 3468 1 0 18:11 ? 00:00:00 oracle+ASM2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 7964 7963 0 18:34 ? 00:00:00 oracle+ASM1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 8236 1 0 18:34 ? 00:00:00 asm_o000_+ASM2
grid 8238 1 0 18:34 ? 00:00:00 oracle+ASM2_o000_+asm2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 8494 8493 0 18:36 ? 00:00:00 oracle+ASM1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
grid 8560 8496 0 18:37 pts/1 00:00:00 grep ASM

[grid@rac2 ~]$ echo $ORACLE_SID
+ASM1
[grid@rac2 ~]$ 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
PATH=$PATH:$HOME/bin
export PATH
export ORACLE_BASE=/u01/app/grid
export ORACLE_HOME=/u01/app/11.2.0/grid_1
export PATH=$ORACLE_HOME/bin:$PATH:
export ORACLE_SID=+ASM2 ---- 之前是+ASM1，修改为+ASM2
export PATH=$ORACLE_HOME/bin:$PATH:
export TMP=/tmp
export TMPDIR=/tmp
LD_LIBRARY_PATH=$ORACLE_HOME/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/ctx/lib
export LD_LIBRARY_PATH
stty erase ^H
umask 022
export PATH
~

grid@rac2 ~]$ echo $ORACLE_SID
+ASM1
[grid@rac2 ~]$ . ~/.bash_profile
[grid@rac2 ~]$ echo $ORACLE_SID
+ASM2
[grid@rac2 ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Tue Jun 9 18:38:33 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> show parameter name

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_unique_name string +ASM
instance_name string +ASM2
lock_name_space string
service_names string +ASM
SQL>

ITPub博客

ORA-00304: requested INSTANCE_NUMBER is busy

最新文章