This content has been marked as final. Show 3 replies
It looks like the gateway connection has been closed for some reason and then you have tried to use it again in the same session which gives the ORA-28511.
There is a default gateway timeout but that is 20 minutes, whereas you are seeing problem after about 4 minutes and the listener timeout is set to 0.
Do you have any timeout settings configured in sqlnet.ora ?
Hello Mike, your help was of great value.
Actually there was a redundant configuration in SQLNET.ORA, after correcting it the problem stopped.
NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME)
TRACE_LEVEL_CLIENT = OFF
SQLNET.INBOUND_CONNECT_TIMEOUT = 120
SQLNET.INBOUND_CONNECT_TIMEOUT = 0
Thanks for letting us know you fixed the problem.