Unable to connect with EZconnect using sqlplus
Error – Not able to connect with EZconnect format using sqlplus.
Error : ORA-12537 | ORA-12545
ORA-12537: TNS: connection closed
ORA-12545: Connect failed because target host or object does not exist
Complete error:
sqlplus ‘User/xxxxxxx@//Hostname:1521/service as sysdba’
SQL*Plus: Release 11.2.0.2.0 Production on Wed Feb 15 18:26:57 2017
error:
ORA-12537: TNS: connection closed
Enter user-name:
ERROR:
ORA-12545: Connect failed because target host or object does not exist
Enter user-name:
ERROR:
ORA-12545: Connect failed because target host or object does not exist
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
How it resolved?
a small change in sqlnet.ora file, have added “Ezconnect” parameter in the file.
See Also: