Home » Server Options » RAC & Failsafe » User Applications in RAC (Oracle 10g R2,Linux AS4, CW 2:1)
User Applications in RAC [message #384610] Wed, 04 February 2009 08:16 Go to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hello,

How to Stop all user applications that use the Oracle RAC home directory?

We want to the CPUJAN2009 patching on our RAC database. How to find out what all user applications are using the database and the Oracle RAC Home Directory.

Regards,

Raj
Re: User Applications in RAC [message #384612 is a reply to message #384610] Wed, 04 February 2009 08:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Shutdown the database?

Regards
Michel
Re: User Applications in RAC [message #384618 is a reply to message #384612] Wed, 04 February 2009 08:50 Go to previous messageGo to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Actually in the Oracle Doc

http://download.oracle.com/docs/cd/B19306_01/rac.102/b28759/softpatch.htm#CHDCHIJG ,

they gave while Patching for RAC instances , we need to first shut all the applications using that particular database , then shut the database, ASM and finally the nodeapps.

So, I just wanted to know how do we shut all the applications using that database.

Re: User Applications in RAC [message #384622 is a reply to message #384618] Wed, 04 February 2009 09:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Query v$session.

Regards
Michel
Re: User Applications in RAC [message #384691 is a reply to message #384622] Wed, 04 February 2009 21:26 Go to previous messageGo to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
When we query v$session , it shows me only the SID but not the name of the application .

Anyother way apart from that.

kindly help me out.
Re: User Applications in RAC [message #384703 is a reply to message #384610] Wed, 04 February 2009 22:22 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>When we query v$session , it shows me only the SID but not the name of the application .

What do you mean by "name of the application"?
How is an application "named"?
Does every application require to have a name?


You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you & please be consistent & correct in your postings.

Post DDL for tables.
Post DML for test data.

Post expected/desired results.
Re: User Applications in RAC [message #384750 is a reply to message #384691] Thu, 05 February 2009 00:56 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
When we query v$session , it shows me only the SID but not the name of the application .

Anyother way apart from that.

There is more than one column in v$session.

Regards
Michel
Previous Topic: Oracle RAC on hp-ux problem!
Next Topic: CRS-1028: Dependency ...of: CRS-0223: Resource 'ora.rac1.LISTENER_RAC1.lsnr
Goto Forum:
  


Current Time: Sat Dec 03 04:20:25 CST 2016

Total time taken to generate the page: 0.08618 seconds