Home » RDBMS Server » Networking and Gateways » client machines unable to connect DB (Oracle linux 2.6)
client machines unable to connect DB [message #521797] Fri, 02 September 2011 02:49 Go to next message
Messages: 181
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
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
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
Messages: 25571
Registered: January 2009
Location: SoCal
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?


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: Sat Aug 19 23:15:20 CDT 2017

Total time taken to generate the page: 0.32301 seconds