My Oracle Support Banner

Error ORA-12545 When Using Tnsnames To Connect From Batch Or Tso (Doc ID 398873.1)

Last updated on FEBRUARY 06, 2020

Applies to:

SQL*Plus - Version 9.2.0.1 to 10.2.0.5 [Release 9.2 to Oracle10g]
IBM z/OS on System z
IBM z/OS (OS/390)


Symptoms

Connecting from BATCH SQLPLUS on Z/OS to a remote database results in:


ORA-12154: TNS:  Could not resolve service name or

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

TNSPING also fails with illegal address parameter

sqlplus using the same tnsnames entry from Unix System Services (USS) works.

Everything in the TNSNAMES entry looks correct:  parentheses match, port number is correct, host name is correct (can be pinged), sid or service_name is correct.

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
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.