Home » RDBMS Server » Networking and Gateways » Oracle disconnect (Oracle DB 9i,Windows2003 server)
Oracle disconnect [message #529225] Sun, 30 October 2011 01:02 Go to next message
Sami_Younis
Messages: 49
Registered: February 2008
Location: Egypt
Member

When use any client tool like SQLPlus,Toad or Designer..to connect to oracle database i am getting disconnected every 5 minutes or so.... if i am idel.

Can anyone help me?
Thank u in advance,
Sami
Re: Oracle disconnect [message #529226 is a reply to message #529225] Sun, 30 October 2011 01:12 Go to previous messageGo to next message
Sami_Younis
Messages: 49
Registered: February 2008
Location: Egypt
Member

I forgot to mention that i am got ora-03113 after disconnection.
thanks
Re: Oracle disconnect [message #529229 is a reply to message #529226] Sun, 30 October 2011 01:41 Go to previous messageGo to next message
Michel Cadot
Messages: 59087
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is your Oracle version, with 4 decimals?
What is your complete Windows version?
These for both client and server.

Regards
Michel
Re: Oracle disconnect [message #529231 is a reply to message #529229] Sun, 30 October 2011 01:55 Go to previous messageGo to next message
Sami_Younis
Messages: 49
Registered: February 2008
Location: Egypt
Member

Thanks Michel for your reply
Server:
Oracle9i Enterprise Edition Release 9.2.0.5.0
Windows server 2003 R2 Service pack 1
client:
Oracle forms 6i,Toad 8.5.
Windows 7 Enterprise
Re: Oracle disconnect [message #529232 is a reply to message #529231] Sun, 30 October 2011 02:04 Go to previous messageGo to next message
Michel Cadot
Messages: 59087
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
9.2.0.5 is not certified for W2003 R2, upgrade to 9.2.0.8.

Regards
Michel
Re: Oracle disconnect [message #529233 is a reply to message #529232] Sun, 30 October 2011 02:08 Go to previous messageGo to next message
Sami_Younis
Messages: 49
Registered: February 2008
Location: Egypt
Member

Thank u
could u give me the link to download the patch set to upgrade,please?
Re: Oracle disconnect [message #529234 is a reply to message #529233] Sun, 30 October 2011 02:30 Go to previous message
Michel Cadot
Messages: 59087
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is on Metalink/MOS (click on "Patches & Updates" tab).

Regards
Michel
Previous Topic: Firing query to multiple database
Next Topic: configure listener using net manager
Goto Forum:
  


Current Time: Tue Sep 16 20:28:07 CDT 2014

Total time taken to generate the page: 0.13697 seconds