OraFAQ Forum: Networking and Gateways » client machines unable to connect DB

Home » RDBMS Server » Networking and Gateways » client machines unable to connect DB (Oracle 11.2.0.1.0 linux 2.6)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

client machines unable to connect DB [message #521797]

Fri, 02 September 2011 02:49

kesavansundaram
Messages: 183
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:

Code: [Select all] [Show/ hide]

your database connection has been reset. Any pending transactions or session state has been lost.

in the database server, SQLNET.ORA reads as below:

Code: [Select all] [Show/ hide]

> 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

Report message to a moderator

Re: client machines unable to connect DB [message #521865 is a reply to message #521797]

Fri, 02 September 2011 08:39

BlackSwan
Messages: 26766
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?

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?

Report message to a moderator

Previous Topic:	Oracle Procedural Gateway upgradation for IBM MQ
Next Topic:	Registering a database with OID fails with "invalid directory service credentials"

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 07 13:40:21 CDT 2025