ORA-00304: requested INSTANCE_NUMBER is busy
来源:互联网 发布:edm群发软件 编辑:程序博客网 时间:2024/05/29 18:17
[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
- ORA-00304: requested INSTANCE_NUMBER is busy
- ORA-00304: requested INSTANCE_NUMBER is busy
- ORA-00304: requested INSTANCE_NUMBER is busy
- ORA-00304: requested INSTANCE_NUMBER is busy
- ORACLE,RAC ORA-00304: requested INSTANCE_NUMBER is busy
- /dev/rhdisk5: the requested resource is busy
- ORA-29760: instance_number parameter not specified
- ORA-00054:resource busy
- Life is so busy ...
- Server is too busy
- device is busy
- umount device is busy
- umount “Device is busy”
- ORA-32000: write to SPFILE requested but SPFILE is not modifiable
- ORA-32001: write to SPFILE requested but no SPFILE is in use
- ORA-32000: write to SPFILE requested but SPFILE is not modifiable
- ORA-32001:write to SPFILE requested but no SPFILE is in use
- BDE中的Directory is busy
- 贪婪算法
- tchar ANSI编码 Unicode编码
- Javascript弹出窗口的各种方法总结
- HTTP超详细解析——06【状态码详解】
- com组件常见问题
- ORA-00304: requested INSTANCE_NUMBER is busy
- Linux下开启/关闭MySql Server命令
- Android:启动Linux流程
- HTTP超详细解析——07【Cookie】
- 5 great productivity-boosting Chrome extensions
- Android中LocalSocket使用
- C语言 - 利用 汇编思想 写一个数的平方
- Java内存分配、管理小结
- PowerDesigner15 反相获取数据库表结构