Unanswered: Need help in setting connection time out in Oracle 9i
My firewall is causing problems in that it is causing me to have timeout problems when tyring to start my Oracle 9i database.
The best solution is to reset my connect_timeout taht is to be found in listener.ora. But this has been replaced by initial_retry_timeout (I think) for Oracle 9i.
initial_retry_timeout is to be found in sqlnet.ora in
it is set to 30
#name.initial_retry_timeout = 30
There is another sqlnet.ora file in C:\oracle\ora90\network\ADMIN all these contains is:
It sounds like your problem is you don't want timeouts to occur, but the firewall causes them. Try this. Edit file sqlnet.ora and add the line sqlnet.expire_time = 10 (or any number of seconds.) You must make the same change on your client and server's sqlnet.ora file. This parameter tells client and server to ping each other every N seconds, which tricks the firewall into thinking you are active.