This discussion is archived
1 2 Previous Next 26 Replies Latest reply: Feb 26, 2010 1:35 PM by 743319 RSS

pmon not shows up as running on linux

743319 Newbie
Currently Being Moderated
Hello everybody,
I have two database instances running on fedora 12 for my test purposes but I have a strange problem. when I run ps -ef | grep pmon I don't see any pmon running even though both of the databases are up and running? but when I run select PID, Program from v$process from sqlplus I can see that pmon is running. can someone tell me why i don't see pmon as running process when I do ps -ef?

actually it is not just pmon but all other oracle background processes not showing up under ps -ef.

Thanks,
Viral

Edited by: user4297617 on Dec 28, 2009 7:56 AM

Edited by: user4297617 on Dec 28, 2009 7:58 AM
  • 1. Re: pmon not shows up as running on linux
    Aman.... Oracle ACE
    Currently Being Moderated
    user4297617 wrote:
    Hello everybody,
    I have two database instances running on fedora 12 for my test purposes but I have a strange problem. when I run ps -ef | grep pmon I don't see any pmon running even though both of the databases are up and running? but when I run select PID, Program from v$process from sqlplus I can see that pmon is running. can someone tell me why i don't see pmon as running process when I do ps -ef?
    This is weird. Are you sure that the instances of both the databases is started? Can you confirm this by connecting to both the databases and also can post the result here as well? Did you try searching for the process id shown in oralce view V$process over the o/s? If the instance is started, PMON must be up and be visible!

    HTH
    Aman....
  • 2. Re: pmon not shows up as running on linux
    591186 Guru
    Currently Being Moderated
    Post the results of:

    ps -aef |grep pmon


    -Anantha
  • 3. Re: pmon not shows up as running on linux
    sb92075 Guru
    Currently Being Moderated
    ps -ef | grep mon_v102
    oracle 4713 1 0 08:02 ? 00:00:00 ora_pmon_v102
    oracle 4725 1 1 08:02 ? 00:00:00 ora_smon_v102
    oracle 4731 1 3 08:02 ? 00:00:01 ora_mmon_v102
    bcm 4765 3628 0 08:03 pts/0 00:00:00 grep mon_v102


    works for me
  • 4. Re: pmon not shows up as running on linux
    743319 Newbie
    Currently Being Moderated
    I know it is kind of weird. as you see below, i can connect to database.

    $ sqlplus

    SQL*Plus: Release 10.2.0.1.0 - Production on Mon Dec 28 10:10:30 2009

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    Enter user-name: sys as sysdba
    Enter password:

    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
    With the Partitioning, OLAP and Data Mining options

    SQL> select name from v$database;

    NAME
    ---------
    ORCL

    and here is copy of v$process from sqlplus

    SQL> select pid, spid, program from v$process;

    PID SPID PROGRAM
    ---------- ------------ ------------------------------------------------
    1 PSEUDO
    2 21904 oracle@hd151653 (PMON)
    3 21906 oracle@hd151653 (PSP0)
    4 21908 oracle@hd151653 (MMAN)
    5 21910 oracle@hd151653 (DBW0)
    6 21912 oracle@hd151653 (LGWR)
    7 21914 oracle@hd151653 (CKPT)
    8 21916 oracle@hd151653 (SMON)
    9 21918 oracle@hd151653 (RECO)
    10 21920 oracle@hd151653 (CJQ0)
    11 21922 oracle@hd151653 (MMON)

    PID SPID PROGRAM
    ---------- ------------ ------------------------------------------------
    12 21924 oracle@hd151653 (MMNL)
    13 21926 oracle@hd151653 (D000)
    14 21928 oracle@hd151653 (S000)
    15 24469 oracle@hd151653 (TNS V1-V3)
    16 21952 oracle@hd151653 (ARC0)
    17 21954 oracle@hd151653 (ARC1)
    19 21958 oracle@hd151653 (QMNC)
    20 21995 oracle@hd151653 (q000)
    27 22000 oracle@hd151653 (q001)

    20 rows selected.

    but when I do ps -ef | grep pmon this is all I see

    [oracle@hd151653 ~]$ ps -ef | grep pmon
    oracle 24804 22075 0 10:17 pts/3 00:00:00 grep pmon
    [oracle@hd151653 ~]$ ps -ef | grep mon_v102
    oracle 24852 22075 0 10:18 pts/3 00:00:00 grep mon_v102

    any clue?

    Thanks.
  • 5. Re: pmon not shows up as running on linux
    sb92075 Guru
    Currently Being Moderated
    try following

    ps -ef | grep -i mon
  • 6. Re: pmon not shows up as running on linux
    743319 Newbie
    Currently Being Moderated
    this is all I see but nothing related to oracle process.

    [oracle@hd151653 ~]$ ps -ef | grep -i mon
    dbus 1180 1 0 Dec21 ? 00:00:03 dbus-daemon --system
    avahi 1190 1 0 Dec21 ? 00:00:00 avahi-daemon: running [hd151653.local]
    avahi 1191 1190 0 Dec21 ? 00:00:00 avahi-daemon: chroot helper
    root 1247 1 0 Dec21 ? 00:00:00 /usr/sbin/console-kit-daemon
    root 1663 1 0 Dec21 ? 00:00:00 libvirtd --daemon
    root 1671 1 0 Dec21 ? 00:00:00 /usr/sbin/gdm-binary -nodaemon
    root 1794 1 0 Dec21 ? 00:00:00 /usr/libexec/devkit-power-daemon
    rtkit 1839 1 0 Dec21 ? 00:00:02 /usr/libexec/rtkit-daemon
    oracle 1889 1 0 Dec21 ? 00:00:00 /usr/bin/gnome-keyring-daemon daemonize login
    oracle 14945 1 0 Dec22 ? 00:00:00 /usr/bin/gnome-keyring-daemon daemonize login
    oracle 18279 1 0 08:11 ? 00:00:00 /usr/bin/gnome-keyring-daemon daemonize login
    oracle 18318 1 0 08:11 ? 00:00:01 /bin/dbus-daemon fork print-pid 7 print-address 9 session
    oracle 18422 1 0 08:11 ? 00:00:00 /usr/bin/gpg-agent -s daemon write-env-file
    oracle 18563 1 0 08:11 ? 00:00:00 /usr/libexec/im-settings-daemon
    oracle 18585 1 0 08:11 ? 00:00:00 /usr/libexec/notification-daemon
    oracle 18614 1 0 08:11 ? 00:00:00 /usr/libexec//gvfs-fuse-daemon /home/oracle/.gvfs
    oracle 18744 1 0 08:11 ? 00:00:00 /usr/libexec/gconf-im-settings-daemon
    root 21319 1 0 Dec22 ? 00:00:10 /usr/libexec/devkit-disks-daemon
    root 21320 21319 0 Dec22 ? 00:00:56 devkit-disks-daemon: polling /dev/sr0
  • 7. Re: pmon not shows up as running on linux
    mbobak Oracle ACE
    Currently Being Moderated
    Connect to Oracle, then do:
    select host_name from v$instance;

    then exit SQL*Plus, and execute hostname at the shell prompt:
    $ hostname

    Do the two outputs match?

    -Mark
  • 8. Re: pmon not shows up as running on linux
    743319 Newbie
    Currently Being Moderated
    yes both hostname matches.

    SQL> select host_name from v$instance;

    HOST_NAME
    ----------------------------------------------------------------
    hd151653

    [oracle@hd151653 ~]$ hostname
    hd151653
  • 9. Re: pmon not shows up as running on linux
    sb92075 Guru
    Currently Being Moderated
    post results from following

    env | sort

    Does any type of Operating System virtualization exist on this system?
  • 10. Re: pmon not shows up as running on linux
    Nicolas.Gasparotto Oracle ACE
    Currently Being Moderated
    And what if you're looking for the process number ?
    ps -ef|grep 21904
    Nicolas.
  • 11. Re: pmon not shows up as running on linux
    743319 Newbie
    Currently Being Moderated
    this is what I get from ps -ef | grep 210904

    [oracle@hd151653 orcl]$ ps -ef | grep 21904
    oracle 21904 1 0 09:11 ? 00:00:00 /opt/oracle/product/10.2.0/db_2//bin/oracle.bin
    oracle 25566 22075 0 10:36 pts/3 00:00:00 grep 21904
  • 12. Re: pmon not shows up as running on linux
    367117 Journeyer
    Currently Being Moderated
    From SQLPlus...

    SQL>select pid, spid, program from v$process;

    and then

    SQL>!ps -ef | grep -i pmon

    also,

    post the results of

    env | sort

    Do you have oracle or oracle.bin under ORACLE_HOME/bin ?
  • 13. Re: pmon not shows up as running on linux
    743319 Newbie
    Currently Being Moderated
    SQL> select pid, spid, program from v$process;

    PID SPID PROGRAM
    ---------- ------------ ------------------------------------------------
    1 PSEUDO
    2 21904 oracle@hd151653 (PMON)
    3 21906 oracle@hd151653 (PSP0)
    4 21908 oracle@hd151653 (MMAN)
    5 21910 oracle@hd151653 (DBW0)
    6 21912 oracle@hd151653 (LGWR)
    7 21914 oracle@hd151653 (CKPT)
    8 21916 oracle@hd151653 (SMON)
    9 21918 oracle@hd151653 (RECO)
    10 21920 oracle@hd151653 (CJQ0)
    11 21922 oracle@hd151653 (MMON)

    PID SPID PROGRAM
    ---------- ------------ ------------------------------------------------
    12 21924 oracle@hd151653 (MMNL)
    13 21926 oracle@hd151653 (D000)
    14 21928 oracle@hd151653 (S000)
    15 24469 oracle@hd151653 (TNS V1-V3)
    16 21952 oracle@hd151653 (ARC0)
    17 21954 oracle@hd151653 (ARC1)
    18 25160 oracle.bin@hd151653
    19 21958 oracle@hd151653 (QMNC)
    20 21995 oracle@hd151653 (q000)
    27 22000 oracle@hd151653 (q001)

    21 rows selected.
    -----------------------------------------------------------------------------
    SQL> !ps -ef | grep -i pmon
    oracle 26842 24468 0 11:01 pts/2 00:00:00 /bin/bash -c ps -ef | grep -i pmon
    oracle 26844 26842 0 11:01 pts/2 00:00:00 grep -i pmon
    ----------------------------------------------------------------------------------
    [oracle@hd151653 orcl]$ env | sort
    CLASSPATH=/opt/oracle/product/10.2.0/db_2/JRE:/opt/oracle/product/10.2.0/db_2/jlib:/opt/oracle/product/10.2.0/db_2/rdbms/jlib
    COLORFGBG=15;0
    CVS_RSH=ssh
    DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-AUQIukzPLC,guid=499dcda335b55405758715224b38bc97
    DESKTOP_SESSION=kde
    DESKTOP_STARTUP_ID=
    DISABLE_IMSETTINGS=1
    DISPLAY=:0.0
    DRY_RUN=1
    G_BROKEN_FILENAMES=1
    GDM_KEYBOARD_LAYOUT=us
    GDM_LANG=en_US.UTF-8
    GDMSESSION=kde
    GNOME_KEYRING_PID=18279
    GNOME_KEYRING_SOCKET=/tmp/keyring-WKYSg2/socket
    GPG_AGENT_INFO=/tmp/gpg-TJ44Fw/S.gpg-agent:18422:1
    GS_LIB=
    GTK2_RC_FILES=/etc/gtk-2.0/gtkrc:/home/oracle/.gtkrc-2.0:/home/oracle/.gtkrc-2.0-kde4:/home/oracle/.kde/share/config/gtkrc-2.0
    GTK_IM_MODULE=gtk-im-context-simple
    GTK_RC_FILES=/etc/gtk/gtkrc:/home/oracle/.gtkrc::/home/oracle/.kde/share/config/gtkrc
    HISTCONTROL=ignoreboth
    HISTSIZE=1000
    HOME=/home/oracle
    HOSTNAME=hd151653
    IMSETTINGS_INTEGRATE_DESKTOP=yes
    IMSETTINGS_MODULE=none
    KDEDIRS=/usr
    KDE_FULL_SESSION=true
    KDE_IS_PRELINKED=1
    KDE_MULTIHEAD=false
    KDE_SESSION_UID=501
    KDE_SESSION_VERSION=4
    KONSOLE_DBUS_SERVICE=:1.52
    KONSOLE_DBUS_SESSION=/Sessions/3
    LANG=en_US.UTF-8
    LANGUAGE=
    LD_LIBRARY_PATH=/opt/oracle/product/10.2.0/db_2/lib:/lib:/usr/lib
    LESSOPEN=|/usr/bin/lesspipe.sh %s
    LOGNAME=oracle
    LS_COLORS=rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:mi=01;05;37;41:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.tbz=01;31:*.tbz2=01;31:*.bz=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=01;36:*.au=01;36:*.flac=01;36:*.mid=01;36:*.midi=01;36:*.mka=01;36:*.mp3=01;36:*.mpc=01;36:*.ogg=01;36:*.ra=01;36:*.wav=01;36:*.axa=01;36:*.oga=01;36:*.spx=01;36:*.xspf=01;36:
    MAIL=/var/spool/mail/oracle
    OLDPWD=/home/oracle
    ORACLE_BASE=/opt/oracle
    ORACLE_HOME=/opt/oracle/product/10.2.0/db_2
    ORACLE_HOSTNAME=hd151653.mycompany.org
    PATH=/home/oracle/Downloads/gqlplus-1.12:/opt/oracle/product/10.2.0/db_2/bin:/usr/lib64/qt-3.3/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/lib64/ccache:/usr/local/bin:/usr/bin:/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oracle/bin
    PROFILEHOME=
    PWD=/opt/oracle/oradata/orcl
    QTDIR=/usr/lib64/qt-3.3
    QT_IM_MODULE=xim
    QTINC=/usr/lib64/qt-3.3/include
    QTLIB=/usr/lib64/qt-3.3/lib
    QT_PLUGIN_PATH=/home/oracle/.kde/lib64/kde4/plugins/:/usr/lib64/kde4/plugins/
    SESSION_MANAGER=local/unix:@/tmp/.ICE-unix/18505,unix/unix:/tmp/.ICE-unix/18505
    SHELL=/bin/bash
    SHLVL=3
    SSH_AGENT_PID=18367
    SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
    SSH_AUTH_SOCK=/tmp/ssh-KNUnH18308/agent.18308
    TERM=xterm
    TMPDIR=/tmp
    TMP=/tmp
    USERNAME=oracle
    USER=oracle
    _=/usr/bin/env
    WINDOWID=56661167
    XAUTHORITY=/var/run/gdm/auth-for-oracle-DKvjhk/database
    XCURSOR_THEME=default
    XDG_DATA_DIRS=/usr/share/kde-settings/kde-profile/default/share:/usr/local/share:/usr/share
    XDG_MENU_PREFIX=kde4-
    XDG_SESSION_COOKIE=5afc8e47d8b36ba1176caf4c4b29a200-1262009495.206657-1175313778
    XMODIFIERS=@im=none
  • 14. Re: pmon not shows up as running on linux
    367117 Journeyer
    Currently Being Moderated
    one more

    ls -ltr $ORACLE_HOME/bin/oracle*

    Do you have oracle or oracle.bin under $ORACLE_HOME/bin ?
1 2 Previous Next

Legend

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