Solved

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

Posted on 2010-08-30
6
1,905 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
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 28

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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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 500 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

757 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now