Oracle ORA-12545: Because the target host or object does not exist

Source: Internet
Author: User

Workaround:

1, first from the most basic start, here to open the computer right-click, select Management

2. Find the services and applications inside, open the service

3. Find:

Oracleoradb11g_home1tnslistener

Oracleserviceorcl

4, start the two data services, this is the most basic

5. Once the data service is started, reconnect again

6, if this is still the "Oracle ORA-12545: Because the target host or object does not exist" prompt content, so the solution is estimated to be a bit of trouble, here you must be the local name of your computer changed

7.

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

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

8, click on the two files to make a change in the content (the last line of parentheses content)

9, this side need you first open your computer to find your computer name, and then select Copy

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

11. If there is a "no listener" prompt message, here you need to re-start your Oracle two services to restart

12, after the service is started, if the "listener currently does not recognize the service requested by the connection descriptor" error message, here we need to configure your monitoring additional

13, found in the Start menu,Net Configuration Assistant

14, open as shown, select the Listener configuration, click Next

15. Select reconfigure to proceed to the next step

16. Click Next Directly

17. Select Yes

18, the choice of the agreement is generally TCP

19, choose to use standard port number, click Next

20, select no , go to the next step

21, the listener configuration is complete, click next

22, the selection is complete, the configuration is complete, restart the monitoring service

23, so that the database can be connected successfully

Oracle ORA-12545: Because the target host or object does not exist

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.