`
xitong
  • 浏览: 6147751 次
文章分类
社区版块
存档分类
最新评论

Linux下使用ps命令来查看Oracle DB以及EBS相关的进程

 
阅读更多

Linux下可以使用ps命令来查看Oracle相关的进程

使用ps来查看Oracle数据库相关的服务

Oracle Listener

这个命令会列出Oracle Net Listener的进程

[oracle@bej301441 ~]$ ps -ef | grep tnslsnr
oracle    1999 29986  0 09:47 pts/2    00:00:00 grep tnslsnr
oracle    3647     1  0 Jul03 ?        00:00:34 /u01/oracle/mc3yd213/db/tech_st/11.1.0/bin/tnslsnr mc3yd213 -inherit
oracle    6431     1  0 Jul03 ?        00:00:00 /u01/oracle/mc3yd213/apps/tech_st/10.1.2/bin/tnslsnr APPS_mc3yd213 -inherit
oracle   13616     1  0 May27 ?        00:00:40 /u01/oracle/mc3yd213/apps/tech_st/10.1.2/bin/tnslsnr LISTENER -inherit
[oracle@bej301441 ~]$

Oracle DB Background Process

[oracle@bej301441 ~]$ ps -ef | grep -i "ora_"
oracle    1887     1  0 09:42 ?        00:00:00 ora_w000_mc3yd213
oracle    2159     1  0 09:54 ?        00:00:00 ora_j000_mc3yd213
oracle    2167 29986  0 09:55 pts/2    00:00:00 grep -i ora_
oracle    3516     1  0 Jul03 ?        00:02:00 ora_pmon_mc3yd213
oracle    3518     1  0 Jul03 ?        00:02:08 ora_vktm_mc3yd213
oracle    3522     1  0 Jul03 ?        00:00:27 ora_diag_mc3yd213
oracle    3524     1  0 Jul03 ?        00:00:18 ora_dbrm_mc3yd213
oracle    3526     1  0 Jul03 ?        00:00:35 ora_psp0_mc3yd213
oracle    3528     1  0 Jul03 ?        00:05:59 ora_dia0_mc3yd213
oracle    3530     1  0 Jul03 ?        00:00:19 ora_mman_mc3yd213
oracle    3532     1  0 Jul03 ?        00:01:06 ora_dbw0_mc3yd213
oracle    3534     1  0 Jul03 ?        00:02:53 ora_lgwr_mc3yd213
oracle    3536     1  0 Jul03 ?        00:02:08 ora_ckpt_mc3yd213
oracle    3538     1  0 Jul03 ?        00:01:36 ora_smon_mc3yd213
oracle    3540     1  0 Jul03 ?        00:00:06 ora_reco_mc3yd213
oracle    3542     1  0 Jul03 ?        00:02:01 ora_mmon_mc3yd213
oracle    3544     1  0 Jul03 ?        00:03:20 ora_mmnl_mc3yd213
oracle    3564     1  0 Jul03 ?        00:00:09 ora_fbda_mc3yd213
oracle    3569     1  0 Jul03 ?        00:00:16 ora_qmnc_mc3yd213
oracle    3584     1  0 Jul03 ?        00:00:36 ora_q000_mc3yd213
oracle    3586     1  0 Jul03 ?        00:00:15 ora_q001_mc3yd213
oracle    3690     1  0 Jul03 ?        00:02:30 ora_cjq0_mc3yd213
oracle    3707     1  0 Jul03 ?        00:00:28 ora_smco_mc3yd213
oracle    7676     1  0 Jul03 ?        00:42:49 ora_m000_mc3yd213
[oracle@bej301441 ~]$
eg.ora_pmon_mc3yd213 is PMON process,PMON (Process MONitor) is an Oracle background process created when you start a database instance. The PMON process will free up resources if a user process fails (eg. release database locks).

这些后台进程,从数据库里也是能查到的,可以使用下边这个SQL来查后台进程,在program列中,你就能看到SMON,MMON,CKPT,PMON,MMAN,MMNL...后台进程

select * FROM v$session WHERE type ='BACKGROUND';
关于后台进程,可以参见Oracle Background processes

Oracle Management Agent

[oracle@bej301441 ~]$ ps -ef | grep emagent
oracle    2097 29986  0 09:51 pts/2    00:00:00 grep emagent
oraem     3130     1  0 May24 ?        00:08:57 /opt/oracle/oraem/agent10g/perl/bin/perl /opt/oracle/oraem/agent10g/bin/emwd.pl agent /opt/oracle/oraem/agent10g/sysman/log/emagent.nohup
oraem     3150  3130  0 May24 ?        00:25:56 /opt/oracle/oraem/agent10g/bin/emagent
[oracle@bej301441 ~]$


使用ps来查看Oracle EBS 相关的服务


sendmail,邮件服务

ps -ef | grep sendmail


FNDLIBR:Concurrent Manager

ps -ef | grep FNDLIBR

FNDLIBR process indicates that concurrent mnagers are up and requests are running on the system.Sometimes it happens that even after stopping the concurrent managers by adcmctl.sh stop apps/apps some of the requests might continue running. In such cases you can wait for say 5 minutes and then if it dos not stop then you can kill those FNDLIBR processes bykill -9 <processid>

FNDLIBR manages following Managers

Marketing Data Mining Manager
Transportation Manager
Session History Cleanup
UWQ Worklist Items Release for Crashed session
Collections Manager
OAM Metrics Collection Manager
Contracts Core Concurrent Manager
Standard Manager
WMS Task Archiving Manager
Oracle Provisioning Manager


FNDSM is the process for the Service Manager

We need to configure GSM and start the Apps Listener in order to start GSM Service on all Nodes in Application Tier in E-Business Suite.

ps -ef | grep FNDSM


其他Concurrent Manager Processes

INVLIBR is the process for Inventory Managers

Inventory Manager

[oracle@bej301441 ~]$ ps -ef | grep INVLIBR
oracle 7111 7004 0 Jul03 ? 00:00:07 INVLIBR
oracle 14016 13573 0 19:40 pts/5 00:00:00 grep INVLIBR
[oracle@bej301441 ~]$


RCVOLTM is the process for Inventory Managers

Receiving Transaction Manager

[oracle@bej301441 ~]$ ps -ef | grep RCVOLTM
oracle 5722 5665 0 20:03 ? 00:00:00 RCVOLTM APPS/ZG618E73E514A4DB6225B5C0715E84E394B33DBF1597FF0B87AACB0D0C0DE3A77B75C66CDEF4E51EC835DCEA339CB13E22 PO RCVOLTM N 60 t LOCK Y BEJ301441 2061280
oracle 5723 5665 0 20:03 ? 00:00:00 RCVOLTM APPS/ZG8CAFF65062AF8E7E4B36CA3576D3140CE7E02C1F9C6E2C78AD0977EE29FD88EF68B0B33B5289F0C835DCEA339CB13E22 PO RCVOLTM14 N 60 t LOCK Y BEJ301441 2061281
oracle 17386 16905 0 20:39 pts/15 00:00:00 grep RCVOLTM
[oracle@bej301441 ~]$



MRCLIB is the process for the following Managers

MRP Manager

[oracle@bej301441 ~]$ ps -ef | grep MRCLIB
oracle 7113 7004 0 Jul03 ? 00:00:06 MRCLIB
oracle 14024 13573 0 19:40 pts/5 00:00:00 grep MRCLIB
[oracle@bej301441 ~]$



PALIBR is the process for the following Managers

PA Streamline Manager

[oracle@bej301441 ~]$ ps -ef | grep PALIBR
oracle 7110 7004 0 Jul03 ? 00:00:06 PALIBR
oracle 14003 13573 0 19:39 pts/5 00:00:00 grep PALIBR
[oracle@bej301441 ~]$


frmweb:form server

ps -ef | grep frmweb



httpd:应用服务器进程

ps -ef | grep httpd



查看Apache Server是否启动

ps –ef | grep Apache



查看WMA MSCA进程是否启动

ps -ef | grep mwa

[oracle@bej301441 ~]$  ps -ef|grep mwa
oracle     995     1  0 Jun01 ?        01:01:37 /u01/oracle/mc3yd213/apps/tech_st/10.1.3/appsutil/jdk/bin/java -DCLIENT_PROCESSID=995 -Doracle.apps.mwa=/u01/oracle/mc3yd213/apps/apps_st/appl/mwa/12.0.0 -Doracle.apps.jrad.mmd=/u01/oracle/mc3yd213/apps/apps_st/comn/webapps/oacore/html/jrad -Doracle.apps.inst=/u01/oracle/mc3yd213/inst/apps/mc3yd213_bej301441 -mx512m -ms128m oracle.apps.mwa.presentation.telnet.Listener 20002
oracle    1051     1  0 Jun06 ?        00:52:00 /u01/oracle/mc3yd213/apps/tech_st/10.1.3/appsutil/jdk/bin/java -DCLIENT_PROCESSID=1051 -Doracle.apps.mwa=/u01/oracle/mc3yd213/apps/apps_st/appl/mwa/12.0.0 -Doracle.apps.jrad.mmd=/u01/oracle/mc3yd213/apps/apps_st/comn/webapps/oacore/html/jrad -Doracle.apps.inst=/u01/oracle/mc3yd213/inst/apps/mc3yd213_bej301441 -mx512m -ms128m oracle.apps.mwa.presentation.telnet.Listener 10000
oracle    5418     1  0 Jun07 ?        00:50:17 /u01/oracle/mc3yd213/apps/tech_st/10.1.3/appsutil/jdk/bin/java -DCLIENT_PROCESSID=5418 -Doracle.apps.mwa=/u01/oracle/mc3yd213/apps/apps_st/appl/mwa/12.0.0 -Doracle.apps.jrad.mmd=/u01/oracle/mc3yd213/apps/apps_st/comn/webapps/oacore/html/jrad -Doracle.apps.inst=/u01/oracle/mc3yd213/inst/apps/mc3yd213_bej301441 -mx512m -ms128m oracle.apps.mwa.presentation.telnet.Listener 10120
oracle    5477     1  0 Jun07 ?        00:50:36 /u01/oracle/mc3yd213/apps/tech_st/10.1.3/appsutil/jdk/bin/java -DCLIENT_PROCESSID=5477 -Doracle.apps.mwa=/u01/oracle/mc3yd213/apps/apps_st/appl/mwa/12.0.0 -Doracle.apps.jrad.mmd=/u01/oracle/mc3yd213/apps/apps_st/comn/webapps/oacore/html/jrad -Doracle.apps.inst=/u01/oracle/mc3yd213/inst/apps/mc3yd213_bej301441 -mx512m -ms128m oracle.apps.mwa.presentation.telnet.Listener 10130
oracle    6495  6316  0 21:24 pts/5    00:00:00 grep mwa
oracle   24042     1  0 May30 ?        01:03:49 /u01/oracle/mc3yd213/apps/tech_st/10.1.3/appsutil/jdk/bin/java -DCLIENT_PROCESSID=24042 -Doracle.apps.mwa=/u01/oracle/mc3yd213/apps/apps_st/appl/mwa/12.0.0 -Doracle.apps.jrad.mmd=/u01/oracle/mc3yd213/apps/apps_st/comn/webapps/oacore/html/jrad -Doracle.apps.inst=/u01/oracle/mc3yd213/inst/apps/mc3yd213_bej301441 -mx512m -ms128m oracle.apps.mwa.presentation.telnet.Listener 10973
oracle   27771     1  0 Jul11 pts/4    00:01:35 /u01/oracle/mc3yd213/apps/tech_st/10.1.3/appsutil/jdk/bin/java -DCLIENT_PROCESSID=27771 -Doracle.apps.mwa=/u01/oracle/mc3yd213/apps/apps_st/appl/mwa/12.0.0 -Doracle.apps.jrad.mmd=/u01/oracle/mc3yd213/apps/apps_st/comn/webapps/oacore/html/jrad -Doracle.apps.inst=/u01/oracle/mc3yd213/inst/apps/mc3yd213_bej301441 -mx512m -ms128m oracle.apps.mwa.presentation.telnet.Listener 10987
oracle   28023     1  0 May30 ?        01:04:06 /u01/oracle/mc3yd213/apps/tech_st/10.1.3/appsutil/jdk/bin/java -DCLIENT_PROCESSID=28023 -Doracle.apps.mwa=/u01/oracle/mc3yd213/apps/apps_st/appl/mwa/12.0.0 -Doracle.apps.jrad.mmd=/u01/oracle/mc3yd213/apps/apps_st/comn/webapps/oacore/html/jrad -Doracle.apps.inst=/u01/oracle/mc3yd213/inst/apps/mc3yd213_bej301441 -mx512m -ms128m oracle.apps.mwa.presentation.telnet.Listener 11888
oracle   28682     1  0 May30 ?        01:05:58 /u01/oracle/mc3yd213/apps/tech_st/10.1.3/appsutil/jdk/bin/java -DCLIENT_PROCESSID=28682 -Doracle.apps.mwa=/u01/oracle/mc3yd213/apps/apps_st/appl/mwa/12.0.0 -Doracle.apps.jrad.mmd=/u01/oracle/mc3yd213/apps/apps_st/comn/webapps/oacore/html/jrad -Doracle.apps.inst=/u01/oracle/mc3yd213/inst/apps/mc3yd213_bej301441 -mx512m -ms128m oracle.apps.mwa.presentation.telnet.Listener 11988
oracle   31596     1  0 May29 ?        01:05:26 /u01/oracle/mc3yd213/apps/tech_st/10.1.3/appsutil/jdk/bin/java -DCLIENT_PROCESSID=31596 -Doracle.apps.mwa=/u01/oracle/mc3yd213/apps/apps_st/appl/mwa/12.0.0 -Doracle.apps.jrad.mmd=/u01/oracle/mc3yd213/apps/apps_st/comn/webapps/oacore/html/jrad -Doracle.apps.inst=/u01/oracle/mc3yd213/inst/apps/mc3yd213_bej301441 -mx512m -ms128m oracle.apps.mwa.presentation.telnet.Listener 10020
oracle   32530     1  0 Jun07 ?        00:50:37 /u01/oracle/mc3yd213/apps/tech_st/10.1.3/appsutil/jdk/bin/java -DCLIENT_PROCESSID=32530 -Doracle.apps.mwa=/u01/oracle/mc3yd213/apps/apps_st/appl/mwa/12.0.0 -Doracle.apps.jrad.mmd=/u01/oracle/mc3yd213/apps/apps_st/comn/webapps/oacore/html/jrad -Doracle.apps.inst=/u01/oracle/mc3yd213/inst/apps/mc3yd213_bej301441 -mx512m -ms128m oracle.apps.mwa.presentation.telnet.Listener 10110
[oracle@bej301441 ~]$


参考:https://forums.oracle.com/forums/thread.jspa?threadID=878998

https://forums.oracle.com/forums/thread.jspa?threadID=553892

http://www.reachdba.com/showthread.php?466-Types-Of-Concurrent-Managers-and-Concurrent-Processes

转载请注明出处:http://blog.csdn.net/pan_tian/article/details/7734892

======EOF======


分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics