|
[iyunv@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
[iyunv@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
|