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:
in the database server, SQLNET.ORA reads as below:
your database connection has been reset. Any pending transactions or session state has been lost.
sqlnet expire time shows 15 min.
> more sqlnet.ora
AUTOMATIC_IPC = ON
names.directory_path = (TNSNAMES,EZCONNECT)
names.default_domain = world
name.default_zone = world
sqlnet.expire_time = 15
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.