Last updated on APRIL 24, 2017
Applies to:SQL*Plus - Version 22.214.171.124 to 10.2.0.5 [Release 9.2 to Oracle10g]
IBM z/OS on System z
IBM z/OS (OS/390)
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms