Tuesday, January 17, 2023

Error: ORA-16662: network timeout when contacting a member : DGMGRL

 

Error: ORA-16662: network timeout when contacting a member


DGMGRL>

DGMGRL> show configuration


Configuration - prod_ddb


  Protection Mode: MaxPerformance

  Members:

  ddb_dr - Primary database

    ddb    - Physical standby database

      Error: ORA-16662: network timeout when contacting a member


Fast-Start Failover:  Disabled


Configuration Status:

ERROR   (status updated 47 seconds ago)


DGMGRL>



SQL> select

dest_name,

status,

error

from

v$archive_dest

where

status='ERROR'

;  2    3    4    5    6    7    8    9


DEST_NAME

--------------------------------------------------------------------------------

STATUS    ERROR

--------- -----------------------------------------------------------------

LOG_ARCHIVE_DEST_2

ERROR     ORA-16198: Timeout incurred on internal channel during remote

          archival



Workaround 

EDIT DATABASE 'ddb' SET PROPERTY NetTimeout = 60; 


EDIT DATABASE 'ddb_dr' SET PROPERTY NetTimeout = 60; 

No comments:

Post a Comment

Is CPU issue ? troubleshooting workflow for oracle database performance issue with automation

✅ ✅ 1. CPU Troubleshooting Framework (Like iostat for CPU) Use: vmstat 2 5 or top 📊 ✅ 2. CPU Metrics Explained (vmstat / top) us sy id wa s...