Hello Robert

We had this error by not configuring the local_listener in the spfile.
What happens: If the listener initiates a failover to the second node, because it is not serving the required service the domain name is not provided to the client. When you configure load_balance=yes in your tns_names string this ends in a intermittent problem behaviour. As long as yous tay in the same dns domain no problem. When you define a local_listener the domain will as well be provided.
2'nd Workaround: insert the VIP IP as alias into your dns that every client in your network can access the vip without domain.

Regards Beat

-------- Original-Nachricht --------
Datum: Fri, 8 Sep 2006 12:36:09 +0200
Von: "Robert Scheckle" <RobertS@(protected)>
An: suse-oracle@(protected)
Betreff: [suse-oracle] ORA-12545: Connect failed because target host or object does not   exist

> Hi All;
>
>
>
> I have setup my 2 node 10GR2 Cluster.
>
>
>
> I get the following intermittent error when connection from a Linux
> client server.
>
>
>
> Program stopped at 'mem_info.4gl', line number 211.
>
> SQL statement error number -6372 (-12545).
>
> ORA-12545: Connect failed because target host or object does not exist
>
>
>
> This intermittent error also occurs when using sqlplus from the same
> client.
>
>
>
> I have not had this error on my windows client.
>
>
>
> The Linux client tnsnames file looks like this.
>
>
>
> ORAADMIN =
>
>  (DESCRIPTION =
>
>   (ADDRESS = (PROTOCOL = TCP)(HOST = oradbn1-vip.mxgroup.co.za)(PORT =
> 1521))
>
>   (ADDRESS = (PROTOCOL = TCP)(HOST = oradbn2-vip.mxgroup.co.za)(PORT =
> 1521))
>
>   (LOAD_BALANCE = yes)
>
>   (CONNECT_DATA =
>
>     (SERVER = DEDICATED)
>
>     (SERVICE_NAME = oraadmin.mxgroup.co.za)
>
>   )
>
>  )
>
>
>
> Where do I start looking?
>
>
>
> Robert Scheckle
>
> Database Administrator
>
>
>
> AgilityTechnologies                  
> Tel: (012) 673 8595      
> Email: roberts@(protected)  
>
> The information on this e-mail is confidential and is legally
> privileged. This e-mail is intended solely for the addressee. Access to
> this e-mail by anyone else is unauthorized and as such any disclosure,
> copying, distribution or any action taken or omitted in reliance on this
> is prohibited and may be unlawful. No liability or responsibility
> whatsoever is accepted if information or data is, for whatever reason,
> corrupted or does not reach its intended destination.          
>
> The views expressed in this document are the views of the individual
> sender
>
>
>
>
> >
> The information on this e-mail including any attachments relates to the
> official business of Agility (Pty) Ltd. The information is confidential and
> legally privileged and is intended solely for the addressee. Access to this
> e-mail by anyone else is unauthorised and as such any disclosure, copying,
> distribution or any action taken or omitted in reliance on it is unlawful.
> Please notify the sender immediately if it has inadvertently reached you
> and do not read, disclose or use the content in any way.
> >
> No responsibility whatsoever is accepted by Agility (Pty) Ltd if the
> information is, for whatever reason, corrupted or does not reach its intended
> destination. The views expressed in this e-mail are the views of the
> individual sender and should in no way be construed as the views of Agility (Pty)
> Ltd, except where the sender has specifically stated them to be the views
> of Agility (Pty) Ltd.
> >
> http://196.33.167.71/digicare
>

--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting