Blog / People and Culture Blog

ORA-12609: TNS: Receive timeout occurred 12 & 19c

Anilkumar Kandepu 1 min read

Sometimes You can get “ORA-12609: TNS: Receive timeout occurred ” error.

Details of error are as follows.

ORA-12609: TNS: Receive timeout occurred
Cause: The receive or read operation did not complete within the allowed time interval.
Action: Check if the peer host is available. Increase the receive timeout value if necessary.
Add this parameter to the sqlnet.ora file at BOTH the origin (or client) and at the Database server / instance:
SQLNET.SEND_TIMEOUT=n

E.g.

SQLNET.SEND_TIMEOUT=300

In my case to solve this error, added the following parameters to the sqlnet.ora file under $ORACLE_HOME/network/admin/

 

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
SQLNET.INBOUND_CONNECT_TIMEOUT=360
SQLNET.RECV_TIMEOUT=10
SQLNET.SEND_TIMEOUT=10


        

        
      

      
    

  

  

    
Related blogs

    

      
  
    
Dataguard manual switchover

    

      Database Blog
      
Dataguard manual switchover

      
Introduction Oracle Data Guard plays a pivotal role in ensuring business continuity by maintaining synchronized standby databases that can seamlessly take over…

      

        Naveen Kandasamy
        
        1 min read
      

    

  
  
    
    

      People and Culture Blog
      
Troubleshooting Query Plan Optimization Using Query Store

      
Introduction SQL Server Query Store is enabled to assist in monitoring query performance and identifying query plan regressions. Query Store captures a history…

      

        Thetchina Moorthy Natarajan
        
        6 min read
      

    

  
  
    
    

      People and Culture Blog
      
When tempdb Won’t Shrink

      
Introduction In SQL Server, the tempdb system database can grow significantly due to heavy workloads, temporary objects, or large queries. Sometimes, even after…

      

        Thetchina Moorthy Natarajan
        
        1 min read