Database Networking (MOSC)

MOSC Banner

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

edited Mar 19, 2010 2:21AM in Database Networking (MOSC) 6 commentsAnswered
 

Hi,

We are using Oracle 11g (Version 11.1.0.7) in AIX 6.1 platform.

Oracle 11g running in RAC mode.

While users connecting to the database, sometimes they are able to connect and sometimes they are getting connections (Error Message and my tnsnames entry are given below).

My question - Is there any parameter need to be changed in database? OR in front end application connection string?


TAF Connection String:

TEST_TAF =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = xx.xxx.xxx.xxx)(PORT = xxxx))
    (ADDRESS = (PROTOCOL = TCP)(HOST = xx.xxx.xxx.xxx)(PORT = xxxx))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORADB1)
      (FAILOVER_MODE =

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center