现在的位置: 首页 > 综合 > 正文

ORA-00304: requested INSTANCE_NUMBER is busy

2014年01月05日 ⁄ 综合 ⁄ 共 2742字 ⁄ 字号 评论关闭

[root@node2~]# su - grid

[grid@node2~]$ sqlplus / as sysasm

 

SQL*Plus:Release 11.2.0.1.0 Production on Mon Nov 1117:07:21 2013

 

Copyright(c) 1982, 2009, Oracle.  All rightsreserved.

 

Connectedto an idle instance.

 

SQL>startup

ORA-00304:requested INSTANCE_NUMBER is busy

SQL>host

 

grid      4763    1  0 15:54 ?        00:00:00 asm_pmon_+ASM2

grid      4765    1  0 15:54 ?        00:00:00 asm_vktm_+ASM2

grid      4769    1  0 15:54 ?        00:00:00 asm_gen0_+ASM2

grid      4771    1  0 15:54 ?        00:00:00 asm_diag_+ASM2

grid      4773    1  0 15:54 ?        00:00:00 asm_ping_+ASM2

grid      4775    1  0 15:54 ?        00:00:00 asm_psp0_+ASM2

grid      4777    1  0 15:54 ?        00:00:01 asm_dia0_+ASM2

grid      4779    1  0 15:54 ?        00:00:00 asm_lmon_+ASM2

grid      4781    1  0 15:54 ?        00:00:00 asm_lmd0_+ASM2

grid      4785    1  0 15:54 ?        00:00:00 asm_lms0_+ASM2

grid      4789    1  0 15:54 ?        00:00:00 asm_lmhb_+ASM2

grid      4791    1  0 15:54 ?        00:00:00 asm_mman_+ASM2

grid      4793    1  0 15:54 ?        00:00:00 asm_dbw0_+ASM2

grid      4795    1  0 15:54 ?        00:00:00 asm_lgwr_+ASM2

grid      4797    1  0 15:54 ?        00:00:00 asm_ckpt_+ASM2

grid      4799    1  0 15:54 ?        00:00:00 asm_smon_+ASM2

grid      4801    1  0 15:54 ?        00:00:02 asm_rbal_+ASM2

grid      4803    1  0 15:54 ?        00:00:00 asm_gmon_+ASM2

grid      4805    1  0 15:54 ?        00:00:00 asm_mmon_+ASM2

grid      4807    1  0 15:54 ?        00:00:00 asm_mmnl_+ASM2

grid      4815    1  0 15:54 ?        00:00:00 asm_lck0_+ASM2

grid      4850    1  0 15:55 ?        00:00:00 asm_asmb_+ASM2

grid      4852    1  015:55 ?        00:00:00oracle+ASM2_asmb_+asm2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

grid      8920 8880  0 17:07 pts/1   00:00:00 rlwrap sqlplus / as sysasm

grid      8921 8920  0 17:07 pts/3   00:00:00 sqlplus   as sysasm

grid      9063 9037  0 17:07 pts/3   00:00:00 grep asm

[grid@node2~]$ echo $ORACLE_SID

+ASM1

[grid@node2~]$ cat /home/grid/.bash_profile | grep +ASM

exportORACLE_SID=+ASM1

[grid@node2~]$ fuck it !

bash:fuck: command not found

 

[root@node2~]# vi /home/grid/.bash_profile

[grid@node2~]$ su - grid

Password:

[grid@node2~]$ echo $ORACLE_SID

+ASM2

[grid@node2~]$ sqlplus / as sysasm

 

SQL*Plus:Release 11.2.0.1.0 Production on Mon Nov 1117:11:31 2013

 

Copyright(c) 1982, 2009, Oracle.  All rightsreserved.

 

Connectedto:

OracleDatabase 11gEnterprise Edition Release 11.2.0.1.0 -64bit Production

Withthe 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

抱歉!评论已关闭.