My Oracle Support Banner

OCI-C : Dataguard Switchover Fails Tnsping TNS-12545 Connect failed because target host or object does not exist '-nat entry' Missing in hosts (Doc ID 2440794.1)

Last updated on OCTOBER 27, 2019

Applies to:

Oracle Database Cloud Service - Version N/A to N/A [Release 1.0]
Information in this document applies to any platform.

Symptoms

Create Dataguard in OCI Classic environment.

In a Dataguard DBCS configuration the below tns entries are used below

ORCL_01 =
    (DESCRIPTION =
        (ADDRESS =
            (PROTOCOL = TCP)
            (HOST = dg01-nat)
            (PORT = 1532)
        )
        (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SID = ORCL)
        )
    )

# DO NOT EDIT THIS Entry for Host : dg02-nat
ORCL_02 =
    (DESCRIPTION =
        (ADDRESS =
            (PROTOCOL = TCP)
            (HOST = dg02-nat)
            (PORT = 1532)
        )
        (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SID = ORCL)
        )
    )

Dataguard switch over fails with connectivity issue and tnsping also fails

$ tnsping ORCL_01

TNS Ping Utility for Linux: Version 12.2.0.1.0 - Production on 23-AUG-2018 09:08:02
Copyright (c) 1997, 2016, Oracle.  All rights reserved.
Used parameter files:
/u01/app/oracle/product/12.2.0/dbhome_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = dg01-nat) (PORT = 1532)) (CONNECT_DATA = (SERVER = DEDICATED) (SID = ORCL)))
TNS-12545: Connect failed because target host or object does not exist

$ tnsping ORCL_02

TNS Ping Utility for Linux: Version 12.2.0.1.0 - Production on 23-AUG-2018 09:08:02
Copyright (c) 1997, 2016, Oracle.  All rights reserved.
Used parameter files:
/u01/app/oracle/product/12.2.0/dbhome_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = dg02-nat) (PORT = 1532)) (CONNECT_DATA = (SERVER = DEDICATED) (SID = ORCL)))
TNS-12545: Connect failed because target host or object does not exist

missing entry for dataguard, switchover is failing.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.