Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Checking Oracle user Process in unix

RE: Checking Oracle user Process in unix

From: Jyoti N <jnair75_at_hotmail.com>
Date: Thu, 16 Aug 2001 11:20:16 -0700
Message-ID: <F001.0036DAF5.20010816113244@fatcity.com>

Whenever you say $sqlplus ,
Oracle spawns a dedicated server process to connect to database using Bequeath protocol (in this case) which bypasses the listener ,I guess.
When you use the connect string(sqlplus@), Oracle connects thru the listener process/port(whatever), so probably, it does not require to spawn another process.
HTH,
Jyoti
>From: Narender Akula 
>Reply-To: ORACLE-L@fatcity.com 
>To: Multiple recipients of list ORACLE-L 
>Subject: RE: Checking Oracle user Process in unix 
>Date: Wed, 15 Aug 2001 19:40:33 -0800 
> 
>Hi Babette, 
> 
>1) the Instance and user2,user1 are on same mechine. so no dblink...no 
>listener involved. 
>2) user1,user2 is not using any sql* net connections.but still for user1 
>shadow process shows but not for user2. 
> the only difference 
>is user1 is connecting explicitly (sqlplus username/password) 
>and user 2 is connecting via shell scripts. (/BDE/v1/tlcrs_load_tables/x.sh 
>--> sqlplus username/password). 
> 
>naren 
>-----Original Message----- 
>Sent: Thursday, 16 August 2001 14:16 
>To: Multiple recipients of list ORACLE-L 
> 
> 
>Two possible reasons 
> 
>1) crsprod (the database for the db link) is on a remote machine. 
>In that case, the dedicated server will not show on this machine. 
> 
>2) For SQL*net connections, the dedicated server sessions are created and 
>owned by the oracle user. 
> 
>- Babette 
>----- Original Message ----- 
>To: "Multiple recipients of list ORACLE-L" 
>Sent: Wednesday, August 15, 2001 8:55 PM 
> 
> 
> > hi List, 
> > 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@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@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. 
> > 
> > can somebody tell me what is happening here? am i missing something. 
> > 
> 
> 
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com 
>-- 
>Author: Babette Turner-Underwood 
> INET: babattt@home.com 
> 
>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@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). 
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com 
>-- 
>Author: Narender Akula 
> INET: narender.akula@terralinkinternational.com 
> 
>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@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). 
Get your FREE download of MSN Explorer at http://explorer.msn.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jyoti N
  INET: jnair75@hotmail.com

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@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).
Received on Thu Aug 16 2001 - 13:20:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US