Wednesday, July 27, 2011

How to tell if Oracle XE is running on your box

you should have these processes running on your box:


/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr LISTENER -inherit
xe_pmon_XE
xe_psp0_XE
xe_mman_XE
xe_dbw0_XE
xe_lgwr_XE
xe_ckpt_XE
xe_smon_XE
xe_reco_XE
xe_cjq0_XE
xe_mmon_XE
xe_mmnl_XE
xe_d000_XE
xe_s000_XE
xe_s001_XE
xe_s002_XE
xe_s003_XE
xe_qmnc_XE
xe_q000_XE
xe_q001_XE




and if you do
netstat -an | grep 1521
you should get:

tcp 0 0 0.0.0.0:1521 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:54868 127.0.0.1:1521 ESTABLISHED
tcp 0 0 127.0.0.1:1521 127.0.0.1:54868 ESTABLISHED


No comments: