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
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 Go to previous messageGo to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Dec 13 02:16:05 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.