Home » RDBMS Server » Server Administration » Session Block
Session Block [message #321581] Tue, 20 May 2008 14:54 Go to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member


Hi to all,

I have installed oracle 10g r2 os is windows. The problem in my database is When a user connects to the database and logoff. the session remains in the v$session view. The status shows as inactive. It remains for every user connection and it only releases after i restart the database. AS it is a production db i cannot shutdown and startup.

Can anyone help me..


Thanks in Advance,

Seenu
Re: Session Block [message #321585 is a reply to message #321581] Tue, 20 May 2008 15:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68711
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
The problem in my database is When a user connects to the database and logoff

What tool/application do you use?
Your application must end the session.

Regards
Michel
Re: Session Block [message #321606 is a reply to message #321581] Tue, 20 May 2008 19:39 Go to previous messageGo to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member

Hi michel,


I am using Toad 8.0 and sql plus. I have tried to connect from different applications and after i logoff from that application, the session status remains INACTIVE in the v$session.

Thanks a Lot,

Seenu...
Re: Session Block [message #321610 is a reply to message #321581] Tue, 20 May 2008 19:50 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I have tried to connect from different applications and after i logoff from that application, the session status remains INACTIVE in the v$session.

PROVE it!
Re: Session Block [message #322439 is a reply to message #321610] Fri, 23 May 2008 09:41 Go to previous messageGo to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member


AS you said i have checked if users logout from the session normally then that session is not maintained in V$session.

We are using VPN client to connect to the server.

The problem occurs when VPN is disconnected abnormally then that session is maintained as inactive in v$session.

I have tried it by disconnecting the VPN client.

Thanks in Advance,

Seenu...
Re: Session Block [message #322457 is a reply to message #322439] Fri, 23 May 2008 10:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68711
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Set SQLNET.EXPIRE_TIME

Regards
Michel
Re: Session Block [message #323150 is a reply to message #322457] Tue, 27 May 2008 08:07 Go to previous messageGo to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member
Michel Cadot wrote on Fri, 23 May 2008 10:47
Set SQLNET.EXPIRE_TIME

Regards
Michel




Hi Michel,

As you said i have used SQLNET.EXPIRE_TIME=10 in sqlnet.ora file.

After that i have restarted the database and when i tested by disconnecting VPN. The session remains inactive.

Please consider my problem.

Thanks in Advance,
Seenu
Re: Session Block [message #323175 is a reply to message #321581] Tue, 27 May 2008 10:09 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>The problem occurs when VPN is disconnected abnormally
Then the problem & solution are external to Oracle & must be solved by your networking folks.
Previous Topic: Configuring a new Solaris server for Oracle 10g
Next Topic: Lock in a Row
Goto Forum:
  


Current Time: Sun Nov 10 06:33:26 CST 2024