Home » RDBMS Server » Networking and Gateways » client machines unable to connect DB (Oracle 11.2.0.1.0 linux 2.6)
client machines unable to connect DB [message #521797] Fri, 02 September 2011 02:49 Go to next message
kesavansundaram
Messages: 165
Registered: October 2007
Location: MUMBAI
Senior Member

Dear Sir/Madam,
Database is up and running and client machines able to do TNSPING; But when users try to connect the database thro SQL DEVELOPER, they are getting below information:

your database connection has been reset. Any pending transactions or session state has been lost.
in the database server, SQLNET.ORA reads as below:

> more sqlnet.ora
AUTOMATIC_IPC = ON
names.directory_path = (TNSNAMES,EZCONNECT)
names.default_domain = world
name.default_zone = world
sqlnet.expire_time = 15
sqlnet expire time shows 15 min.

any other area i should check further ? normally this error willbe suppressed if user tried after some time. But now we get this error for more than 2 hrs.

Please guide me.

Thank you
kesavan
Re: client machines unable to connect DB [message #521865 is a reply to message #521797] Fri, 02 September 2011 08:39 Go to previous message
BlackSwan
Messages: 22783
Registered: January 2009
Senior Member
OK, I'll volunteer to be the javelin catcher.

REAL Oracle errors come with an error code, like ORA-01555, so what is error code for this message?

http://devcentral.f5.com/Community/GroupDetails/tabid/1082223/asg/63/aft/1174234/showtab/groupforums/Default.aspx

is BIG5 deployed at your site?

Are only SQL Developer clients impacted?

Does this error occur upon initial connection request or after a successful connection?

does error occur when using different client, like SQL*Plus?
Previous Topic: Oracle Procedural Gateway upgradation for IBM MQ
Next Topic: Registering a database with OID fails with "invalid directory service credentials"
Goto Forum:
  


Current Time: Wed Sep 17 03:20:18 CDT 2014

Total time taken to generate the page: 0.05988 seconds