Skip to content

ORA-16579: bad network state detected

Problem

DGMGRL> show configuration;

Configuration – dg_prmydb_config

Protection Mode: MaxPerformance
Members:
stbydb – Primary database
Error: ORA-16579: bad network state detected

prmydb – Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
ERROR (status updated 0 seconds ago)

DGMGRL> show database stbydb

Database – stbydb

Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
prmydb_1
prmydb_2

Database Status:
DGM-17016: failed to retrieve status for database “stbydb”
ORA-16662: network timeout when contacting a member

 

Solution:

Check alert log file of respective database.

in my case alertlog file shows ASM mount point space exhausted

ORA-19504: failed to create file “+DATA1”
ORA-17502: ksfdcre:4 Failed to create file +DATA1
ORA-15041: diskgroup “DATA1” space exhausted
ARC2: Error 19504 Creating archive log file to ‘+DATA1’

I cleared some space by backup and cleaning up archive log file.

 

 

 

 

 

 

 

 

 

No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: