This discussion is archived
6 Replies Latest reply: Jan 23, 2013 9:02 PM by Fabricio_Jorge RSS

ASM resource online and ASM idle instance

Fabricio_Jorge Explorer
Currently Being Moderated
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 Explorer
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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) Guru
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    OMG... this is embarassing. I ran "oraenv" from GRID_HOME and everything worked just fine.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points