RE: Checking Oracle user Process in unix

Actually, if you look carefully, it looks like user2 is connecting remotely (tlcrsdev/tlcrsdev_at_crsprod). The Oracle server process is on whatever server "crsprod" lives on.

I assume you changed the passwords in your mail before mailing them out to hundreds of people on an internet mailing list.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Wed, 15 Aug 2001, Deshpande, Kirti wrote:



> User2 has not yet logged in after running sqlplus, when he connects oracle's

> shadow process will start.

>

> > -----Original Message-----

> > From:       Narender Akula [SMTP:narender.akula_at_terralinkinternational.com]

> >

> > I am checking some oracle users (user1 and user2) processes (sunsolaris)

> > using ps -ef|grep.

> >

> > $ps -ef|grep sqlplus

> >  user1 26671  5991  0 10:36:35 pts/20   0:00 sqlplus sys

> >   me  27415 25766  0 11:47:36 pts/17   0:00 grep sqlplus

> >  user2 27408 26250  0 11:46:27 pts/7    0:00 sqlplus

> > tlcrsdev/tlcrsdev_at_crsprod @/home/dcook/TIPS/BDE/v1/tlcrs_load_tables/lo

> >

> > checking oracle process...for user1

> > $ps -ef|grep  26671

> >   user1 26671  5991  0 10:36:35 pts/20   0:00 sqlplus sys

> >   oracle 26672 26671  0 10:36:38 ?        0:00 oracleTERAPROD

> > (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

> >

> > checking oracle process .. for user2 (running script for shell program-

> > updating table)

> > $ps -ef|grep 27408

> >    dcook 27408 26250  0 11:46:27 pts/7    0:00 sqlplus

> > tlcrsdev/tlcrsdev_at_crsprod @/home/dcook/TIPS/BDE/v1/tlcrs_load_tables/lo

> >

> > My question is for user2 why I am not able to see the oracle process.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeremiah Wilton
  INET: jwilton_at_speakeasy.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).