?
Solved

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

Posted on 2010-08-30
6
Medium Priority
?
2,057 Views
Last Modified: 2012-05-10
Hi experts,

I have been trying to investigate issue related ORA-12545. The strange thing is whenever I tried to connect oracle 10G R2 RAC database(devsrv) through TOAD then it throws ORA-12545 error. After attempting 3 or 4 times, it will connect to the database. we have several databases are there on these hosts meaning all host IPs in the TNSNAMES.ORA file are same and only service name will be different. When I try to connect database (qasrv) then it never allows me to login to this database.

here is the TNSNAME I'm using to connect database.

AEQASRV=
  (DESCRIPTION=
    (LOAD_BALANCE=yes)
    (ADDRESS_LIST=
      (ADDRESS=
        (PROTOCOL=TCP)
        (HOST=10.100.100.120)
        (PORT=1521)
      )
      (ADDRESS=
        (PROTOCOL=TCP)
        (HOST=10.100.100.121)
        (PORT=1521)
      )
      (ADDRESS=
        (PROTOCOL=TCP)
        (HOST=10.100.100.123)
        (PORT=1521)
      )
    )
    (CONNECT_DATA=
      (FAILOVER_MODE=
        (TYPE=select)
        (METHOD=basic)
        (RETRIES=180)
        (DELAY=5)
      )
      (SERVER=dedicated)
      (SERVICE_NAME=aeqasrv)
    )
  )

One more thing, we have a developer who is accesing same QA database from his machine with out any issues. Is there any network settings do I need to adjust or tweek in order to connect to database? Any help would be appreciated.
 
0
Comment
Question by:KuldeepReddy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 2

Expert Comment

by:j_coreil
ID: 33563852
Check the sqlnet files on both machines and compare them. Another thing to check, I've encountered this in 11g not 10g, is that the problem PC's dns settings are correct. In 11g, there is a known bug where if you cannot get to the primary DNS entry, it will have to timeout first before it attempts the secondary DNS entry. This process can take upwards to 2 minutes per request to the DNS server. So each session you try to open could possibly take forever.
0
 
LVL 29

Expert Comment

by:sammySeltzer
ID: 33563866
hi,

can you try pinging <SERVER_NAME>

If you do not get a response from the server this is your problem. try the same ping with the IP address of the server.

assuming you get a response when you specify the IP address but not the server name then you have a simple problem with DNS names resolution,

Also, check to see if you have virus scanner on that server. It is often guilty of interferring.
0
 
LVL 2

Expert Comment

by:j_coreil
ID: 33563877
Windows Firewall can sometimes be causing this problem. I would only disable it temporarily for testing.
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
LVL 7

Expert Comment

by:sumit2906
ID: 33564051
This could be issue with the client, sometimes having multiple homes could cause issues like this. Also, you can use tnsping <alias> command to know whether your tns settings are fine.
0
 
LVL 6

Expert Comment

by:tangchunfeng
ID: 33564112
1. use hostname not IP address in your oracle tnsnames.ora
2. set hostname/ip pairs in c:\windows\system32\drivers\etc\hosts
0
 
LVL 13

Accepted Solution

by:
riazpk earned 2000 total points
ID: 33565137
I just faced this issue recently. We were getting the same error while trying to connect our RAC Database. The solution is to add vip host name in the DNS (or in the hosts file but i prefer adding it in DNS because you can have more than one client trying to connect to this db and adding entries in DNS will avoid adding entries in hosts file of each client).
Once we did this, everything was perfectly ok.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows how to recover a database from a user managed backup
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question