TNS-12545: Connect failed because target host or object does not exist
Scenario: Change the Linux host name, restart the machine, and start listening for errors
$ lsnrctl start
LSNRCTL for Linux: Version 12.1.0.2.0-production on 26-jul-2017 09:53:42
Copyright (c) 1991, 2014,
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP))(PORT=1521)))
nss-12545: Connect failed because target host or object does not exist
tns-12560: TNS:protocol adapter error
tns-00515: Connect failed because target host or object does not exist
Linux error: 111: Connection container to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
……
solution:
because only the hostname of the machine is changed, but the host and listlisteners. Ora files are not changed. Ora
modify the host file
$vi /etc/hosts
#127.0.0.1 localhost localhost4 localhost4. Localdomain4
#::1 localhost localhost.localdomain Localhost6 localhost6. Localdomain6
127.0.0.1 localhost MWDS
192.168.78.17 meng
modify the listener.
$vi ora file/u01/app/oracle/product/12.1/db1/network/admin/listener. Ora.
# listener ora Network Configuration File:/u01/app/oracle/product/12.1/db1/network/admin/listener. Ora
# Generated by oracle configuration tools.
the listener =
(DESCRIPTION_LIST =
(the DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = meng)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
restart the machine
# reboot
The HOST for tnsnames.ora on the machine also needs to be changed, but the IP address is recommended for this file.
Read More:
- ORA-12545: Connect failed because target host or object does not exist
- JDBC connect to Sql Server to connect to the database–The TCP/IP connection to the host localhost, port 1433 has failed
- [Solved] ERROR Error: No module factory availabl at Object.PROJECT_CONFIG_JSON_NOT_VALID_OR_NOT_EXIST ‘Error
- ansible Q&A: Failed to connect to the host via ssh: ssh_exchange_identification and Authentication or per
- Wrong classification of Python — assertion cur_ Target is greater than or equal to 0 and cur_ Target is less than n_ classes failed
- TCP error code 10061: unable to connect because the target machine actively refused http://localhost :8732/Design_ Time_ Addresses/TeacherHelperServic
- error TS2339:Property ‘length’ does not exist on type ‘object’
- Host is not allowed to connect to this MySQL server
- seaborn.load_ Data set error urlerror: < urlopen error [winerror 10060] the connection attempt failed because the connecting party did not reply correctly after a period of time or the connected host did not respond
- The solution to the problem that the virtual machine and the host SSH can’t connect on vmvare
- Jstack command execution error: unable to open socket file: target process not responding or hotspot VM not loaded
- Cannot connect to MySQL server on “host” (113)
- Failed to connect to Mir:Failed to connect to server socket:No such file or directory
- No data: data: get host by name failed in TCP_ Connect() error resolution
- Python learning notes (5) — cross entropy error runtimeerror: 1D target tensor expected, multi target not supported
- Error “/run/lvm/lvmetad.socket: connect failed: No such file or directory” – but not Grub related
- Using Navicat + premium + 11.1 to connect to PG12 version, error: column c.relhasoids does not exist
- Maven compilation error: package does not exist jar package does not exist
- Gt Report Error ssh:connect to host github.com port 22
- error CS0234: The type or namespace name ‘UI‘ does not exist in the namespace ‘UnityEngine‘