OraFAQ Forum: RAC & Failsafe » Limiting Multiple Sessions in RAC

Home » Server Options » RAC & Failsafe » Limiting Multiple Sessions in RAC

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

Limiting Multiple Sessions in RAC [message #235547]

Mon, 07 May 2007 02:22

samsrikvsk
Messages: 1
Registered: May 2005
Location: India

Junior Member

We have a web based application running on Oracle 9i in RAC(Twin CPU/Two servers) mode.We have created a Profile with Concurrent_session one per user.But we see multiple sessions of the same user in GV$session view.We want to restrict the concurrent sessions per user to use ONE.Can anybody suggest a way how to reoslve this.

Report message to a moderator

Re: Limiting Multiple Sessions in RAC [message #235692 is a reply to message #235547]

Mon, 07 May 2007 12:37

harshad.gohil
Messages: 157
Registered: April 2007
Location: USA

Senior Member

It seems your failover mode is PRECONNECT, that's why you are getting multiple sessions. Check your TAF configuration and change it to BASIC mode.

Regards,
Harshad

Report message to a moderator

Re: Limiting Multiple Sessions in RAC [message #239181 is a reply to message #235692]

Mon, 21 May 2007 12:35

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

use this parameter in profile

sessions_per_user 1

Report message to a moderator

Previous Topic:	solaris 10 + ora10gR2 RAC NOT a success story
Next Topic:	Migrating Oracle10g Failsafe from NT Domain to Active Directory DM

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 08:13:41 CDT 2025