I'll increase the SQLNET.EXPIRE_TIME ?
$ sqlplus test/test@db1 SQL*Plus: Release 10.2.0.1.0 - Production on Tue Apr 6 15:58:31 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-03135: connection lost contact Enter user-name:
Now I haven't this problem. I'm checking on the "alert_db1.log" and find this error: "WARNING: inbound connection timed out (ORA-3136)"
$ lsnrctl services db1 LSNRCTL for Solaris: Version 10.2.0.1.0 - Production on 06-APR-2010 15:59:52 Copyright (c) 1991, 2005, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.0.1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=db1))) Services Summary... Service "db1" has 1 instance(s). Instance "db1", status UNKNOWN, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:37975 refused:0 LOCAL SERVER The command completed successfully