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

Method/Step

2. 1

   For example, the error message that may occur when we run Oracle ORA-12545: The connection failed because the target host or object does not exist

4. 2

   Workaround:

   First, start with the basics, right-click on the computer, select Manage

6. 3

   Find the services and applications inside, open the service

8. 4

   As shown ~ found:

   Oracleoradb11g_home1tnslistener

   Oracleserviceorcl

10. 5

    Start these two data services, this is the most basic

12. 6

    Once the data service is started, reconnect again

14. 7

    If this is the same as shown in the prompt content, so the solution is estimated to be a bit of trouble, here you must be the local name of your computer changed

16. 8

    Workaround:

    Open app→ Account →product→11.1.0→db_1→network→admin

    Locate the two files shown in Listener.ora Tnsnames.ora

18. 9

    Click on the two files to make changes to the content (the main changes are as in the area of the red line)

20. 10

    This way, you need to open your computer, find your computer name, and then select Copy

22. 11

    Change the host name in both folders of Listener.ora Tnsnames.ora to your computer name, and then reconnect after the save is complete

24. 12

    If you see a message like the one shown in, here you need to re-start the two services in your Oracle

26. 13

    After the service is started, if you still see the error message, we need to configure your monitoring.

28. 14

    Found in the Start menu,Net Configuration Assistant

30. 15

    Open as shown, select the Listener configuration and click Next

32. 16

    Select reconfigure to go to the next step

34. 17

    Click Next directly

36. 18

    Choose Yes

38. 19

    The selection protocol is typically TCP

40. 20

    Select Use standard port number and click Next

42. 21st

    Select no , go to Next

44. 22

    Listener configuration Complete, click next

46. 23

    Selection complete, configuration complete, restart monitoring service

48. 24

    So that your database can be connected successfully, the above methods hope to help everyone

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