- 08 Nov, 2021
- 0 Comments
- 1 Min Read
ORA-12545: Connect failed because target host or object does not exist
ORA-12545: Connect failed because target host or object does not exist
ORA-12545: Connect failed because target host or object does not exist
Cause: The address specified is not valid, or the program being connected to does not exist.
Action: Ensure the ADDRESS parameters have been entered correctly; the most likely incorrect parameter is the node name. Ensure that the executable for the server exists (perhaps "oracle" is missing.) If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change the host name to a numeric IP address and try again.
1 2 3 4 5 6 7 8 | \data\Users\nimish.garg>sqlplus scott/tiger@MY_DATABASESQL*Plus: Release 11.2.0.3.0 Production on Wed Jun 25 16:38:30 2014Copyright (c) 1982, 2011, Oracle. All rights reserved.ERROR:ORA-12545: Connect failed because target host or object does not existEnter user-name: |
Understanding ORA-12545:
Oracle Client connects a Database using "connect identifier", which is defined in client's tnsnames.ora file. SQLNET then translate "connect identifier" to "connect descriptor" which specifies how to connect to What Server (HOST) using which PROTOCOL and which SERVICE is listener is serving on WHAT port. After this process, this "connect descriptor" information is passed to Network Layer to connect to the Database Server. ORA-12454 occurs usually when TNS is unable to reach HOST defined in ADDRESS parameter of TNSNAMES.ORA.
This error may be due to a network glitch or may be due to some typo error in HOST value in ADDRESS parameter of TNSNAMES.ORA
Resolving ORA-12545:
We can debug ORA-12545 by following steps
1) Verify the TNSNAMES.ORA Entry and validate Host Name
1 2 3 4 5 6 7 8 9 10 | MY_DATABASE = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = my_database.mydomain.co.in)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.mydomain.co.in) ) ) |