Home » Server Options » RAC & Failsafe » Limiting Multiple Sessions in RAC
Limiting Multiple Sessions in RAC [message #235547] Mon, 07 May 2007 02:22 Go to next message
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.

Re: Limiting Multiple Sessions in RAC [message #235692 is a reply to message #235547] Mon, 07 May 2007 12:37 Go to previous messageGo to next message
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.

Re: Limiting Multiple Sessions in RAC [message #239181 is a reply to message #235692] Mon, 21 May 2007 12:35 Go to previous message
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
use this parameter in profile

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

Current Time: Fri May 24 20:48:06 CDT 2024