6 Replies Latest reply: Jan 23, 2013 11:02 PM by Fabricio_Jorge RSS

    ASM resource online and ASM idle instance

    Fabricio_Jorge
      Hi all,

      SO..........: CentOS 5.8 32bits (VM - VirtualBox)
      Oracle...: 11gR2 (11.2.0.1.0)

      On my test environment, i have a VM running Oracle Clusterware and 2 11g instances. The problem is: The ASM service appears online (through ./crsctl status resource -t, see below), but when a try to connect to the ASM instance as sysasm, it shows me that the instance is idle, and if i try to startup it, the message "ORA-15149: another ASM instance found running on the host" is shown to me.
      --output of ./crsctl status resource -t
      --------------------------------------------------------------------------------
      NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
      --------------------------------------------------------------------------------
      Local Resources
      --------------------------------------------------------------------------------
      ora.DATA.dg
                     ONLINE  ONLINE       vm-cent5                                     
      ora.DG_MANOBRA.dg
                     ONLINE  ONLINE       vm-cent5                                     
      ora.LISTENER.lsnr
                     ONLINE  ONLINE       vm-cent5                                     
      ora.asm
                     ONLINE  OFFLINE      vm-cent5                 Instance Shutdown   
      --------------------------------------------------------------------------------
      Cluster Resources
      --------------------------------------------------------------------------------
      ora.auxdb.db
            1        ONLINE  ONLINE       vm-cent5                 Open                
      ora.cssd
            1        ONLINE  ONLINE       vm-cent5                                     
      ora.diskmon
            1        ONLINE  ONLINE       vm-cent5 
      If i try to start the ora.asm resource through ./crtctl start, the following output is shown:
      [root@VM-Cent5 bin]# ./crsctl start resource ora.asm
      CRS-2672: Attempting to start 'ora.asm' on 'vm-cent5'
      ORA-01012: not logged on
      CRS-2674: Start of 'ora.asm' on 'vm-cent5' failed
      CRS-2679: Attempting to clean 'ora.asm' on 'vm-cent5'
      CRS-2681: Clean of 'ora.asm' on 'vm-cent5' succeeded
      CRS-4000: Command Start failed, or completed with errors.
      I am probably doing something stupid, but i still could not see what i'm doing wrong.

      Any help will be appreciated. Thanks in advance.
        • 1. Re: ASM resource online and ASM idle instance
          alvaromiranda
          one option could be you are using a different oracle_SID or a wrong oracle_home

          paste the output of
          cat /etc/oratab
          ps aux | grep dbw
          ps -feax | grep dbw

          Alvaro.
          • 2. Re: ASM resource online and ASM idle instance
            alvaromiranda
            also, what users/groups are you using.

            please paste the output of

            id oracle
            id grid

            ls -ald $ORACLE_HOME for both, grid and db home

            thanks
            • 3. Re: ASM resource online and ASM idle instance
              Fabricio_Jorge
              Thanks for your help and attention. Here are the requested information:
              cat /etc/oratab
              
              ora11:/opt/oracle/app/product/11.2.0/dbhome_1:N
              +ASM:/opt/oracle/app/product/11.2.0/grid:N              # line added by Agent
              auxdb:/opt/oracle/app/product/11.2.0/dbhome_1:N         # line added by Agent
              
              [root@VM-Cent5 bin]# ps aux | grep dbw
              oracle    4895  0.0  0.5 421768 15736 ?        Ss   14:21   0:01 asm_dbw0_+ASM
              oracle    5211  0.0  2.9 1095828 85760 ?       Ss   14:27   0:02 ora_dbw0_auxdb
              root      8510  0.0  0.0   4028   708 pts/0    S+   19:09   0:00 grep dbw
              
              [root@VM-Cent5 bin]# ps -feax | grep dbw
              Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.7/FAQ
               8512 pts/0    S+     0:00  |           \_ grep dbw HOSTNAME=VM-Cent5 SHELL=/bin/bash TERM=xterm HISTSIZE=1000 OLDPWD=/opt/oracle/app USER=root LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35: MAIL=/var/spool/mail/root PATH=/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin INPUTRC=/etc/inputrc PWD=/opt/oracle/app/product/11.2.0/grid/bin LANG=en_US.UTF-8 SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass SHLVL=1 HOME=/root LOGNAME=root LESSOPEN=|/usr/bin/lesspipe.sh %s DISPLAY=:0.0 G_BROKEN_FILENAMES=1 XAUTHORITY=/root/.xauthSKpkuZ _=/bin/grep
               4895 ?        Ss     0:01 asm_dbw0_+ASM __CLSAGFW_TYPE_NAME=ora.diskgroup.type CONSOLE=/dev/console SELINUX_INIT=YES ORA_CRS_HOME=/opt/oracle/app/product/11.2.0/grid TERM=linux __CRSD_CONNECT_STR=(ADDRESS=(PROTOCOL=IPC)(KEY=OHASD_IPC_SOCKET_11)) NLS_LANG=AMERICAN_AMERICA.AL32UTF8 __CRSD_AGENT_NAME=/opt/oracle/app/product/11.2.0/grid/bin/oraagent_oracle LD_LIBRARY_PATH=/opt/oracle/app/product/11.2.0/grid/lib INIT_VERSION=sysvinit-2.86 __CLSAGENT_INCARNATION=2 ORASYM=/opt/oracle/app/product/11.2.0/grid/bin/oraagent.bin PATH= runlevel=5 RUNLEVEL=5 PWD=/ ENV_FILE=/opt/oracle/app/product/11.2.0/grid/crs/install/s_crsconfig_vm-cent5_env.txt LANG=en_US.UTF-8 __IS_HASD_AGENT=TRUE previous=N PREVLEVEL=N __CLSAGENT_LOG_NAME=ora.diskgroup.type_oracle SHLVL=2 HOME=/ __CLSAGENT_LOGDIR_NAME=ohasd LD_ASSUME_KERNEL= __CLSAGENT_USER_NAME=oracle ORACLE_HOME=/opt/oracle/app/product/11.2.0/grid ORACLE_SID=+ASM ORA_NET2_DESC=18,21 ORACLE_SPAWNED_PROCESS=1 SKGP_SPAWN_DIAG_PRE_FORK_TS=1358097672 SKGP_SPAWN_DIAG_POST_FORK_TS=1358097672 SKGP_HIDDEN_ARGS=<FATAL/S/DBW0/x0/x8/x0/x3E6C4/4834/4834/x7/x9/x1/x3E9C6/1358097672/1358097672> 0 SKGP_SPAWN_DIAG_PRE_EXEC_TS=1358097672
               5211 ?        Ss     0:02 ora_dbw0_auxdb __CLSAGFW_TYPE_NAME=ora.diskgroup.type CONSOLE=/dev/console SELINUX_INIT=YES ORA_CRS_HOME=/opt/oracle/app/product/11.2.0/grid TERM=linux __CRSD_CONNECT_STR=(ADDRESS=(PROTOCOL=IPC)(KEY=OHASD_IPC_SOCKET_11)) NLS_LANG=AMERICAN_AMERICA.AL32UTF8 __CRSD_AGENT_NAME=/opt/oracle/app/product/11.2.0/grid/bin/oraagent_oracle INIT_VERSION=sysvinit-2.86 __CLSAGENT_INCARNATION=2 ORASYM=/opt/oracle/app/product/11.2.0/grid/bin/oraagent.bin PATH= runlevel=5 RUNLEVEL=5 PWD=/ ENV_FILE=/opt/oracle/app/product/11.2.0/grid/crs/install/s_crsconfig_vm-cent5_env.txt LANG=en_US.UTF-8 __IS_HASD_AGENT=TRUE previous=N PREVLEVEL=N __CLSAGENT_LOG_NAME=ora.diskgroup.type_oracle SHLVL=2 HOME=/ __CLSAGENT_LOGDIR_NAME=ohasd LD_ASSUME_KERNEL= __CLSAGENT_USER_NAME=oracle ORACLE_HOME=/opt/oracle/app/product/11.2.0/dbhome_1 ORACLE_SID=auxdb ORA_NET2_DESC=26,29 ORACLE_SPAWNED_PROCESS=1 SKGP_SPAWN_DIAG_PRE_FORK_TS=1358098073 SKGP_SPAWN_DIAG_POST_FORK_TS=1358098073 SKGP_HIDDEN_ARGS=<FATAL/S/DBW0/x0/x9/x0/x9FF14/5190/5190/x8/xA/x1/xA0162/1358098073/1358098073> 0 SKGP_SPAWN_DIAG_PRE_EXEC_TS=1358098073
              
              [root@VM-Cent5 bin]# id oracle
              uid=502(oracle) gid=503(oinstall) groups=503(oinstall),504(dba)
              
              OBS: I don't have a grid user.
              
              --GRID_HOME
              [oracle@VM-Cent5 ~]$ ls -ald $ORACLE_HOME
              drwxr-xr-x 64 oracle oinstall 4096 Jun 10  2012 /opt/oracle/app/product/11.2.0/grid/
              
              --DB_HOME
              [oracle@VM-Cent5 ~]$ ls -ald $ORACLE_HOME
              drwxr-xr-x 76 oracle oinstall 4096 Jul 23 21:02 /opt/oracle/app/product/11.2.0/dbhome_1
              To start the clusterware, i use root and to start the ASM instance, i use oracle, after exporting the necessary env variables (ORACLE_SID=+ASM and ORACLE_HOME=/opt/oracle/app/product/11.2.0/grid/)

              Thanks again for your help.

              Edited by: Fabricio_Jorge on Jan 14, 2013 3:19 PM
              • 4. Re: ASM resource online and ASM idle instance
                Fabricio_Jorge
                Just one thing that i saw in my recent tests. I restarted CRS (crsctl stop | start resource -all), and the asm service (ora.asm) was back online, both target and state, as you can see below:
                [root@VM-Cent5 bin]# ./crsctl status resource -t
                --------------------------------------------------------------------------------
                NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
                --------------------------------------------------------------------------------
                Local Resources
                --------------------------------------------------------------------------------
                ora.DATA.dg
                               ONLINE  ONLINE       vm-cent5                                     
                ora.DG_MANOBRA.dg
                               ONLINE  ONLINE       vm-cent5                                     
                ora.LISTENER.lsnr
                               ONLINE  ONLINE       vm-cent5                                     
                ora.asm
                               ONLINE  ONLINE       vm-cent5                 Started             
                --------------------------------------------------------------------------------
                Cluster Resources
                --------------------------------------------------------------------------------
                ora.auxdb.db
                      1        ONLINE  ONLINE       vm-cent5                 Open                
                ora.cssd
                      1        ONLINE  ONLINE       vm-cent5                                     
                ora.diskmon
                      1        ONLINE  ONLINE       vm-cent5                       
                ... but when i connect as sysasm using user oracle (sid +ASM), i see again the idle instance.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       
                • 5. Re: ASM resource online and ASM idle instance
                  Sebastian Solbach -Dba Community-Oracle
                  Hi,

                  maybe you used another user/group to install ASM, than the oracle user.

                  You can only connect to ASM as sysasm, if your user is in the sysasm group and the user who own the oracle executable and you are using the correct ORACLE_HOME (the one from GI, not the DB Home):

                  Can you output the following:

                  To know the correct SID for ASM:
                  $ ps -ef|grep pmon

                  Then set the environment to the GI:
                  $ . oraenv
                  Enter the seen SID from above to set the environment correctly.

                  Now do
                  $ ll $ORACLE_HOME/bin/oracle

                  To see who installed/owned the ASM oracle executable. If you are the correct user, and the SID is set correctly, try again.

                  My guess: Wrong Oracle Home.

                  Regards
                  Sebastian
                  • 6. Re: ASM resource online and ASM idle instance
                    Fabricio_Jorge
                    OMG... this is embarassing. I ran "oraenv" from GRID_HOME and everything worked just fine.