ORA-12545 – Perculiar Case – Host or Object Does Not Exist

ORA-12545 – Perculiar Case – Host or Object Does Not Exist

June 1, 2016

SYMPTOMS

Intermittent occurrence of ORA-12545

All attempts to connect using TNS returned this error particularly attempt to take RMAN backups using two nodes (rman target bkusr/password@TNS)

ERROR

TNS-12545: Connect failed because target host or object does not exist

TROUBLESHOOTING STEPS

— Reviewed TNSNAMES.ORA and LISTENER.ORA
— Compared remote listener and local listener configuration on UEMOA-B instances
— Updated /etc/hosts

CAUSE

From the trace files capture, Oracle was trying to resolve pdc-rac-flexcubetestsf1 (on node 1)
This entry was neither present as hostname in the tnsnames.ora nor listener.ora nor inventory.xml but it is worth mentioning that we had done some makesysb of the live LPAR and used same to build a new UAT. Seriously cannot tie the problem to this task though.

RESOLUTION

— Added the following Entry to the /etc/hosts
— This is a workaround and requires observation e.g. backup should be taken by EOD operator without error

#Added temporarily to address ORA-12545
10.2.X.X pdc-rac-flexcubetestsf1
10.2.X.X pdc-rac-flexcubetestsf2
#Please remove after upgrade to 11g

NB I have removed the actual IP Address

REFERENCE

support.oracle.com

Clients Failing to Connect Due to Intermittent ORA-12545 in RAC Environment (Doc ID 291175.1)

ADDITIONAL INFORMATION

— Partial Output from Trace Files

[26-MAY-2016 01:57:19:937] nsmfr: normal exit
[26-MAY-2016 01:57:19:937] nsclose: normal exit
[26-MAY-2016 01:57:19:937] nscall: connecting…
[26-MAY-2016 01:57:19:937] nsc2addr: entry
[26-MAY-2016 01:57:19:937] nsc2addr: (ADDRESS=(PROTOCOL=TCP)(HOST=pdc-rac-flexcubetestsf1)(PORT=1521))
[26-MAY-2016 01:57:19:937] nttbnd2addr: entry
[26-MAY-2016 01:57:19:937] snlinGetAddrInfo: entry
[26-MAY-2016 01:57:19:937] snlinGetAddrInfo: Invalid IP address string pdc-rac-flexcubetestsf1
[26-MAY-2016 01:57:19:937] snlinFreeAddrInfo: entry
[26-MAY-2016 01:57:19:937] snlinFreeAddrInfo: exit
[26-MAY-2016 01:57:19:937] snlinGetAddrInfo: exit
[26-MAY-2016 01:57:19:937] nttbnd2addr: looking up IP addr for host: pdc-rac-flexcubetestsf1
[26-MAY-2016 01:57:19:937] snlinGetAddrInfo: entry
[26-MAY-2016 01:57:19:939] snlinGetAddrInfo: Name resolution failed for pdc-rac-flexcubetestsf1

— Setting Up Network Tracing
————————————————————————————————–
SQLNET.ORA
————————————————————————————————–

TRACE_LEVEL_CLIENT = SUPPORT
TRACE_UNIQUE_CLIENT = on
TRACE_LEVEL_SERVER = SUPPORT
TRACE_DIRECTORY_CLIENT = /usr/rman/
TRACE_FILE_CLIENT = CLIENT
TRACE_DIRECTORY_SERVER = /usr/rman/
TRACE_FILE_SERVER = SERVER
TRACE_TIMESTAMP_ CLIENT = ON

————————————————————————————————-
LISTENER.ORA
————————————————————————————————-
TRACE_FILE_LISTENER = LISTENER.TRC
TRACE_DIRECTORY_LISTENER = /usr/rman/
TRACE_LEVEL_LISTENER = SUPPORT

Igiri Books © Copyright 2016. All Rights Reserved. Site Credits: AppWorld