This discussion is archived
11 Replies Latest reply: Dec 20, 2012 8:44 PM by Shivananda Rao RSS

Idle ASM-instance in list of processess

Pavel Explorer
Currently Being Moderated
Hello!

I see smon of ASM-instanse in list of processes of AIX,
after chekin the status :
srvctl status ASM
ASM is not running.
Please let me now , why ASM-instance is idle and at the same time is in list of processes of OS ?
I think if instance is idle then shу don't take server resources

I'm usung 11.2.0.3

Thanks and regards,
Pavel
  • 1. Re: Idle ASM-instance in list of processess
    Victor Armbrust Oracle ACE
    Currently Being Moderated
    What's is your GI? Standalone / RAC?

    Please post the outputs for:

    # ps -ef|grep asm
    # crsctl status res -t

    Are you using "oracle" user for ORACLE DATABASE and "grid" user for GI?

    Also, please try (logged as ASM/GI owner)

    # export ORACLE_SID=+ASM1 (in case of node 1)
    # sqlplus / a sysdba
    # select * from v$instance;


    Victor
  • 2. Re: Idle ASM-instance in list of processess
    BSalesRashid Explorer
    Currently Being Moderated
    Hi,
    Try access ASMCMD, and then try to locate your disks.

    If do not list, maybe your asmlib isn't started.

    Regards,
  • 3. Re: Idle ASM-instance in list of processess
    Pavel Explorer
    Currently Being Moderated
    Hi Victor
    ps -ef|grep asm
    oracle 9309 1 0 Aug 10 ? 18:17 asm_pmon_+ASM
    oracle 9311 1 0 Aug 10 ? 2:49 asm_psp0_+ASM
    oracle 9313 1 0 Aug 10 ? 4:38 asm_mman_+ASM
    oracle 9315 1 0 Aug 10 ? 2:56 asm_dbw0_+ASM
    oracle 9317 1 0 Aug 10 ? 3:41 asm_lgwr_+ASM
    oracle 9319 1 0 Aug 10 ? 4:03 asm_ckpt_+ASM
    oracle 9321 1 0 Aug 10 ? 2:41 asm_smon_+ASM
    oracle 9323 1 0 Aug 10 ? 3:06 asm_rbal_+ASM
    oracle 9326 1 0 Aug 10 ? 9:24 asm_gmon_+ASM
    oracle 8052 18584 0 18:13:03 pts/13 0:00 grep asm
    oracle 4883 1 0 Oct 09 ? 5:25 /u/oracle/grid/bin/tnslsnr listener_asm -inherit
    crsctl status res -t
    --------------------------------------------------------------------------------
    NAME TARGET STATE SERVER STATE_DETAILS
    --------------------------------------------------------------------------------
    Local Resources
    --------------------------------------------------------------------------------
    ora.asm
    OFFLINE OFFLINE p900 Instance Shutdown
    ora.ons
    OFFLINE OFFLINE p900
    --------------------------------------------------------------------------------
    Cluster Resources
    --------------------------------------------------------------------------------
    ora.cssd
    1 OFFLINE OFFLINE
    ora.diskmon
    1 OFFLINE OFFLINE
    ora.evmd
    1 OFFLINE OFFLINE
    Are you using "oracle" user for ORACLE DATABASE and "grid" user for GI?
    Yes , Viktor
    export ...
    sqlplus / as sysdba
    SQL*Plus: Release 11.2.0.3.0 Production on Thu Dec 20 18:16:31 2012
    Copyright (c) 1982, 2011, Oracle. All rights reserved.
    Connected to an idle instance.
    Pavel
  • 4. Re: Idle ASM-instance in list of processess
    Pavel Explorer
    Currently Being Moderated
    Hi Rashid

    #asmcmd
    Connected to an idle instance.
    regards,
    Pavel
  • 5. Re: Idle ASM-instance in list of processess
    Victor Armbrust Oracle ACE
    Currently Being Moderated
    Your are using ASM with oracle user my friend.. look at the owner of the processes:
    *oracle* 9309 1 0 Aug 10 ? 18:17 asm_pmon_+ASM
    ...
    ...
    That's why you cannot access it with "grid". Make sure you star the ASM with correct ids..

    You should stop your ASM using "oracle" and than start it via GI using crsctl ou srvctl.


    Oracle User:
    export ORACLE_SID=+ASM
    sqlplus / as sysdba
    shutdown immediate
    Grid User:
    srvctl start ASM -n <node_name> 
    PS: Are you using an standalone installation right? Look at your SID (+ASM).

    Victor
  • 6. Re: Idle ASM-instance in list of processess
    Pavel Explorer
    Currently Being Moderated
    Hello , Viktor

    Are you using "oracle" user for ORACLE DATABASE and "grid" user for GI?
    Yes , Viktor
    I am sorry , Sir,
    You are right , really I'm using ASM with oracle user,
    this is my error

    I can't stop the ASM-instance, for unown reason she's status is idle :
    env|grep _SID
    ORACLE_SID=+ASM
    sqlplus / as sysdba
    SQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 21 09:45:18 2012
    Copyright (c) 1982, 2011, Oracle. All rights reserved.
    Connected to an idle instance.
    I'm using an standalone(non RAC) installation


    Thanks and regards,
    Pavel

    Edited by: Pavel on Dec 20, 2012 8:04 PM
  • 7. Re: Idle ASM-instance in list of processess
    Shivananda Rao Guru
    Currently Being Moderated
    Hello,
    env|grep _SID
    ORACLE_SID=+ASM
    sqlplus / as sysdba
    SQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 21 09:45:18 2012
    Copyright (c) 1982, 2011, Oracle. All rights reserved.
    Connected to an idle instance.
    Set the ORACLE_HOME to the GRID home and ORACLE_SID to ASM instance and then connect. Hope it helps !!
    export ORACLE_SID=+ASM
    export ORACLE_HOME=<your GRID Home path on the server>
    sqlplus / as sysasm
    Regards,
    Shivananda
  • 8. Re: Idle ASM-instance in list of processess
    Pavel Explorer
    Currently Being Moderated
    Hello Shivananda

    Thank You.
    ORACLE_HOME and ORACLE_SID was set correctly,
    and at the same time smon exist , but insstance at level of sqlplus is idle

    Thanks and best regards,
    Pavel
  • 9. Re: Idle ASM-instance in list of processess
    Shivananda Rao Guru
    Currently Being Moderated
    Could you please post the outcome of all the 3 steps ?
    export ORACLE_SID=+ASM
    export ORACLE_HOME=<your Grid Home path on the server>
    sqlplus / as sysasm
    Regards,
    Shivananda
  • 10. Re: Idle ASM-instance in list of processess
    Pavel Explorer
    Currently Being Moderated
    Hello again Shivananda

    Yes, Sir
    export ORACLE_SID=+ASM
    export ORACLE_HOME=/u/oracle/grid
    sqlplus / as sysasm
    SQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 21 10:28:40 2012
    Copyright (c) 1982, 2011, Oracle. All rights reserved.
    Connected to an idle instance.
    Thanks and regards,
    Pavel
  • 11. Re: Idle ASM-instance in list of processess
    Shivananda Rao Guru
    Currently Being Moderated
    Try to kill the existing ASM pmon process and then check. Though I do not recommend it, besides considering that you are connecting to the right ASM instance and you have all the approvals to do it.


    Regards,
    Shivananda

Legend

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