1 2 Previous Next 26 Replies Latest reply: Feb 26, 2010 3:35 PM by 743319 RSS

    pmon not shows up as running on linux

    743319
      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....
          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
            Post the results of:

            ps -aef |grep pmon


            -Anantha
            • 3. Re: pmon not shows up as running on linux
              sb92075
              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
                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
                  try following

                  ps -ef | grep -i mon
                  • 6. Re: pmon not shows up as running on linux
                    743319
                    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
                      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
                        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
                          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
                            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
                              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
                                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
                                  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
                                    one more

                                    ls -ltr $ORACLE_HOME/bin/oracle*

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