OraFAQ Forum: Server Administration » Unable to find the server process in the oracle database for a specific application/client

Home » RDBMS Server » Server Administration » Unable to find the server process in the oracle database for a specific application/client (Oracle 11.2.0.3 / OEL 5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Unable to find the server process in the oracle database for a specific application/client [message #577252]

Wed, 13 February 2013 13:59

jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai

Senior Member

Hi All,

I am trying to find the unix process for one of my application in the database but I am unable to view the same. To simulate, I did the following.

1. My database runs on different server.
2. I invoked "sqlplus" from another unix box to login to the database.
3. I found that the process id

(ps -ef |grep sqlplus)

.
4. When I execute the below mentioned query it does not display the process id that I am looking for. But the osuser, username, program and machine details are correct. How can I know the process details from the database?

SELECT SYS.GV_$SESSION.OSUSER, SYS.GV_$SESSION.USERNAME, SYS.GV_$PROCESS.SPID,
	   SYS.GV_$SESSION.MACHINE, SYS.GV_$SESSION.PROGRAM, 
           SYS.GV_$PROCESS.PROGRAM ,SYS.GV_$SESSION.SQL_ID 
       FROM  
           SYS.GV_$PROCESS, SYS.GV_$SESSION  
       WHERE  
           SYS.GV_$PROCESS.ADDR=SYS.GV_$SESSION.PADDR and SYS.GV_$SESSION.USERNAME='TEST'
           and SYS.GV_$SESSION.MACHINE like '%hostname%'

Regards,
Antony

Report message to a moderator

Re: Unable to find the server process in the oracle database for a specific application/client [message #577253 is a reply to message #577252]

Wed, 13 February 2013 14:16

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SELECT SYS.GV_$SESSION.OSUSER, SYS.GV_$SESSION.USERNAME, SYS.GV_$PROCESS.SPID, SYS.GV_SESSION.PROCESS

Report message to a moderator

Re: Unable to find the server process in the oracle database for a specific application/client [message #577254 is a reply to message #577253]

Wed, 13 February 2013 14:35

jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai

Senior Member

Thanks, that was useful for me to find the details of sqlplus sessions. We have EBS R12 and other components running on a different server and on a single node. We have a 3-node clustered database for these applications. We have been informed that one of the nodes will be undergoing an outage. I am trying to check if there are any application process that pointing specific to node. Most the applications are making jdbc connections. How can I make sure if all the applications could failover incase of one of the nodes going down.

I am unable to see the process details for those application services and the process value is null when I executed the query.

[Updated on: Wed, 13 February 2013 14:37]

Report message to a moderator

Re: Unable to find the server process in the oracle database for a specific application/client [message #577255 is a reply to message #577254]

Wed, 13 February 2013 14:51

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

>I am unable to see the process details for those application services and the process value is null when I executed the query.
It is a challenge to say what you are doing wrong when we can't see what you are actually doing.

Report message to a moderator

Previous Topic:	hide url
Next Topic:	PROFILE CREATION DATE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 12 23:22:12 CST 2025